<output id="qn6qe"></output>

    1. <output id="qn6qe"><tt id="qn6qe"></tt></output>
    2. <strike id="qn6qe"></strike>

      亚洲 日本 欧洲 欧美 视频,日韩中文字幕有码av,一本一道av中文字幕无码,国产线播放免费人成视频播放,人妻少妇偷人无码视频,日夜啪啪一区二区三区,国产尤物精品自在拍视频首页,久热这里只有精品12

      ORA-00800

      1. 現(xiàn)象

      手動(dòng)啟動(dòng)oracle instance時(shí),日志中出現(xiàn)很多[LMS*]進(jìn)程報(bào)錯(cuò),類似如下:

      Errors in file /u01/app/oracle/diag/rdbms/boss/boss1/trace/boss1_vktm_93651.trc  (incident=144083) (PDBNAME=CDB$ROOT):
      ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
      ......
      Errors in file /u01/app/oracle/diag/rdbms/boss/boss1/trace/boss1_lmst_93855_93869.trc  (incident=240067):
      ORA-00800: soft external error, arguments: [Set Priority Failed], [LMST], [Check traces and OS configuration], [Check Oracle document and MOS notes], []
      

      2. 原因分析

      [oracle@xxxx trace]$ oerr ora 800
      00800, 00000, "soft external error, arguments: [%s], [%s], [%s], [%s], [%s]"
      // *Cause:  An improper system configuration or setting resulted in failure.
      //          This failure is not fatal to the instance at the moment, however, this might result
      //          in an unexpected behavior during query execution.
      // *Action: Check the database trace files and rectify system settings or the configuration.
      //          For additional information, refer to Oracle database documentation or refer to
      //          My Oracle Support (MOS) notes.
      

      從Oracle官方提供的這個(gè)提示來看,原因是系統(tǒng)配置不正確或者配置未生效引起的。這個(gè)錯(cuò)誤并不是致命的,但是在后期的查詢操作中可能會(huì)胡異常。

      由于信息不明確,也沒有提示是哪個(gè)錯(cuò)誤信息。只能查MOS了。

      3. MOS搬遷

       

      3.1. Cause

      19c configured on OL7/UEK4. UEK4 requires rt_period and rt_runtime set for the cgroup from where the database is started.
      Typically the root one unless the customer is setting up their own cgroups or using system user slices.
      It requires the proper values such as the 95%. For this problem, ORA-800 will have the following message in the incident.
      

      3.2. Solution

      This Note is for ORA-800[VKTM] issues. If you are facing only warning messages like below, Then follow Note 1347586.1 for Solution Time drift detected. Please check VKTM trace file for more details.Warning: VKTM detected a time drift

      3.2.1. ORADISM Permission:

      Check the oradism permission in $ORACLE_HOME/bin. It should be owned by root and sticky bit set. Oradism should be owned by root:oinstall with permission of 4750.

      $ cd $ORACLE_HOME/bin
      $ ls -lrt oradism
      -rwsr-x--- 1 root oinstall 147848 Apr 17 2019 oradism
      

      You can change the permission as below:

      chown root $ORACLE_HOME/bin/oradism
      chmod 4750 $ORACLE_HOME/bin/oradism
      

      3.2.2. Check the priority of VKTM or LMS* @RDBMS level:

      Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
      Version 19.28.0.0.0
      SQL> set lines 200 pages 20
      SQL> col parameter for a30
      col "Session Value" for a15
      SQL> SQL> col "Instance Value" for a15
      SQL> col "Description" for a40
      SQL> select a.ksppinm "Parameter", b.ksppstvl "Session Value", c.ksppstvl "Instance Value", a.KSPPDESC "Description" from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm like '_%' and a.ksppinm like '_highest_priority_process%';
      
      Parameter                      Session Value   Instance Value  Description
      ------------------------------ --------------- --------------- ----------------------------------------
      _highest_priority_processes    VKTM|CTWR       VKTM|CTWR       Highest Priority Process Name Mask
      

      If not "VKTM" is not prioritized, please elevate the priority using below SQL

      SQL> alter system set "_high_priority_processes"'VKTM' scope=spfile;=

      Restart the Database and verify VKTM is elevated or not.

      3.2.3. Cgroup Configuration

      After setting the above, still you have error for vktm then we need to verify the cgroup configuration.

      Note: The above looks good or configured proper and it still fails. In which case, the instance might be running in some other cgroup.

      You can find PID of VKTM of database which has problem :

      The instance might be running in some other cgroup. Check the VKTMs cpu cgroups.

      cat /proc/<vktm pid>/cgroup | grep cpu

      If it shows some other path ( other than root such as 7:cpu,cpuacct:/ ), then make sure that the required cgroup is having the correct settings.

      Try for VKTM :

      -bash-4.1$ ps -eaf|grep -i vktm |grep -v grep
      oracle 15722 1 29 Sep05 ? 06:49:05 ora_vktm_orcl12102
      oracle 18110 1 0 13:33 ? 00:00:01 ora_vktm_orcl12201
      

      If it shows some other path ( other than root such as 7:cpu,cpuacct:/ ), then make sure that the required cgroup is having the correct settings

      If customer has below settings, For the vtkm process

      SID= > cat /proc/60698/cgroup | grep cpu

      6:cpuset:/
      2:cpuacct,cpu:/user.slice
      

      Kindly do the following settings

      1. echo 0 > /sys/fs/cgroup/cpu,cpuacct/system.slice/cpu.rt_runtime_us
      2. echo 950000 > /sys/fs/cgroup/cpu,cpuacct/user.slice/cpu.rt_runtime_us
      

      Execute the below commands and then retry alter system set "_high_priority_processes"'VKTM' scope=spfile;=

      Restart the database and check ORA-800 resolved or not.

      3.2.4. Priority and Runtime

      Still ORA-800 occurs then you can use following commands to check priority and runtime[RR]

      #ps -eLo 'pid tid cls pri cmd comm cgroup' | egrep 'TID|vktm' |grep -v grep [ from oracle user]

      For example :

      -bash-4.2$ ps -eLo 'pid tid cls pri cmd comm cgroup' | egrep 'TID|vktm' |grep -v grep
      
      PID TID CLS PRI CMD COMMAND CGROUP
      8902 8902 TS 19 ora_vktm_db193cdb ora_vktm_db193c 6:devices:/system.slice/oracle-database.service,5:cpu,cpuacct:/system.slice,1:name=systemd:/system.slice/oracle-database.service
      9332 9332 TS 19 ora_vktm_orcl19c ora_vktm_orcl19 6:devices:/system.slice/oracle-database.service,5:cpu,cpuacct:/system.slice,1:name=systemd:/system.slice/oracle-database.service
      

      Here CLS and PRI is having incorrect value (TS and 19) but the correct value is RR and 41.

      To the know the value please use

      cgget system.slice or cgget user.slice [ based on customer environment cpu,cpuacct:/system.slic OR cpu,cpuacct:/user.slice]

      Run the below command to set the correct value

      A)  If it is user.slice:
      echo 0 > /sys/fs/cgroup/cpu,cpuacct/system.slice/cpu.rt_runtime_us
      echo 950000 > /sys/fs/cgroup/cpu,cpuacct/user.slice/cpu.rt_runtime_us
      
      Or
      
      cgset -r cpu.rt_runtime_us=950000 user.slice  >> root user command
      B) if it is system.slice :
      echo 0 > /sys/fs/cgroup/cpu,cpuacct/user.slice/cpu.rt_runtime_us
      echo 950000 > /sys/fs/cgroup/cpu,cpuacct/system.slice/cpu.rt_runtime_us
      
      or
      
      cgset -r cpu.rt_runtime_us=950000 system.slice
      
      
      • stop and start the database to pick the changes by vktm

      check the CLS and PRI, [ CLS is RR (realtime) and priority is 41 ]

      -bash-4.2$ ps -eLo 'pid tid cls pri cmd comm cgroup' | egrep 'TID|vktm' |grep -v grep
      
      PID TID CLS PRI CMD COMMAND CGROUP
      18876 18876 RR 41 ora_vktm_db193cdb ora_vktm_db193c 6:devices:/system.slice/oracle-database.service,5:cpu,cpuacct:/system.slice,1:name=systemd:/system.slice/oracle-database.service
      19287 19287 RR 41 ora_vktm_orcl19c ora_vktm_orcl19 6:devices:/system.slice/oracle-database.service,5:cpu,cpuacct:/system.slice,1:name=systemd:/system.slice/oracle-database.service
      
      

      3.2.5. "nosuid" option :

      Please check the mount having the oradism binary is having "nosuid" option set. If having "nosuid" option, please unset this option.
      Even if the permissions are proper and kernel configurations are fine, the oradism execution as root user will not be honored by root.
      Check the mount option for this case.

      3.2.6. Oradism and Oracle binary permission difference:

      Sometimes oradism and oracle binary will have different permissions (see bug31909951).
      For example, the oracle and oradism will have permissions as below
      e5pod-2vzxt1: -rwsr-s–x 1 oracle asmadmin 450717448 Sep 20 22:16 oracle
      e5pod-2vzxt1: -rwsr-x— 1 root oinstall 147752 Aug 26 17:13 oradism
      Since oracle binary group does not match oradism it fails with error [dism:16]
      As a solution, you need to fix oradism to be in the same group as oracle binary.

      After setting the above changes, still you are getting ORA-800 then you may be hitting the following bugs.

      3.2.7. Apply this patch - Bug 34318125 - ORA-00800: SOFT EXTERNAL ERROR, ARGUMENTS: [SET PRIORITY FAILED] ON BG PROCESSES

      ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM], [Check traces and OS configuration], [Check Oracle document and MOS notes], []

      ======= Dump for incident 763248 (ORA 800) ====== [TOC00003] –— Beginning of Customized Incident Dump(s) –— ksesethighpri: (ksb.c:9896) Failed to elevate VKTM's priority from 0 to 1, policy 3 >>>>>>>>>>>>>>>>>>>>>> Error Info: Category(-2), Opname(skgdism_send), Loc(sp.c:setpr:0), ErrMsg(Operation not permitted) Dism(128) –— End of Customized Incident Dump(s) –—

      3.2.8. Apply this merge patch - Bug 34286265 Bug 34318125 Bug 34672698

      ORA-00800: soft external error, arguments: [Set Priority Failed], [VKTM],[Check traces and OS configuration], [Check Oracle document and MOS notes],

      ======= Dump for incident 1041281 (ORA 800) ====== –— Beginning of Customized Incident Dump(s) –— ksesethighpri: (ksb.c:9893) Failed to elevate VKTM's priority from 0 to 1, policy 3

      Error Info: Category(-2), Opname(skgdism_create), Loc(sp.c:setpr:1), ErrMsg(Error 0) Dism(16)

      4. 疑問

      1. 為啥通過 srvctl start database 不會(huì)報(bào)錯(cuò)呢?
      2. 既然cgroup 配置有問題,為啥安裝文檔里沒有要求安裝 libcgroup-tools ?

       

      posted @ 2025-09-14 19:54  halberd.lee  閱讀(24)  評(píng)論(0)    收藏  舉報(bào)
      主站蜘蛛池模板: 色五月丁香六月欧美综合| 精品国产中文字幕懂色| 一本色道久久综合亚洲精品| 无套内谢少妇毛片aaaa片免费| 自拍第一区视频在线观看| 国产极品美女网站在线观看| 亚洲精品韩国一区二区| 亚洲一区二区三区18禁| 久久精品伊人波多野结衣| 精品国产免费一区二区三区香蕉| 国产一区二区三区综合视频| 国产精品福利自产拍久久 | 野外做受三级视频| 扒开女人内裤猛进猛出免费视频 | 亚洲熟妇少妇任你躁在线观看无码| 亚洲精品久久国产高清小说| 久久一区二区中文字幕| 宜城市| 亚洲成av人片天堂网| 好吊妞人成视频在线观看| 久女女热精品视频在线观看| 美女黄网站人色视频免费国产| 日韩精品亚洲 国产| 国产在线一区二区不卡| 亚洲最大av一区二区| 午夜视频免费试看| 亚洲大尺度无码无码专线| 91精品久久一区二区三区| 色综合天天综合天天综| 国厂精品114福利电影免费| 国产精品欧美福利久久| 国产l精品国产亚洲区| 人人爽人人爽人人片a免费| 天天做日日做天天添天天欢公交车| 在线 欧美 中文 亚洲 精品| 亚洲成人一区二区av| 亚洲精品国产美女久久久| 亚洲精品色哟哟一区二区 | 精品国产美女av久久久久| 中文日韩在线一区二区| 欧美老少配性行为|