oracle test就死,oracle 运行超过198天后进程挂死

最新推荐文章于 2021-04-06 01:46:43 发布
最新推荐文章于 2021-04-06 01:46:43 发布
阅读量127 收藏
点赞数
文章标签： oracle test就死

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.

BookmarkGo to End

Subject:SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time

Doc ID:338461.1Type:PROBLEM

Modified Date :14-APR-2008Status:PUBLISHED

In this Document

DeepWeaver
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
oracle数据库检查表锁，过程吊死，及处理方法
08-27
oracle数据库检查表锁，过程吊死，及处理方法，注意文档注释
Oracle 运维篇+进程追踪调试（Linux系统）
ZZT_2009
05-02 584
说明：本文为Linux下Oracle进程追踪调试指导手册， 标签：strace、进程追踪、进程调试、Oracle进程追踪调试 温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化 正文开始 大纲 --strace介绍 --在Oracle中的用途 --语法 --推荐网文 --命令样例 --输出日志 ★ strace介绍 ///////////////////...
strace 查看加载动态库的情况
yasi_xi的专栏
11-18 1994
strace 命令可以查看程序加载动态库的情况，打印程序尝试从哪些路径去加载动态库了。 例如一个叫 thread 的程序尝试加载动态库 libboost_thread.so.1.52.0，我们用 strace ./thread 可以看到下面内容： execve("../bin/thread", ["../bin/thread"], [/* 27 vars */]) = 0 brk(0)
sqlplus执行错误的问题探究
bisal的专栏
07-23 1110
今天碰到个很诡异的问题，在装了Oracle Clinet的机器，不同路径下执行指令sqlplus，回显不同。Oracle Client路径是/opt/app/oracle/instant...
使用strace, ltrace寻找故障原因的线索
delphiwcdj的专栏
03-23 2万+
2012-03-23 wcdj 在GNU/Linux环境下，当程序出现“疑难杂症”的时候，如何快速定位问题呢？本文介绍strace/ltrace的一些使用方法，内容主要来自个人的读书笔记（可见参考文献）。strace/ltrace 是一类不错的工具，在工作中经常会用到，其主要可以用于： (1) 了解一个程序的工作原理（可以了解Linux下很多常用的命令实现的原理）； (2) 帮助定位程序
Oracle中查看正在运行的SQL进程脚本分享
12-16
Oracle的show processlist 代码如下: set linesize 400; set pagesize 400; col sql_text format a100; col machine format a25; col username format a15; SELECT a.username,a.machine, b.sql_id, b.SQL_TEXT ...
杀死oracle死锁进程
01-07
解决Oracle数据库死锁问题,查询出数据库所有死锁,并杀死所有的死锁，解决程序运行问题；
oracle杀死锁，寻PIDKILL进程
12-30
oracle杀死锁 ，在批量导入数据的时候，在数据库中很容易就碰到锁表了，导致长时间数据库卡死，此脚本方便找寻数据库被锁对象，如果在oracle中不能alter kill掉 说明该session已过期需要进入后台去杀掉进程
Oracle中死事务的检查语句
09-10
本节主要介绍了Oracle中死事务的检查语句,需要的朋友可以参考下
linux c 命令执行函数 popen 失败 enomen错误 解决方法
whatday的专栏
01-13 3607
问题描述 公司原有的程序最近遇到一个有趣的问题， 系统有内存3T , 内存消耗2.5T , 这个时候日志显示打开gzip 格式文件失败。 程序是老派的C程序， 打开gzip文件的方式是这样的： fd = popen("gzip -dc xxx.gz","r"); 我在后面添加了打印errno , 发现居然是ENOMEM (12) 这个错误！ 问题调研 查询关键字 popen +ENOMEM , 一下子很多帖子都提出了是popen 过程的clone 调用在复制父进程的时候失败， 感觉有些道理...
linux 命令总结
ki187的专栏
05-21 502
lsof -u userone,root  //用户userone，root打开的文件 lsof
strace命令学习
后台开发
03-16 1万+
linux下strace命令是强大，今天来学习一下。利用strace命令可以追踪系统调用和信号值。 学习用的测试代码如下： [root@localhost mapan]# cat test.cpp #include <iostream> using namespace std; int main() { int a; cin >> a; ...
Linux下so动态库查看与运行时搜索路径的设置
热门推荐
renwotao2009的专栏
05-14 4万+
ldd命令linux 下可以使用ldd查看可执行文件所需要的动态链接库（*.so）。 注：下文用so代替动态链接库文件。// 举个例子 ~$ ldd /bin/ls linux-vdso.so.1 => (0x00007ffe06386000) libselinux.so.1 => /lib/x86_64-linux-gnu/libselinux.so.1 (0x00007fd6
sqlplus启动失败
ckm9894的博客
03-19 926
操作系统：CentOS 7.5 数据库：Oracle 11.2.0.4 sqlplus突然无法启动，报错信息如下： Error 5...
linux执行脚本报错: No such file or directory
娜然的专栏
07-18 4798
执行一个linux 的脚本的时候报错： # ./py_innodb_page_info.py /mysql/data/gw/t.ibd : No such file or directory trace跟踪一下： execve("./py_innodb_page_info.py", ["./py_innodb_page_info.py", "/mysql/data/gw/t.ibd"]
ZT: Oracle 中如何删除重复数据
foreveryday007's BLOG
01-17 1185
我们可能会出现这种情况，某个表原来设计不周全，导致表里面的数据数据重复，那么，如何对重复的数据进行删除呢？重复的数据可能有这样两种情况，第一种时表中只有某些字段一样，第二种是两行记录完全一样。一、对于部分字段重复数据的删除先来谈谈如何查询重复的数据吧。下面语句可以查询出那些数据是重复的：代码:select 字段1,字段2,count(*) from 表名 group by 字段1,字段2
oracle9i监听自动断开,oracle连接超时自动断开问题
weixin_30716641的博客
04-06 379
今天接到客户电话，描述新建的oracle 11.1.0.7 RAC数据库中，当一个用户连接到数据库上以后，如果在某一段时间内没有任何动作的话，该进程就会自己中断，这样在应用程序就会因为进程超时自动断开而不能正常执行。分析原因，应该是该进程的用户的概要文件(profile)配置问题。发现用户所在的profile的IDLE_TIME为30。即30秒该进程没有任何操作，就会自动断开。以下为google出...
Oracle经常断开连接
会飞的小祥
05-17 5791
不知道为什么，旧电脑上的oracle经常断开连接，而新买的电脑上就是用正常，所有连接Oracle的三方软件也都断开，像PL/Sql。   　　于是，就好奇这是什么原因造成的？ 1、在这里引用一篇修改profile的博文 ，http://blog.csdn.net/gysheng2/article/details/6761201，不过，我在这里建议，如果你没有对oracle做过设置的修改，那么
oracle存储过程运行后锁死
最新发布
11-25
当Oracle存储过程运行时，可能会出现锁死的情况。这种情况通常是由于DDL锁引起的。DDL锁是用于保证数据库对象完整性的锁，当存储过程被执行或编译时，Oracle会自动给这个对象加上DDL锁，并对存储过程所引用的对象...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值