Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2141021
  • 博文数量: 157
  • 博客积分: 10047
  • 博客等级: 上将
  • 技术积分: 6757
  • 用 户 组: 普通用户
  • 注册时间: 2005-05-19 11:38
文章分类

全部博文(157)

文章存档

2011年(16)

2010年(50)

2009年(42)

2008年(49)

我的朋友

分类: Oracle

2009-07-04 16:29:28

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

阅读(1760) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~