遭遇ORA-00600:[LibraryCacheNotEmptyOnClose]

最新推荐文章于 2024-10-05 14:16:38 发布

congshouge4139

最新推荐文章于 2024-10-05 14:16:38 发布

阅读量96

点赞数

文章标签：数据库

闲着在学习ipcs,发现不对,在测试库上哦

Last login: Fri Apr 2 16:30:14 2010 from 192.168.2.188
[oracle@primary ~]$ ipcs

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status
0x4b1e72c0 262146     oracle    640        677380096 30
0x00000400 294915     oracle    777        99         0

------ Semaphore Arrays --------
key        semid      owner      perms      nsems
0x014c4414 622592     oracle    640        126
0x014c4415 655361     oracle    640        126
0x014c4416 688130     oracle    640        126
0x014c4417 720899     oracle    640        126
0x014c4418 753668     oracle    640        126

------ Message Queues --------
key msqid owner perms used-bytes messages

[oracle@primary ~]$ more /proc/sys/kernel/shmmax
2147483648
[oracle@primary ~]$ ipcs

------ Message Queues --------
key msqid owner perms used-bytes messages

[oracle@primary ~]$ ps -ef|grep pmon
oracle   18858 18562 0 13:10 pts/1    00:00:00 grep pmon
oracle   30164     1 0 Mar08 ?        00:00:18 ora_pmon_demo
[oracle@primary ~]$ more /proc/30164/maps
0069c000-006b2000 r-xp 00000000 03:01 1115122    /lib/ld-2.3.4.so
006b2000-006b3000 r--p 00015000 03:01 1115122    /lib/ld-2.3.4.so
006b3000-006b4000 rw-p 00016000 03:01 1115122    /lib/ld-2.3.4.so
006b6000-007df000 r-xp 00000000 03:01 1115123    /lib/tls/libc-2.3.4.so
007df000-007e1000 r--p 00129000 03:01 1115123    /lib/tls/libc-2.3.4.so
007e1000-007e3000 rw-p 0012b000 03:01 1115123    /lib/tls/libc-2.3.4.so
007e3000-007e5000 rw-p 007e3000 00:00 0
007e7000-007e9000 r-xp 00000000 03:01 1115125    /lib/libdl-2.3.4.so
007e9000-007ea000 r--p 00001000 03:01 1115125    /lib/libdl-2.3.4.so
007ea000-007eb000 rw-p 00002000 03:01 1115125    /lib/libdl-2.3.4.so
007ed000-0080e000 r-xp 00000000 03:01 1115124    /lib/tls/libm-2.3.4.so
0080e000-0080f000 r--p 00020000 03:01 1115124    /lib/tls/libm-2.3.4.so
0080f000-00810000 rw-p 00021000 03:01 1115124    /lib/tls/libm-2.3.4.so
008f3000-00901000 r-xp 00000000 03:01 1115126    /lib/tls/libpthread-2.3.4.so
00901000-00902000 r--p 0000d000 03:01 1115126    /lib/tls/libpthread-2.3.4.so
00902000-00903000 rw-p 0000e000 03:01 1115126    /lib/tls/libpthread-2.3.4.so
00903000-00905000 rw-p 00903000 00:00 0
00bd6000-00be9000 r-xp 00000000 03:01 1115134    /lib/libnsl-2.3.4.so
00be9000-00bea000 r--p 00012000 03:01 1115134    /lib/libnsl-2.3.4.so
00bea000-00beb000 rw-p 00013000 03:01 1115134    /lib/libnsl-2.3.4.so
00beb000-00bed000 rw-p 00beb000 00:00 0
08048000-0ce13000 r-xp 00000000 03:07 1043464    /u01/app/oracle/product/10.2.0/db_1/bin/oracle
0ce13000-0ce68000 rw-p 04dca000 03:07 1043464    /u01/app/oracle/product/10.2.0/db_1/bin/oracle
0ce68000-0cf49000 rw-p 0ce68000 00:00 0
20000000-48600000 rw-s 00000000 00:06 262146     /SYSV4b1e72c0 (deleted)
b7212000-b7253000 rw-p b7212000 00:00 0
b7253000-b725c000 r-xp 00000000 03:01 1114162    /lib/libnss_files-2.3.4.so
b725c000-b725d000 r--p 00008000 03:01 1114162    /lib/libnss_files-2.3.4.so
b725d000-b725e000 rw-p 00009000 03:01 1114162    /lib/libnss_files-2.3.4.so
b7273000-b7280000 rw-p 00000000 00:0d 2149       /dev/zero
b7280000-b7290000 rw-p 00000000 00:0d 2149       /dev/zero
b7290000-b72a0000 rw-p 00000000 00:0d 2149       /dev/zero
b72a0000-b72b0000 rw-p 00000000 00:0d 2149       /dev/zero
b72b0000-b72f3000 rw-p 0003d000 00:0d 2149       /dev/zero
b72f9000-b72fa000 rw-s 00000000 03:07 1041717    /u01/app/oracle/product/10.2.0/db_1/dbs/hc_demo.dat
b72fa000-b7365000 rw-p b72fa000 00:00 0
b7365000-b7368000 r-xp 00000000 03:01 273266     /usr/lib/libnuma.so.1
b7368000-b7369000 rw-p 00002000 03:01 273266     /usr/lib/libnuma.so.1
b7369000-b746e000 rw-p b7369000 00:00 0
b746e000-b746f000 r-xp 00000000 03:01 277327     /usr/lib/libaio.so.1.0.1
b746f000-b7470000 rw-p 00000000 03:01 277327     /usr/lib/libaio.so.1.0.1
b7485000-b7663000 r-xp 00000000 03:07 1042178    /u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so
b7663000-b768a000 rw-p 001dd000 03:07 1042178    /u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so
b768a000-b768b000 rw-p b768a000 00:00 0
b768b000-b76a2000 r-xp 00000000 03:07 1036872    /u01/app/oracle/product/10.2.0/db_1/lib/libdbcfg10.so
b76a2000-b76a4000 rw-p 00016000 03:07 1036872    /u01/app/oracle/product/10.2.0/db_1/lib/libdbcfg10.so
b76a4000-b76ac000 r-xp 00000000 03:07 1041631    /u01/app/oracle/product/10.2.0/db_1/lib/libclsra10.so
b76ac000-b76ad000 rw-p 00007000 03:07 1041631    /u01/app/oracle/product/10.2.0/db_1/lib/libclsra10.so
b76ad000-b7d92000 r-xp 00000000 03:07 1034662    /u01/app/oracle/product/10.2.0/db_1/lib/libjox10.so
b7d92000-b7dd4000 rw-p 006e5000 03:07 1034662    /u01/app/oracle/product/10.2.0/db_1/lib/libjox10.so
b7dd4000-b7dd6000 rw-p b7dd4000 00:00 0
b7dd6000-b7e2c000 r-xp 00000000 03:07 1041597    /u01/app/oracle/product/10.2.0/db_1/lib/libocrutl10.so
b7e2c000-b7e30000 rw-p 00055000 03:07 1041597    /u01/app/oracle/product/10.2.0/db_1/lib/libocrutl10.so
b7e30000-b7e31000 rw-p b7e30000 00:00 0
b7e31000-b7e7a000 r-xp 00000000 03:07 1041596    /u01/app/oracle/product/10.2.0/db_1/lib/libocrb10.so
b7e7a000-b7e7b000 rw-p 00049000 03:07 1041596    /u01/app/oracle/product/10.2.0/db_1/lib/libocrb10.so
b7e7b000-b7ef0000 r-xp 00000000 03:07 1041595    /u01/app/oracle/product/10.2.0/db_1/lib/libocr10.so
b7ef0000-b7ef1000 rw-p 00075000 03:07 1041595    /u01/app/oracle/product/10.2.0/db_1/lib/libocr10.so
b7ef1000-b7ef2000 rw-p b7ef1000 00:00 0
b7ef2000-b7ef3000 r-xp 00000000 03:07 1036983    /u01/app/oracle/product/10.2.0/db_1/lib/libskgxn2.so
b7ef3000-b7ef4000 rw-p 00000000 03:07 1036983    /u01/app/oracle/product/10.2.0/db_1/lib/libskgxn2.so
b7ef4000-b7fd4000 r-xp 00000000 03:07 1041630    /u01/app/oracle/product/10.2.0/db_1/lib/libhasgen10.so
b7fd4000-b7fd8000 rw-p 000df000 03:07 1041630    /u01/app/oracle/product/10.2.0/db_1/lib/libhasgen10.so
b7fd8000-b7fdd000 rw-p b7fd8000 00:00 0
b7fdd000-b7ffe000 r-xp 00000000 03:07 1033642    /u01/app/oracle/product/10.2.0/db_1/lib/libskgxp10.so
b7ffe000-b8000000 rw-p 00021000 03:07 1033642    /u01/app/oracle/product/10.2.0/db_1/lib/libskgxp10.so
bfffb000-c0000000 rwxp bfffb000 00:00 0
ffffe000-fffff000 r-xp 00000000 00:00 0

试着先关闭
[oracle@primary ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Apr 6 13:16:38 2010

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

报600错误,tracer文件一大段,看不懂.共享内存还被占用
[oracle@primary bdump]$ ipcs

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000400 294915 oracle 777 99 0

------ Semaphore Arrays --------
key semid owner perms nsems

------ Message Queues --------
key msqid owner perms used-bytes messages

删除共享内存

[oracle@primary bdump]$ ipcrm -m 294915
[oracle@primary bdump]$ ipcs

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status

------ Semaphore Arrays --------
key semid owner perms nsems

------ Message Queues --------
key msqid owner perms used-bytes messages

[oracle@primary bdump]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Apr 6 13:30:55 2010

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 675282944 bytes
Fixed Size                  1269280 bytes
Variable Size             155189728 bytes
Database Buffers          511705088 bytes
Redo Buffers                7118848 bytes
Database mounted.
Database opened.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

不报错了!!