oracle 运行超过198天后进程挂死
1、strace sqlplus 日志
[oracle@test ~]$ w
14:55:48 up 225 days, 1:01, 3 users, load average: 35.24, 35.36, 35.16
USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT
root pts/0 61.135.207.195 14:49 3:15 0.01s 0.01s -bash
root pts/1 61.135.207.195 14:50 3:24 0.03s 0.02s -bash
root pts/2 61.135.207.195 14:52 0.00s 0.03s 0.00s w
[oracle@test ~]$ strace -o sqlplus.log sqlplus "/as sysdba"
[oracle@test ~]$ more sqlplus.log
execve("/u01/app/oracle/product/10.2.0/db_1/bin/sqlplus", ["sqlplus", "/as sysdba"], [/* 28 vars */]) = 0
uname({sys="Linux", node="CNC-BJ-D-5D1", ...}) = 0
brk(0) = 0x804a000
access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/tls/i686/sse2/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/u01/app/oracle/product/10.2.0/db_1/lib/tls/i686/sse2", 0xbfffeed0) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/tls/i686/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/u01/app/oracle/product/10.2.0/db_1/lib/tls/i686", 0xbfffeed0) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/tls/sse2/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/u01/app/oracle/product/10.2.0/db_1/lib/tls/sse2", 0xbfffeed0) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/tls/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/u01/app/oracle/product/10.2.0/db_1/lib/tls", 0xbfffeed0) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/i686/sse2/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/u01/app/oracle/product/10.2.0/db_1/lib/i686/sse2", 0xbfffeed0) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/i686/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/u01/app/oracle/product/10.2.0/db_1/lib/i686", 0xbfffeed0) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/sse2/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/u01/app/oracle/product/10.2.0/db_1/lib/sse2", 0xbfffeed0) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libsqlplus.so", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0@H\1\000"..., 512) = 512
fstat64(3, {st_mode=S_IFREG|0640, st_size=1047293, ...}) = 0
old_mmap(NULL, 728168, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xa7f000
old_mmap(0xb28000, 36864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xa8000) = 0xb28000
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/lib/libclntsh.so.10.1", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\360\305"..., 512) = 512
fstat64(3, {st_mode=S_IFREG|0750, st_size=18435804, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7fff000
old_mmap(NULL, 14299112, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb31000
old_mmap(0x185f000, 397312, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xd2d000) = 0x185f000
old_mmap(0x18c0000, 81896, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x18c0000
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/lib/libnnz10.so", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\3006\6"..., 512) = 512
fstat64(3, {st_mode=S_IFREG|0640, st_size=5480533, ...}) = 0
old_mmap(NULL, 2110644, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x5b3000
old_mmap(0x78f000, 155648, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1dc000) = 0x78f000
old_mmap(0x7b5000, 5300, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7b5000
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/i686/sse2/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/lib/tls/i686/sse2", 0xbfffee7c) = -1 ENOENT (No such file or directory)
open("/lib/tls/i686/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/lib/tls/i686", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("/lib/tls/sse2/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/lib/tls/sse2", 0xbfffee7c) = -1 ENOENT (No such file or directory)
open("/lib/tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/lib/tls", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("/lib/i686/sse2/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/lib/i686/sse2", 0xbfffee7c) = -1 ENOENT (No such file or directory)
open("/lib/i686/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/lib/i686", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("/lib/sse2/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/lib/sse2", 0xbfffee7c) = -1 ENOENT (No such file or directory)
open("/lib/libdl.so.2", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\260[A\000"..., 512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=16732, ...}) = 0
old_mmap(0x415000, 12388, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x415000
old_mmap(0x417000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1000) = 0x417000
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/i686/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/libm.so.6", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\0003?\000"..., 512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=213772, ...}) = 0
old_mmap(0x3f0000, 139424, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3f0000
old_mmap(0x411000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x20000) = 0x411000
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/i686/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/libpthread.so.0", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0P\370A\000"..., 512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=107800, ...}) = 0
old_mmap(0x41b000, 70108, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x41b000
old_mmap(0x429000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xd000) = 0x429000
old_mmap(0x42b000, 4572, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x42b000
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/i686/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/i686/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/libnsl.so.1", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\360\7\223"..., 512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=97120, ...}) = 0
old_mmap(0x92d000, 88072, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x92d000
old_mmap(0x93f000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x11000) = 0x93f000
old_mmap(0x941000, 6152, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x941000
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/i686/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/libc.so.6", O_RDONLY) = 3
read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320n-\000"..., 512) = 512
fstat64(3, {st_mode=S_IFREG|0755, st_size=1529008, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7ffe000
old_mmap(0x2c2000, 1227996, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x2c2000
old_mmap(0x3e8000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x125000) = 0x3e8000
old_mmap(0x3ec000, 7388, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3ec000
close(3) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7ffd000
mprotect(0x3e8000, 8192, PROT_READ) = 0
mprotect(0x93f000, 4096, PROT_READ) = 0
mprotect(0x429000, 4096, PROT_READ) = 0
mprotect(0x411000, 4096, PROT_READ) = 0
mprotect(0x417000, 4096, PROT_READ) = 0
mprotect(0x5b3000, 1949696, PROT_READ|PROT_WRITE) = 0
mprotect(0x5b3000, 1949696, PROT_READ|PROT_EXEC) = 0
mprotect(0xb31000, 13819904, PROT_READ|PROT_WRITE) = 0
mprotect(0xb31000, 13819904, PROT_READ|PROT_EXEC) = 0
mprotect(0xa7f000, 692224, PROT_READ|PROT_WRITE) = 0
mprotect(0xa7f000, 692224, PROT_READ|PROT_EXEC) = 0
mprotect(0x2ba000, 4096, PROT_READ) = 0
set_thread_area({entry_number:-1 -> 6, base_addr:0xb7ffd6c0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_page
s:1, seg_not_present:0, useable:1}) = 0
set_tid_address(0xb7ffd708) = 3671
rt_sigaction(SIGRTMIN, {0x41f380, [], SA_RESTORER|SA_SIGINFO, 0x4269c0}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x41f3f0, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x4269c0}, NULL, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
getrlimit(RLIMIT_STACK, {rlim_cur=10240*1024, rlim_max=RLIM_INFINITY}) = 0
_sysctl({{CTL_KERN, KERN_VERSION}, 2, 0xbffff65c, 35, (nil), 0}) = 0
brk(0) = 0x804a000
brk(0x806b000) = 0x806b000
mmap2(NULL, 143360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7fda000
futex(0x418060, FUTEX_WAKE, 2147483647) = 0
open("/u01/app/oracle/product/10.2.0/db_1/lib/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/i686/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/i686/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/i686/sse2/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/usr/lib/tls/i686/sse2", 0xbfffd120) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/i686/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/usr/lib/tls/i686", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("/usr/lib/tls/sse2/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/usr/lib/tls/sse2", 0xbfffd120) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/usr/lib/tls", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("/usr/lib/i686/sse2/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/usr/lib/i686/sse2", 0xbfffd120) = -1 ENOENT (No such file or directory)
open("/usr/lib/i686/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/usr/lib/i686", 0xbfffd120) = -1 ENOENT (No such file or directory)
open("/usr/lib/sse2/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/usr/lib/sse2", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
open("/usr/lib/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
stat64("/usr/lib", {st_mode=S_IFDIR|0755, st_size=94208, ...}) = 0
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=105993, ...}) = 0
old_mmap(NULL, 105993, PROT_READ, MAP_PRIVATE, 3, 0) = 0xb7fc0000
close(3) = 0
open("/lib/tls/i686/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/i686/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/i686/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/sse2/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/libsqlplusic.so", O_RDONLY) = -1 ENOENT (No such file or directory)
munmap(0xb7fc0000, 105993) = 0
open("/u01/app/oracle/product/10.2.0/db_1/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/i686/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/i686/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/i686/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/sse2/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=105993, ...}) = 0
old_mmap(NULL, 105993, PROT_READ, MAP_PRIVATE, 3, 0) = 0xb7fc0000
close(3) = 0
open("/lib/tls/i686/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/i686/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/i686/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/sse2/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
munmap(0xb7fc0000, 105993) = 0
open("/u01/app/oracle/product/10.2.0/db_1/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/i686/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/i686/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/i686/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/sse2/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=105993, ...}) = 0
old_mmap(NULL, 105993, PROT_READ, MAP_PRIVATE, 3, 0) = 0xb7fc0000
close(3) = 0
open("/lib/tls/i686/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/tls/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/i686/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/i686/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/tls/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/sse2/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
munmap(0xb7fc0000, 105993) = 0
open("/u01/app/oracle/product/10.2.0/db_1/nls/data/lx1boot.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\1 \n\300V\0\0 \257\215\0\0\0\0\0\1\0B\0\271"..., 48) = 48
read(3, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 22160) = 22160
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/nls/data/lx00001.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\1 \n\263\3\0\0o\2\0\0\0\0\0\0\0\0\0\0\0Z\1\0"..., 92) = 92
read(3, "\3\0\0\0\1\0\1\0\1\0`\0\0\0\0\0\2\0\4\0\6\0\f\0\24\0\34"..., 856) = 855
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/nls/data/lx20001.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\1 \n5\33\0\0\211\21\0\0\0\0\0\0\2\0\0\0\0Z\1"..., 92) = 92
read(3, "\1\0\37\0\t\0\0\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\1\0\0\0"..., 6876) = 6873
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/nls/data/lx10001.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\1 \np\4\0\0\214\3\0\0\0\0\0\0\1\0\0\0\0Z\1\0"..., 92) = 92
read(3, "\3\0\0\0\1\0\1\0\0\0\0\0\0\0\4\0\1\0\2\0\2\0\1\0\1\0\0"..., 1044) = 1044
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/nls/data/lx40001.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\1 \n\\}\0\0008|\0\0\0\0\0\0\4\0\0\0\0Z\1\0\0"..., 92) = 92
read(3, "\0\0\0\0\0\0\0\0\0\0\0\0\264O\0\0\20[\0\0\314\\\0\0\330"..., 32000) = 32000
close(3) = 0
open("/u01/app/oracle/product/10.2.0/db_1/sqlplus/mesg/sp1us.msb", O_RDONLY) = 3
fcntl64(3, F_SETFD, FD_CLOEXEC) = 0
lseek(3, 0, SEEK_SET) = 0
read(3, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
open("/u01/app/oracle/product/10.2.0/db_1/sqlplus/mesg/sp2us.msb", O_RDONLY) = 4
fcntl64(4, F_SETFD, FD_CLOEXEC) = 0
lseek(4, 0, SEEK_SET) = 0
read(4, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
brk(0x8093000) = 0x8093000
open("/u01/app/oracle/product/10.2.0/db_1/sqlplus/mesg/cpyus.msb", O_RDONLY) = 5
fcntl64(5, F_SETFD, FD_CLOEXEC) = 0
lseek(5, 0, SEEK_SET) = 0
read(5, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(5, 512, SEEK_SET) = 512
read(5, "\f\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(5, 1024, SEEK_SET) = 1024
read(5, "\t\0\f\0", 4) = 4
gettimeofday({1246690344, 692215}, NULL) = 0
open("/etc/localtime", O_RDONLY) = 6
fstat64(6, {st_mode=S_IFREG|0644, st_size=165, ...}) = 0
fstat64(6, {st_mode=S_IFREG|0644, st_size=165, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7fd9000
read(6, "TZif\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\3\0\0\0\3\0"..., 4096) = 165
close(6) = 0
munmap(0xb7fd9000, 4096) = 0
open("/u01/app/oracle/product/10.2.0/db_1/oracore/zoneinfo/timezlrg.dat", O_RDONLY) = 6
fstat64(6, {st_mode=S_IFREG|0640, st_size=384987, ...}) = 0
mmap2(NULL, 384987, PROT_READ, MAP_PRIVATE|MAP_NORESERVE, 6, 0) = 0xb7f7c000
close(6) = 0
open("/u01/app/oracle/product/10.2.0/db_1/oracore/zoneinfo/timezlrg.dat", O_RDONLY|O_LARGEFILE) = 6
fstat64(6, {st_mode=S_IFREG|0640, st_size=384987, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7f7b000
read(6, "ZTrO\333\337\5\0\2\0\2\0\2\0y\1_=\276\0024\20\0\0\374\33"..., 4096) = 4096
read(6, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 4096
close(6) = 0
munmap(0xb7f7b000, 4096) = 0
mmap2(NULL, 385024, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7f1e000
open("/u01/app/oracle/product/10.2.0/db_1/oracore/zoneinfo/timezlrg.dat", O_RDONLY|O_LARGEFILE) = 6
fstat64(6, {st_mode=S_IFREG|0640, st_size=384987, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7f1d000
read(6, "ZTrO\333\337\5\0\2\0\2\0\2\0y\1_=\276\0024\20\0\0\374\33"..., 4096) = 4096
read(6, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 4096
close(6) = 0
munmap(0xb7f1d000, 4096) = 0
open("/u01/app/oracle/product/10.2.0/db_1/oracore/zoneinfo/timezlrg.dat", O_RDONLY|O_LARGEFILE) = 6
fstat64(6, {st_mode=S_IFREG|0640, st_size=384987, ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7f1d000
read(6, "ZTrO\333\337\5\0\2\0\2\0\2\0y\1_=\276\0024\20\0\0\374\33"..., 380928) = 380928
read(6, "GMT-1\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0Etc/GMT-10\0"..., 4096) = 4059
close(6) = 0
munmap(0xb7f1d000, 4096) = 0
gettimeofday({1246690344, 695589}, NULL) = 0
access("/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora", F_OK) = -1 ENOENT (No such file or directory)
access("/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora", F_OK) = -1 ENOENT (No such file or directory)
open("/u01/app/oracle/product/10.2.0/db_1/rdbms/mesg/ocius.msb", O_RDONLY) = 6
fcntl64(6, F_SETFD, FD_CLOEXEC) = 0
lseek(6, 0, SEEK_SET) = 0
read(6, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(6, 512, SEEK_SET) = 512
read(6, "\337y\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(6, 1024, SEEK_SET) = 1024
read(6, "\25\7\'\0072\7>\7j\7\276\17$\'\6K5S\24TfT\307T(VsV\222"..., 86) = 86
times(NULL) = -1921215869
times(NULL) = -1921215869
times(NULL) = -1921215869
times(NULL) = -1921215869
times(NULL) = -1921215869
times(NULL) = -1921215869
times(NULL) = -1921215869
2、kill所有Oracle进程
[oracle@test ~]$ ps -ef|grep ora|grep -v grep|awk '{print $2}'|xargs kill -9
3、kill已经分配的共享内存空间
[root@CNC-BJ-D-5D1 ~]# ipcs
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x90b16f88 98304 oracle 640 840957952 0
------ Semaphore Arrays --------
key semid owner perms nsems
0xf395d5c4 983040 oracle 640 154
------ Message Queues --------
key msqid owner perms used-bytes messages
[root@CNC-BJ-D-5D1 ~]# ipcrm -M 0x90b16f88
[root@CNC-BJ-D-5D1 ~]# ipcrm -S 0xf395d5c4
[root@CNC-BJ-D-5D1 ~]# 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
[root@CNC-BJ-D-5D1 ~]#
4、打patch 4612267
在打patch之前用sqlplus尝试登陆还是不成功，之前通常的方法是重启系统
opatch 在$ORACLE_HOME/OPatch下
[oracle@test 4612267]$ opatch apply
Invoking OPatch 10.2.0.1.0
Oracle interim Patch Installer version 10.2.0.1.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..
Oracle Home : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /u01/app/oracle/product/10.2.0/db_1/oraInst.loc
OPatch version : 10.2.0.1.0
OUI version : 10.2.0.1.0
OUI location : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch-2009_Jul_04_15-17-47-CST_Sat.log
ApplySession applying interim patch '4612267' to OH '/u01/app/oracle/product/10.2.0/db_1'
Invoking fuser to check for active processes.
Invoking fuser on "/u01/app/oracle/product/10.2.0/db_1/bin/oracle"
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/10.2.0/db_1')
Is the local system ready for patching?
Do you want to proceed? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '4612267' for restore. This might take a while...
Backing up files affected by the patch '4612267' for rollback. This might take a while...
Patching component oracle.oracore.rsf, 10.2.0.1.0...
Updating archive file "/u01/app/oracle/product/10.2.0/db_1/lib/libcore10.a" with "lib/libcore10.a/sltrg.o"
Patching component oracle.rdbms, 10.2.0.1.0...
Updating archive file "/u01/app/oracle/product/10.2.0/db_1/lib/libcore10.a" with "lib/libcore10.a/sltrg.o"
Running make for target client_sharedlib
Running make for target client_sharedlib
Running make for target ioracle
ApplySession adding interim patch '4612267' to inventory
The local system has been patched and can be restarted.
OPatch succeeded.
[oracle@test 4612267]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 4 15:19:03 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 1222144 bytes
Variable Size 109054464 bytes
Database Buffers 721420288 bytes
Redo Buffers 7163904 bytes
Database mounted.
Database opened.
SQL>
此时数据库已经能够成功启动
5、打patch文档
# Patch Installation Instructions:
# --------------------------------
# To apply the patch, unzip the PSE container file:
#
# p4612267_10201_LINUX.zip
#
# Set your current directory to the directory where the patch
# is located:
#
# % cd 4612267
#
# Ensure that the directory containing the opatch script appears in
# your $PATH; then enter the following command:
#
# % opatch apply
#
# Patch Special Instructions:
# ---------------------------
# Make sure all instances running under the ORACLE_HOME being patched
# are cleanly shutdown before installing this patch. Also ensure that
# the tool used to terminate the instance(s) has exited cleanly.
#
# Restart any applications that use the client shared libraries.
# Relink any client applications that are not dynamically linked to
# libclient9.so
#
# If the Oracle inventory is not setup correctly this utility will
# fail. To check accessibility to the inventory you can use the
# command
#
# % opatch lsinventory
#
# If you have any problems installing this PSE or are not sure
# about inventory setup please call Oracle support.
#
# Patch Deinstallation Instructions:
# ----------------------------------
# Use the following command:
#
# % cd 4612267
# % opatch rollback -id 4612267
#
Oracle文档对此有介绍
TIP: Click help for a detailed explanation of this page.
Bookmark Go to End
Subject: SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time
Doc ID: 338461.1 Type: PROBLEM
Modified Date : 14-APR-2008 Status: PUBLISHED
In this Document
