Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem: Not able to start one of the database instance using sqlplus after it is aborted on 10.2.0.3, HP-UX Itanium, v 11.31
Log files:
FileComment
----------------------
12186: socket(AF_INET, SOCK_DGRAM, 0) = 13
12186: setsockopt(13, SOL_SOCKET, SO_REUSEADDR, 0x9fffffffffff2978, 4) = 0
12186: bind(13, 0x6000000000364b70, 16) = 0
12186: getsockname(13, 0x9fffffffffff2980, 0x9fffffffffff2970) = 0
12186: getpeername(13, 0x9fffffffffff2980, 0x9fffffffffff2970) ERR#235 ENOTCONN
12186: getsockopt(13, SOL_SOCKET, SO_SNDBUF, 0x9fffffffffff29d0, 0x9fffffffffff29d4) = 0
12186: getsockopt(13, SOL_SOCKET, SO_RCVBUF, 0x9fffffffffff29d0, 0x9fffffffffff29d4) = 0
12186: fcntl(13, F_SETFD, 1) = 0
12186: ioctl(13, FIONBIO, 0x9fffffffffff2b1c) = 0
12186: gettimeofday(0x9fffffffffff1970, NULL) = 0
12186: access("/tmp/.oracle", F_OK) = 0
12186: chmod("/tmp/.oracle", 01777) ERR#1 EPERM
12186: socket(AF_UNIX, SOCK_STREAM, 0) = 15
12186: access("/tmp/.oracle/sprocr_local_conn_0_PROC", F_OK) = 0
12186: connect(15, 0x9fffffffffff1390, 94) = 0
12186: fcntl(15, F_SETFD, 1) = 0
12186: sigaction(SIGPIPE, 0x9fffffffffff1590, 0x9fffffffffff15c0) = 0
12186: gettimeofday(0x9fffffffffff1970, NULL) = 0
12186: gettimeofday(0x9fffffffffff1970, NULL) = 0
12186: ioctl(15, FIONBIO, 0x9fffffffffff2abc) = 0
12186: write(15, "\0\0\00 \001\00101\001\0\0\0\001".., 48) = 48
12186: gettimeofday(0x9fffffffffff2e20, NULL) = 0
12186: poll(0x60000000003635c8, 2, -1) = 1
12186: gettimeofday(0x9fffffffffff2e20, NULL) = 0
12186: poll(0x60000000003635c8, 2, -1) [sleeping]
Solution:
This issue is matching for OS bug QX:QXCR1000940361
so, applying the patch PHKL_40208 (and other recommended patches) should help resolving the issue here.
Recommended patches
PHKL_38762
PHKL_40208
PHKL_38733
PHKL_38623
References:
Note 2059882.102 "PROTECTIONS INCORRECT ON /TMP/.ORACLE IPC SOCKET FILES AFTER /TMP RESTORE"
Note 434062.1 "Listener Fails To Start With IPC Permission Errors (TNS-12546 TNS-12555 TNS-00516 TNS-00525)"
Log files:
FileComment
----------------------
12186: socket(AF_INET, SOCK_DGRAM, 0) = 13
12186: setsockopt(13, SOL_SOCKET, SO_REUSEADDR, 0x9fffffffffff2978, 4) = 0
12186: bind(13, 0x6000000000364b70, 16) = 0
12186: getsockname(13, 0x9fffffffffff2980, 0x9fffffffffff2970) = 0
12186: getpeername(13, 0x9fffffffffff2980, 0x9fffffffffff2970) ERR#235 ENOTCONN
12186: getsockopt(13, SOL_SOCKET, SO_SNDBUF, 0x9fffffffffff29d0, 0x9fffffffffff29d4) = 0
12186: getsockopt(13, SOL_SOCKET, SO_RCVBUF, 0x9fffffffffff29d0, 0x9fffffffffff29d4) = 0
12186: fcntl(13, F_SETFD, 1) = 0
12186: ioctl(13, FIONBIO, 0x9fffffffffff2b1c) = 0
12186: gettimeofday(0x9fffffffffff1970, NULL) = 0
12186: access("/tmp/.oracle", F_OK) = 0
12186: chmod("/tmp/.oracle", 01777) ERR#1 EPERM
12186: socket(AF_UNIX, SOCK_STREAM, 0) = 15
12186: access("/tmp/.oracle/sprocr_local_conn_0_PROC", F_OK) = 0
12186: connect(15, 0x9fffffffffff1390, 94) = 0
12186: fcntl(15, F_SETFD, 1) = 0
12186: sigaction(SIGPIPE, 0x9fffffffffff1590, 0x9fffffffffff15c0) = 0
12186: gettimeofday(0x9fffffffffff1970, NULL) = 0
12186: gettimeofday(0x9fffffffffff1970, NULL) = 0
12186: ioctl(15, FIONBIO, 0x9fffffffffff2abc) = 0
12186: write(15, "\0\0\00 \001\00101\001\0\0\0\001".., 48) = 48
12186: gettimeofday(0x9fffffffffff2e20, NULL) = 0
12186: poll(0x60000000003635c8, 2, -1) = 1
12186: gettimeofday(0x9fffffffffff2e20, NULL) = 0
12186: poll(0x60000000003635c8, 2, -1) [sleeping]
Solution:
This issue is matching for OS bug QX:QXCR1000940361
so, applying the patch PHKL_40208 (and other recommended patches) should help resolving the issue here.
Recommended patches
PHKL_38762
PHKL_40208
PHKL_38733
PHKL_38623
References:
Note 2059882.102 "PROTECTIONS INCORRECT ON /TMP/.ORACLE IPC SOCKET FILES AFTER /TMP RESTORE"
Note 434062.1 "Listener Fails To Start With IPC Permission Errors (TNS-12546 TNS-12555 TNS-00516 TNS-00525)"
No comments:
Post a Comment