小鸡也疯狂 2018-10-24 09:10 采纳率: 100%
浏览 1160
已采纳

oracle自动关闭,提示ORA-27300

系统是centos7,oracle自动关闭后内存和硬盘使用情况:

[root@wjdb ~]# free -m
total       used       free     shared    buffers     cached
Mem:         64267      62984       1283         16        277      60243
-/+ buffers/cache:       2462      61804
Swap:        35839          0      35839

[root@wjdb ~]# df -hl
Filesystem                Size  Used Avail Use% Mounted on
/dev/vda1                  40G   27G   11G  73% /
devtmpfs                   32G     0   32G   0% /dev
tmpfs                      32G   84K   32G   1% /dev/shm
tmpfs                      32G   17M   32G   1% /run
tmpfs                      32G     0   32G   0% /sys/fs/cgroup
/dev/mapper/centosVG-tmp   25G   45M   24G   1% /tmp
/dev/mapper/centosVG-rac  1.1T  958G  113G  90% /data
tmpfs                     6.3G  4.0K  6.3G   1% /run/user/0

网上说修改logind.conf文件,但问题依旧

[root@wjdb ~]# cat /etc/systemd/logind.conf 
[Login]
RemoveIPC=on

登录oracle出现如下错误

Last login: Wed Oct 24 18:30:35 CST 2018 on pts/0

[oracle@wjdb ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 24 18:54:06 2018
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> select * from dual;
select * from dual
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

检查trace目录的日志文件,如下:

 Starting background process CJQ0
Mon Oct 22 23:45:08 2018
CJQ0 started with pid=43, OS id=2409
Archived Log entry 2777 added for thread 1 sequence 2783 ID 0xa5f27e dest 1:
Mon Oct 22 23:45:08 2018
db_recovery_file_dest_size of 409600 MB is 52.01% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Setting Resource Manager plan SCHEDULER[0x3003]:DEFAULT_MAINTENANCE_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
Mon Oct 22 23:45:11 2018
Starting background process VKRM
Mon Oct 22 23:45:11 2018
VKRM started with pid=41, OS id=2411
Mon Oct 22 23:53:18 2018
Starting background process SMCO
Mon Oct 22 23:53:18 2018
SMCO started with pid=1030, OS id=12564
Tue Oct 23 02:00:00 2018
Clearing Resource Manager plan via parameter
Tue Oct 23 08:00:17 2018
Thread 1 advanced to log sequence 2785 (LGWR switch)
  Current log# 4 seq# 2785 mem# 0: /data/oracle/oradata/wjdb/redo04.log
Tue Oct 23 08:00:30 2018
Archived Log entry 2778 added for thread 1 sequence 2784 ID 0xa5f27e dest 1:
Tue Oct 23 16:02:53 2018
Thread 1 advanced to log sequence 2786 (LGWR switch)
  Current log# 1 seq# 2786 mem# 0: /data/oracle/oradata/wjdb/redo01.log
Tue Oct 23 16:03:06 2018
Archived Log entry 2779 added for thread 1 sequence 2785 ID 0xa5f27e dest 1:
Tue Oct 23 19:07:01 2018
Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_j000_20537.trc:
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
Tue Oct 23 19:07:01 2018
Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_dbrm_2317.trc:
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
DBRM (ospid: 2317): terminating the instance due to error 27157
Tue Oct 23 19:07:01 2018
Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_j001_20539.trc:
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
Tue Oct 23 19:07:01 2018
Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_q000_2418.trc:
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
Instance terminated by DBRM, pid = 2317
Errors in file /data/oracle/diag/rdbms/wjdb/wjdb/trace/wjdb_dbrm_2317.trc:
ORA-27300: OS system dependent operation:semctl failed with status: 22
ORA-27301: OS failure message: Invalid argument
ORA-27302: failure occurred at: sskgpwrm1
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
Tue Oct 23 19:07:04 2018
Instance termination got error 27120 from SGA destruction.
  Error cleared. Process exiting.

wjdb_j000_20537.trc内容如下

7f30aa2c8000-7f30aa2cb000 r-xp 00000000 fd:01 143235                     /usr/lib64/libdl-2.17.so
7f30aa2cb000-7f30aa4ca000 ---p 00003000 fd:01 143235                     /usr/lib64/libdl-2.17.so
7f30aa4ca000-7f30aa4cb000 r-xp 00002000 fd:01 143235                     /usr/lib64/libdl-2.17.so
7f30aa4cb000-7f30aa4cc000 rwxp 00003000 fd:01 143235                     /usr/lib64/libdl-2.17.so
7f30aa4cc000-7f30aa4cd000 r-xp 00000000 fd:01 136896                     /usr/lib64/libaio.so.1.0.1
7f30aa4cd000-7f30aa6cc000 ---p 00001000 fd:01 136896                     /usr/lib64/libaio.so.1.0.1
7f30aa6cc000-7f30aa6cd000 r-xp 00000000 fd:01 136896                     /usr/lib64/libaio.so.1.0.1
7f30aa6cd000-7f30aa6ce000 rwxp 00001000 fd:01 136896                     /usr/lib64/libaio.so.1.0.1
7f30aa6ce000-7f30aa73d000 r-xp 00000000 fc:01 37623267                   /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so
7f30aa73d000-7f30aa83d000 ---p 0006f000 fc:01 37623267                   /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so
7f30aa83d000-7f30aa84f000 rwxp 0006f000 fc:01 37623267                   /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so
7f30aa84f000-7f30aa850000 rwxp 00000000 00:00 0
7f30aa850000-7f30aa85b000 r-xp 00000000 fc:01 37622977                   /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so
7f30aa85b000-7f30aa95a000 ---p 0000b000 fc:01 37622977                   /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so
7f30aa95a000-7f30aa95b000 rwxp 0000a000 fc:01 37622977                   /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so
7f30aa95b000-7f30aa9f3000 r-xp 00000000 fc:01 37622976                   /data/oracle/product/11.2.0/db_1/lib/libocrb11.so
7f30aa9f3000-7f30aaaf3000 ---p 00098000 fc:01 37622976                   /data/oracle/product/11.2.0/db_1/lib/libocrb11.so
7f30aaaf3000-7f30aaaf5000 rwxp 00098000 fc:01 37622976                   /data/oracle/product/11.2.0/db_1/lib/libocrb11.so
7f30aaaf5000-7f30aab8e000 r-xp 00000000 fc:01 37622975                   /data/oracle/product/11.2.0/db_1/lib/libocr11.so
7f30aab8e000-7f30aac8d000 ---p 00099000 fc:01 37622975                   /data/oracle/product/11.2.0/db_1/lib/libocr11.so
7f30aac8d000-7f30aac8f000 rwxp 00098000 fc:01 37622975                   /data/oracle/product/11.2.0/db_1/lib/libocr11.so
7f30aac8f000-7f30aac91000 r-xp 00000000 fc:01 37619552                   /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so
7f30aac91000-7f30aad90000 ---p 00002000 fc:01 37619552                   /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so
7f30aad90000-7f30aad91000 rwxp 00001000 fc:01 37619552                   /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so
7f30aad91000-7f30ab1b9000 r-xp 00000000 fc:01 37622972                   /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so
7f30ab1b9000-7f30ab2b9000 ---p 00428000 fc:01 37622972                   /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so
7f30ab2b9000-7f30ab2cb000 rwxp 00428000 fc:01 37622972                   /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so
7f30ab2cb000-7f30ab2cf000 rwxp 00000000 00:00 0
7f30ab2cf000-7f30ab2f1000 r-xp 00000000 fc:01 37619532                   /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so
7f30ab2f1000-7f30ab3f0000 ---p 00022000 fc:01 37619532                   /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so
7f30ab3f0000-7f30ab3f2000 rwxp 00021000 fc:01 37619532                   /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so
7f30ab3f2000-7f30ab409000 r-xp 00000000 fc:01 37622974                   /data/oracle/product/11.2.0/db_1/lib/libclsra11.so
7f30ab409000-7f30ab509000 ---p 00017000 fc:01 37622974                   /data/oracle/product/11.2.0/db_1/lib/libclsra11.so
7f30ab509000-7f30ab50a000 rwxp 00017000 fc:01 37622974                   /data/oracle/product/11.2.0/db_1/lib/libclsra11.so
7f30ab50a000-7f30ab78f000 r-xp 00000000 fc:01 37623084                   /data/oracle/product/11.2.0/db_1/lib/libnnz11.so
7f30ab78f000-7f30ab88e000 ---p 00285000 fc:01 37623084                   /data/oracle/product/11.2.0/db_1/lib/libnnz11.so
7f30ab88e000-7f30ab8d1000 rwxp 00284000 fc:01 37623084                   /data/oracle/product/11.2.0/db_1/lib/libnnz11.so
7f30ab8d1000-7f30ab8d2000 rwxp 00000000 00:00 0
7f30ab8d2000-7f30ab8d9000 r-xp 00000000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f30ab8d9000-7f30abad8000 ---p 00007000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f30abad8000-7f30abad9000 r-xp 00006000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f30abad9000-7f30abada000 rwxp 00007000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f30abada000-7f30abb91000 r-xp 00000000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f30abb91000-7f30abc91000 ---p 000b7000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f30abc91000-7f30abc93000 rwxp 000b7000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f30abc93000-7f30abce2000 r-xp 00000000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f30abce2000-7f30abde1000 ---p 0004f000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f30abde1000-7f30abde9000 rwxp 0004e000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f30abde9000-7f30abe0a000 r-xp 00000000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f30abe10000-7f30abe45000 r-xs 00000000 fd:01 401548                     /var/db/nscd/hosts
7f30abe45000-7f30abef7000 rwxp 00000000 00:00 0
7f30abf04000-7f30abf06000 rwxs 00000000 00:0a 44872319                   /[aio] (deleted)
7f30abf06000-7f30abf07000 rwxp 00000000 00:00 0
7f30abf07000-7f30abf08000 r-xp 00000000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f30abf08000-7f30ac008000 ---p 00001000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f30ac008000-7f30ac009000 rwxp 00001000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f30ac009000-7f30ac00a000 rwxp 00000000 00:00 0
7f30ac00a000-7f30ac00b000 r-xp 00021000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f30ac00b000-7f30ac00c000 rwxp 00022000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f30ac00c000-7f30ac00d000 rwxp 00000000 00:00 0
7fffa52c6000-7fffa52fa000 rwxp 00000000 00:00 0                          [stack]
7fffa53fe000-7fffa5400000 r-xp 00000000 00:00 0                          [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
******************* End of process map dump ************
Unexpected error 27157 in job slave process
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1


wjdb_dbrm_2317.trc内容如下

7f2cbbad0000-7f2cbbad1000 rwxp 00007000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f2cbbad1000-7f2cbbb88000 r-xp 00000000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f2cbbb88000-7f2cbbc88000 ---p 000b7000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f2cbbc88000-7f2cbbc8a000 rwxp 000b7000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f2cbbc8a000-7f2cbbcd9000 r-xp 00000000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f2cbbcd9000-7f2cbbdd8000 ---p 0004f000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f2cbbdd8000-7f2cbbde0000 rwxp 0004e000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f2cbbde0000-7f2cbbe01000 r-xp 00000000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f2cbbe07000-7f2cbbe3c000 r-xs 00000000 fd:01 401548                     /var/db/nscd/hosts
7f2cbbe3c000-7f2cbbeee000 rwxp 00000000 00:00 0
7f2cbbefa000-7f2cbbefb000 rwxs 00000000 fc:01 37492061                   /data/oracle/product/11.2.0/db_1/dbs/hc_wjdb.dat
7f2cbbefb000-7f2cbbefd000 rwxs 00000000 00:0a 26080                      /[aio] (deleted)
7f2cbbefd000-7f2cbbefe000 rwxp 00000000 00:00 0
7f2cbbefe000-7f2cbbeff000 r-xp 00000000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f2cbbeff000-7f2cbbfff000 ---p 00001000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f2cbbfff000-7f2cbc000000 rwxp 00001000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f2cbc000000-7f2cbc001000 rwxp 00000000 00:00 0
7f2cbc001000-7f2cbc002000 r-xp 00021000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f2cbc002000-7f2cbc003000 rwxp 00022000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f2cbc003000-7f2cbc004000 rwxp 00000000 00:00 0
7fff386d3000-7fff38705000 rwxp 00000000 00:00 0                          [stack]
7fff387fe000-7fff38800000 r-xp 00000000 00:00 0                          [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
******************* End of process map dump ************
error 27157 detected in background process
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1

*** 2018-10-23 19:07:01.746
DBRM (ospid: 2317): terminating the instance due to error 27157

*** 2018-10-23 19:07:04.048
ORA-27300: OS system dependent operation:semctl failed with status: 22
ORA-27301: OS failure message: Invalid argument
ORA-27302: failure occurred at: sskgpwrm1
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
skgm error 27120: errno = 22, info = 5, 229378, 0, 0, 229378, 0, 11
skgm error 27120: errno = 22, info = 5, 262147, 0, 0, 262147, 0, 11
skgm error 27120: errno = 22, info = 5, 294916, 0, 0, 294916, 0, 11
skgm error 27120: errno = 22, info = 5, 327685, 0, 0, 327685, 0, 11
skgm error 27120: errno = 22, info = 5, 360454, 0, 0, 360454, 0, 11
skgm error 27120: errno = 22, info = 5, 393223, 0, 0, 393223, 0, 11
skgm error 27120: errno = 22, info = 5, 425992, 0, 0, 425992, 0, 11
skgm error 27120: errno = 22, info = 5, 458761, 0, 0, 458761, 0, 11
skgm error 27120: errno = 22, info = 5, 491530, 0, 0, 491530, 0, 11
skgm error 27120: errno = 22, info = 5, 524299, 0, 0, 524299, 0, 11
skgm error 27120: errno = 22, info = 5, 557068, 0, 0, 557068, 0, 11
skgm error 27120: errno = 22, info = 5, 589837, 0, 0, 589837, 0, 11
skgm error 27120: errno = 22, info = 5, 622606, 0, 0, 622606, 0, 11
skgm error 27120: errno = 22, info = 5, 655375, 0, 0, 655375, 0, 11
skgm error 27120: errno = 22, info = 5, 688144, 0, 0, 688144, 0, 11
skgm error 27120: errno = 22, info = 5, 720913, 0, 0, 720913, 0, 11
skgm error 27120: errno = 22, info = 5, 753682, 0, 0, 753682, 0, 11
skgm error 27120: errno = 22, info = 5, 786451, 0, 0, 786451, 0, 11
skgm error 27120: errno = 22, info = 5, 819220, 0, 0, 819220, 0, 11
skgm error 27120: errno = 22, info = 5, 851989, 0, 0, 851989, 0, 11
skgm error 27120: errno = 22, info = 5, 884758, 0, 0, 884758, 0, 11
skgm error 27120: errno = 22, info = 5, 917527, 0, 0, 917527, 0, 11
skgm error 27120: errno = 22, info = 5, 950296, 0, 0, 950296, 0, 11
skgm error 27120: errno = 22, info = 5, 983065, 0, 0, 983065, 0, 11
skgm error 27120: errno = 22, info = 5, 1015834, 0, 0, 1015834, 0, 11
skgm error 27120: errno = 22, info = 5, 1048603, 0, 0, 1048603, 0, 11
skgm error 27120: errno = 22, info = 5, 1081372, 0, 0, 1081372, 0, 11


wjdb_j001_20539.trc内容如下

7f9d46ac3000-7f9d46b32000 r-xp 00000000 fc:01 37623267                   /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so
7f9d46b32000-7f9d46c32000 ---p 0006f000 fc:01 37623267                   /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so
7f9d46c32000-7f9d46c44000 rwxp 0006f000 fc:01 37623267                   /data/oracle/product/11.2.0/db_1/lib/libasmclnt11.so
7f9d46c44000-7f9d46c45000 rwxp 00000000 00:00 0
7f9d46c45000-7f9d46c50000 r-xp 00000000 fc:01 37622977                   /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so
7f9d46c50000-7f9d46d4f000 ---p 0000b000 fc:01 37622977                   /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so
7f9d46d4f000-7f9d46d50000 rwxp 0000a000 fc:01 37622977                   /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so
7f9d46d50000-7f9d46de8000 r-xp 00000000 fc:01 37622976                   /data/oracle/product/11.2.0/db_1/lib/libocrb11.so
7f9d46de8000-7f9d46ee8000 ---p 00098000 fc:01 37622976                   /data/oracle/product/11.2.0/db_1/lib/libocrb11.so
7f9d46ee8000-7f9d46eea000 rwxp 00098000 fc:01 37622976                   /data/oracle/product/11.2.0/db_1/lib/libocrb11.so
7f9d46eea000-7f9d46f83000 r-xp 00000000 fc:01 37622975                   /data/oracle/product/11.2.0/db_1/lib/libocr11.so
7f9d46f83000-7f9d47082000 ---p 00099000 fc:01 37622975                   /data/oracle/product/11.2.0/db_1/lib/libocr11.so
7f9d47082000-7f9d47084000 rwxp 00098000 fc:01 37622975                   /data/oracle/product/11.2.0/db_1/lib/libocr11.so
7f9d47084000-7f9d47086000 r-xp 00000000 fc:01 37619552                   /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so
7f9d47086000-7f9d47185000 ---p 00002000 fc:01 37619552                   /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so
7f9d47185000-7f9d47186000 rwxp 00001000 fc:01 37619552                   /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so
7f9d47186000-7f9d475ae000 r-xp 00000000 fc:01 37622972                   /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so
7f9d475ae000-7f9d476ae000 ---p 00428000 fc:01 37622972                   /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so
7f9d476ae000-7f9d476c0000 rwxp 00428000 fc:01 37622972                   /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so
7f9d476c0000-7f9d476c4000 rwxp 00000000 00:00 0
7f9d476c4000-7f9d476e6000 r-xp 00000000 fc:01 37619532                   /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so
7f9d476e6000-7f9d477e5000 ---p 00022000 fc:01 37619532                   /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so
7f9d477e5000-7f9d477e7000 rwxp 00021000 fc:01 37619532                   /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so
7f9d477e7000-7f9d477fe000 r-xp 00000000 fc:01 37622974                   /data/oracle/product/11.2.0/db_1/lib/libclsra11.so
7f9d477fe000-7f9d478fe000 ---p 00017000 fc:01 37622974                   /data/oracle/product/11.2.0/db_1/lib/libclsra11.so
7f9d478fe000-7f9d478ff000 rwxp 00017000 fc:01 37622974                   /data/oracle/product/11.2.0/db_1/lib/libclsra11.so
7f9d478ff000-7f9d47b84000 r-xp 00000000 fc:01 37623084                   /data/oracle/product/11.2.0/db_1/lib/libnnz11.so
7f9d47b84000-7f9d47c83000 ---p 00285000 fc:01 37623084                   /data/oracle/product/11.2.0/db_1/lib/libnnz11.so
7f9d47c83000-7f9d47cc6000 rwxp 00284000 fc:01 37623084                   /data/oracle/product/11.2.0/db_1/lib/libnnz11.so
7f9d47cc6000-7f9d47cc7000 rwxp 00000000 00:00 0
7f9d47cc7000-7f9d47cce000 r-xp 00000000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f9d47cce000-7f9d47ecd000 ---p 00007000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f9d47ecd000-7f9d47ece000 r-xp 00006000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f9d47ece000-7f9d47ecf000 rwxp 00007000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f9d47ecf000-7f9d47f86000 r-xp 00000000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f9d47f86000-7f9d48086000 ---p 000b7000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f9d48086000-7f9d48088000 rwxp 000b7000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f9d48088000-7f9d480d7000 r-xp 00000000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f9d480d7000-7f9d481d6000 ---p 0004f000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f9d481d6000-7f9d481de000 rwxp 0004e000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f9d481de000-7f9d481ff000 r-xp 00000000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f9d4823a000-7f9d482ec000 rwxp 00000000 00:00 0
7f9d482f9000-7f9d482fb000 rwxs 00000000 00:0a 44870643                   /[aio] (deleted)
7f9d482fb000-7f9d482fc000 rwxp 00000000 00:00 0
7f9d482fc000-7f9d482fd000 r-xp 00000000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f9d482fd000-7f9d483fd000 ---p 00001000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f9d483fd000-7f9d483fe000 rwxp 00001000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f9d483fe000-7f9d483ff000 rwxp 00000000 00:00 0
7f9d483ff000-7f9d48400000 r-xp 00021000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f9d48400000-7f9d48401000 rwxp 00022000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f9d48401000-7f9d48402000 rwxp 00000000 00:00 0
7fff9ed9c000-7fff9edcf000 rwxp 00000000 00:00 0                          [stack]
7fff9edfe000-7fff9ee00000 r-xp 00000000 00:00 0                          [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
******************* End of process map dump ************
Unexpected error 27157 in job slave process
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1

wjdb_q000_2418.trc内容如下

7f71f86ef000-7f71f86f0000 rwxp 00000000 00:00 0
7f71f86f0000-7f71f86fb000 r-xp 00000000 fc:01 37622977                   /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so
7f71f86fb000-7f71f87fa000 ---p 0000b000 fc:01 37622977                   /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so
7f71f87fa000-7f71f87fb000 rwxp 0000a000 fc:01 37622977                   /data/oracle/product/11.2.0/db_1/lib/libocrutl11.so
7f71f87fb000-7f71f8893000 r-xp 00000000 fc:01 37622976                   /data/oracle/product/11.2.0/db_1/lib/libocrb11.so
7f71f8893000-7f71f8993000 ---p 00098000 fc:01 37622976                   /data/oracle/product/11.2.0/db_1/lib/libocrb11.so
7f71f8993000-7f71f8995000 rwxp 00098000 fc:01 37622976                   /data/oracle/product/11.2.0/db_1/lib/libocrb11.so
7f71f8995000-7f71f8a2e000 r-xp 00000000 fc:01 37622975                   /data/oracle/product/11.2.0/db_1/lib/libocr11.so
7f71f8a2e000-7f71f8b2d000 ---p 00099000 fc:01 37622975                   /data/oracle/product/11.2.0/db_1/lib/libocr11.so
7f71f8b2d000-7f71f8b2f000 rwxp 00098000 fc:01 37622975                   /data/oracle/product/11.2.0/db_1/lib/libocr11.so
7f71f8b2f000-7f71f8b31000 r-xp 00000000 fc:01 37619552                   /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so
7f71f8b31000-7f71f8c30000 ---p 00002000 fc:01 37619552                   /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so
7f71f8c30000-7f71f8c31000 rwxp 00001000 fc:01 37619552                   /data/oracle/product/11.2.0/db_1/lib/libskgxn2.so
7f71f8c31000-7f71f9059000 r-xp 00000000 fc:01 37622972                   /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so
7f71f9059000-7f71f9159000 ---p 00428000 fc:01 37622972                   /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so
7f71f9159000-7f71f916b000 rwxp 00428000 fc:01 37622972                   /data/oracle/product/11.2.0/db_1/lib/libhasgen11.so
7f71f916b000-7f71f916f000 rwxp 00000000 00:00 0
7f71f916f000-7f71f9191000 r-xp 00000000 fc:01 37619532                   /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so
7f71f9191000-7f71f9290000 ---p 00022000 fc:01 37619532                   /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so
7f71f9290000-7f71f9292000 rwxp 00021000 fc:01 37619532                   /data/oracle/product/11.2.0/db_1/lib/libdbcfg11.so
7f71f9292000-7f71f92a9000 r-xp 00000000 fc:01 37622974                   /data/oracle/product/11.2.0/db_1/lib/libclsra11.so
7f71f92a9000-7f71f93a9000 ---p 00017000 fc:01 37622974                   /data/oracle/product/11.2.0/db_1/lib/libclsra11.so
7f71f93a9000-7f71f93aa000 rwxp 00017000 fc:01 37622974                   /data/oracle/product/11.2.0/db_1/lib/libclsra11.so
7f71f93aa000-7f71f962f000 r-xp 00000000 fc:01 37623084                   /data/oracle/product/11.2.0/db_1/lib/libnnz11.so
7f71f962f000-7f71f972e000 ---p 00285000 fc:01 37623084                   /data/oracle/product/11.2.0/db_1/lib/libnnz11.so
7f71f972e000-7f71f9771000 rwxp 00284000 fc:01 37623084                   /data/oracle/product/11.2.0/db_1/lib/libnnz11.so
7f71f9771000-7f71f9772000 rwxp 00000000 00:00 0
7f71f9772000-7f71f9779000 r-xp 00000000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f71f9779000-7f71f9978000 ---p 00007000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f71f9978000-7f71f9979000 r-xp 00006000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f71f9979000-7f71f997a000 rwxp 00007000 fd:01 150366                     /usr/lib64/librt-2.17.so
7f71f997a000-7f71f9a31000 r-xp 00000000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f71f9a31000-7f71f9b31000 ---p 000b7000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f71f9b31000-7f71f9b33000 rwxp 000b7000 fc:01 37618703                   /data/oracle/product/11.2.0/db_1/lib/libskgxp11.so
7f71f9b33000-7f71f9b82000 r-xp 00000000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f71f9b82000-7f71f9c81000 ---p 0004f000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f71f9c81000-7f71f9c89000 rwxp 0004e000 fc:01 37623266                   /data/oracle/product/11.2.0/db_1/lib/libcell11.so
7f71f9c89000-7f71f9caa000 r-xp 00000000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f71f9ce5000-7f71f9d97000 rwxp 00000000 00:00 0
7f71f9da4000-7f71f9da6000 rwxs 00000000 00:0a 28167                      /[aio] (deleted)
7f71f9da6000-7f71f9da7000 rwxp 00000000 00:00 0
7f71f9da7000-7f71f9da8000 r-xp 00000000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f71f9da8000-7f71f9ea8000 ---p 00001000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f71f9ea8000-7f71f9ea9000 rwxp 00001000 fc:01 37618636                   /data/oracle/product/11.2.0/db_1/lib/libodmd11.so
7f71f9ea9000-7f71f9eaa000 rwxp 00000000 00:00 0
7f71f9eaa000-7f71f9eab000 r-xp 00021000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f71f9eab000-7f71f9eac000 rwxp 00022000 fd:01 132827                     /usr/lib64/ld-2.17.so
7f71f9eac000-7f71f9ead000 rwxp 00000000 00:00 0
7fff92da9000-7fff92ddc000 rwxp 00000000 00:00 0                          [stack]
7fff92dfe000-7fff92e00000 r-xp 00000000 00:00 0                          [vdso]
ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0                  [vsyscall]
******************* End of process map dump ************
KSV 27157 error in slave process

*** 2018-10-23 19:07:01.765
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-27157: OS post/wait facility removed
ORA-27300: OS system dependent operation:semop failed with status: 43
ORA-27301: OS failure message: Identifier removed
ORA-27302: failure occurred at: sskgpwwait1

  • 写回答

1条回答 默认 最新

  • threenewbee 2018-10-24 10:27
    关注
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 MATLAB怎么通过柱坐标变换画开口是圆形的旋转抛物面?
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿