Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

General Questions


IPC Send timeout detected. Receiver ospid 4371 -- IN ALERT LOG


Mon Jul  4 08:26:05 2011 ARC0: Evaluating archive   log 2 thread 1 sequence 5458 ARC0: Beginning to archive log 2 thread 1 sequence 5458 Creating archive destination LOG_ARCHIVE_DEST_1: '/u02/arch/arch_1_5458.arc' ARC0: Completed archiving  log 2 thread 1 sequence 5458 Mon Jul  4 10:05:52 2011 IPC Send timeout detected. Receiver ospid 4371 Mon Jul  4 10:06:04 2011 Errors in file /u01/app/oracle/admin/mosa/bdump/mosa1_lck0_4371.trc:  ====================================   Below given is the TRACE FILE for mosa1_lck0_4371.trc ====================================  /u01/app/oracle/admin/mosa/bdump/mosa1_lck0_4371.trc Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production ORACLE_HOME = /u01/app/oracle/product/920 System name:	HP-UX Node name:	hp_data1 Release:	B.11.11 Version:	U Machine:	9000/800 Instance name: mosa1 Redo thread mounted by this instance: 1 Oracle process number: 17 Unix process pid: 4371, image: oracle@hp_data1 (LCK0)  *** SESSION ID:(19.1) 2011-06-24 19:53:38.123 KSXPLOOKUP: kjxgnqry failed KSXP 420LCK0 8 7 ksxrcon1: Connecting to instance 1 failed with error 7. *** 2011-06-25 11:42:45.000 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (1 msec) ctx ts 0x36502ab last ts 0x36502aa user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 0 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x3650278 buffers queued on port 800000010019da28     sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks 0x514c5003 0x4ba0043f     32      3   4476  37249  37249      0     10  37159 slot 3 rqh=80000001001c35d8 seq=4475 len=160 accno=0x4ba0043f start TS=0x364ea0f rt TS=0x36502df X CNT=10 0x514c5004 0x3a594942     32      3  33374    611    611      0      0    600        ach     accono     sconno      admno  state lstack nxtseq    rcv rtrans   acks credts 0x80000001001de480 0x165e7c2a 0x4a80027c 0x4d5f87f0     40  33282  33282    519      0    509      8 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (1 msec) ctx ts 0x36517ee last ts 0x36517ed user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 1 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x36517de buffers queued on port 800000010019da28     sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks 0x514c5003 0x4ba0043f     64      3   4477  37250  37250      0     25  37160 0x514c5004 0x3a594942     32      3  33374    611    611      0      0    600        ach     accono     sconno      admno  state lstack nxtseq    rcv rtrans   acks credts 0x80000001001de480 0x165e7c2a 0x4a80027c 0x4d5f87f0     40  33282  33282    519      0    509      8 *** 2011-06-26 07:20:12.028 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (5 msec) ctx ts 0x79affa4 last ts 0x79aff9f user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 5 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x79aff64 buffers queued on port 800000010019da28     sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks 0x514c5003 0x4ba0043f     32      3  27535 125844 125844      0     34 125697 slot 6 rqh=80000001001c39c0 seq=27534 len=160 accno=0x4ba0043f start TS=0x79aea19 rt TS=0x79b02b0 X CNT=10 0x514c5004 0x3a594942     32      3  33757    994    994      0      9    965        ach     accono     sconno      admno  state lstack nxtseq    rcv rtrans   acks credts 0x80000001001de480 0x165e7c2a 0x4a80027c 0x4d5f87f0     40  33568  33568    805      0    782      8 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (0 msec) ctx ts 0x79b1557 last ts 0x79b1557 user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 6 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x79b151c buffers queued on port 800000010019da28     sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks 0x514c5003 0x4ba0043f     32      3  27536 125845 125845      0     48 125697 slot 6 rqh=80000001001c39c0 seq=27534 len=160 accno=0x4ba0043f start TS=0x79aea19 rt TS=0x79b1728 X CNT=15 slot 7 rqh=80000001001c2e08 seq=27535 len=160 accno=0x4ba0043f start TS=0x79affc7 rt TS=0x79b1868 X CNT=10 0x514c5004 0x3a594942     32      3  33757    994    994      0      9    965        ach     accono     sconno      admno  state lstack nxtseq    rcv rtrans   acks credts 0x80000001001de480 0x165e7c2a 0x4a80027c 0x4d5f87f0     40  33568  33568    805      0    782      8 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (0 msec) ctx ts 0x79b2d68 last ts 0x79b2d68 user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 8 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x79b2cfb buffers queued on port 800000010019da28     sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks 0x514c5003 0x4ba0043f     32      3  27537 125846 125846      0     69 125697 slot 0 rqh=80000001001c6508 seq=27536 len=160 accno=0x4ba0043f start TS=0x79b156b rt TS=0x79b2e20 X CNT=10 slot 6 rqh=80000001001c39c0 seq=27534 len=160 accno=0x4ba0043f start TS=0x79aea19 rt TS=0x79b2f87 X CNT=21 slot 7 rqh=80000001001c2e08 seq=27535 len=160 accno=0x4ba0043f start TS=0x79affc7 rt TS=0x79b30fb X CNT=16 0x514c5004 0x3a594942     32      3  33757    994    994      0      9    965        ach     accono     sconno      admno  state lstack nxtseq    rcv rtrans   acks credts 0x80000001001de480 0x165e7c2a 0x4a80027c 0x4d5f87f0     40  33568  33568    805      0    782      8 *** 2011-06-26 07:42:10.288 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (11 msec) ctx ts 0x7af1d1e last ts 0x7af1d13 user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 4 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x7af1ce1 buffers queued on port 800000010019da28     sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks 0x514c5003 0x4ba0043f     32      3  28214 126523 126523      0    106 126373 slot 5 rqh=80000001001c0ae0 seq=28213 len=160 accno=0x4ba0043f start TS=0x7af0771 rt TS=0x7af202d X CNT=10 0x514c5004 0x3a594942     32      3  33786   1023   1023      0      9    991        ach     accono     sconno      admno  state lstack nxtseq    rcv rtrans   acks credts 0x80000001001de480 0x165e7c2a 0x4a80027c 0x4d5f87f0     40  33573  33573    810      0    787      8 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (0 msec) ctx ts 0x7af352d last ts 0x7af352d user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 6 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x7af34bf buffers queued on port 800000010019da28     sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks 0x514c5003 0x4ba0043f     32      3  28215 126524 126524      0    121 126373 slot 5 rqh=80000001001c0ae0 seq=28213 len=160 accno=0x4ba0043f start TS=0x7af0771 rt TS=0x7af38bf X CNT=16 slot 6 rqh=80000001001c8448 seq=28214 len=160 accno=0x4ba0043f start TS=0x7af1d45 rt TS=0x7af35e5 X CNT=10 0x514c5004 0x3a594942     32      3  33786   1023   1023      0      9    991        ach     accono     sconno      admno  state lstack nxtseq    rcv rtrans   acks credts 0x80000001001de480 0x165e7c2a 0x4a80027c 0x4d5f87f0     40  33573  33573    810      0    787      8 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (0 msec) ctx ts 0x7af4f31 last ts 0x7af4f31 user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 7 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x7af4ef6 buffers queued on port 800000010019da28     sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks 0x514c5003 0x4ba0043f     32      3  28216 126525 126525      0    144 126373 slot 5 rqh=80000001001c0ae0 seq=28213 len=160 accno=0x4ba0043f start TS=0x7af0771 rt TS=0x7af5142 X CNT=22 slot 6 rqh=80000001001c8448 seq=28214 len=160 accno=0x4ba0043f start TS=0x7af1d45 rt TS=0x7af5242 X CNT=17 slot 7 rqh=80000001001b6e00 seq=28215 len=160 accno=0x4ba0043f start TS=0x7af3541 rt TS=0x7af5202 X CNT=11 0x514c5004 0x3a594942     32      3  33786   1023   1023      0      9    991        ach     accono     sconno      admno  state lstack nxtseq    rcv rtrans   acks credts 0x80000001001de480 0x165e7c2a 0x4a80027c 0x4d5f87f0     40  33573  33573    810      0    787      8 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (0 msec) ctx ts 0x7af6679 last ts 0x7af6679 user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 8 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x7af6647 buffers queued on port 800000010019da28     sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks 0x514c5003 0x4ba0043f     32      3  28217 126526 126526      0    169 126373 slot 0 rqh=80000001001cf1f8 seq=28216 len=160 accno=0x4ba0043f start TS=0x7af4f45 rt TS=0x7af6821 X CNT=10 slot 5 rqh=80000001001c0ae0 seq=28213 len=160 accno=0x4ba0043f start TS=0x7af0771 rt TS=0x7af6a13 X CNT=28 slot 6 rqh=80000001001c8448 seq=28214 len=160 accno=0x4ba0043f start TS=0x7af1d45 rt TS=0x7af66ed X CNT=22 slot 7 rqh=80000001001b6e00 seq=28215 len=160 accno=0x4ba0043f start TS=0x7af3541 rt TS=0x7af666d X CNT=16 0x514c5004 0x3a594942     32      3  33786   1023   1023      0      9    991        ach     accono     sconno      admno  state lstack nxtseq    rcv rtrans   acks credts 0x80000001001de480 0x165e7c2a 0x4a80027c 0x4d5f87f0     40  33573  33573    810      0    787      8 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (0 msec) ctx ts 0x7af8087 last ts 0x7af8087 user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 9 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x7af804c buffers queued on port 800000010019da28     sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks 0x514c5003 0x4ba0043f     32      3  28218 126527 126527      0    205 126373 slot 0 rqh=80000001001cf1f8 seq=28216 len=160 accno=0x4ba0043f start TS=0x7af4f45 rt TS=0x7af80b2 X CNT=16 slot 1 rqh=80000001001c1a80 seq=28217 len=160 accno=0x4ba0043f start TS=0x7af668d rt TS=0x7af8318 X CNT=11 slot 5 rqh=80000001001c0ae0 seq=28213 len=160 accno=0x4ba0043f start TS=0x7af0771 rt TS=0x7af8298 X CNT=34 slot 6 rqh=80000001001c8448 seq=28214 len=160 accno=0x4ba0043f start TS=0x7af1d45 rt TS=0x7af8398 X CNT=29 slot 7 rqh=80000001001b6e00 seq=28215 len=160 accno=0x4ba0043f start TS=0x7af3541 rt TS=0x7af8318 X CNT=23 0x514c5004 0x3a594942     32      3  33786   1023   1023      0      9    991        ach     accono     sconno      admno  state lstack nxtseq    rcv rtrans   acks credts 0x80000001001de480 0x165e7c2a 0x4a80027c 0x4d5f87f0     40  33573  33573    810      0    787      8 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (0 msec) ctx ts 0x7af9ac7 last ts 0x7af9ac7 user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 11 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x7af9a95 buffers queued on port 800000010019da28     sconno     accono   ertt  state   seq#   sent  async   sync rtrans   acks 0x514c5003 0x4ba0043f     32      3  28219 126528 126528      0    246 126373 slot 0 rqh=80000001001cf1f8 seq=28216 len=160 accno=0x4ba0043f start TS=0x7af4f45 rt TS=0x7af9d21 X CNT=23 slot 1 rqh=80000001001c1a80 seq=28217 len=160 accno=0x4ba0043f start TS=0x7af668d rt TS=0x7af9bb2 X CNT=17 slot 2 rqh=80000001001c93e8 seq=28218 len=160 accno=0x4ba0043f start TS=0x7af809b rt TS=0x7af9d61 X CNT=11 slot 5 rqh=80000001001c0ae0 seq=28213 len=160 accno=0x4ba0043f start TS=0x7af0771 rt TS=0x7af9b72 X CNT=40 slot 6 rqh=80000001001c8448 seq=28214 len=160 accno=0x4ba0043f start TS=0x7af1d45 rt TS=0x7af9bf2 X CNT=35 slot 7 rqh=80000001001b6e00 seq=28215 len=160 accno=0x4ba0043f start TS=0x7af3541 rt TS=0x7af9bb2 X CNT=29 0x514c5004 0x3a594942     32      3  33786   1023   1023      0      9    991        ach     accono     sconno      admno  state lstack nxtseq    rcv rtrans   acks credts 0x80000001001de480 0x165e7c2a 0x4a80027c 0x4d5f87f0     40  33573  33573    810      0    787      8 ksxpdmp:  facility 0 (?) (0x1, 0000000000000000) counts 0, 0 ksxpdmp:  Dumping the osd context SKGXPCTX: 0x80000001001948c8 ctx wait delta 0 sec (0 msec) ctx ts 0x7afb36e last ts 0x7afb36e user cpu time since last wait 0 sec 0 ticks system cpu time since last wait 0 sec 0 ticks locked 1 blocked 0 timed wait receives 0 SKGXPCTX: 0x1948c8 ctx admno 0x78933698 admport: SSKGXPT 0x194b44 flags  	info for network 0 	socket no 10 	IP 100.100.100.1 	UDP 51759 	sflags SSKGXPT_WRITESSKGXPT_UP  	info for network 1 	socket no 0 	IP 0.0.0.0 	UDP 0 	sflags SSKGXPT_DOWN  context timestamp 0x7afb345 buffers queued on port 800000010019da28

OS = HP-UX 11.11 DB = Oracle 9i ( 9.2.0.8 )  During regular check on alert file, i found this IPC error, can anyone tell me the root cause of the issue and let me know the solution too.   Thank you,


Related Links

High water mark
can't seem to select or purge drop object from the dba_recyclebin
Can't ACCESS/STOP EnterpriseManager
CPU on Windows
Table Scan in stats$user_log
Database Design
ORA-01918: user does not exist
ORA-01918: user does not exist
need to select all columns but one.
Storing formatted text in Oracle 11GR2
oraclemtsrecoveryservice problem
Import DBF back into Oracle 10G
Rewrite the predicate into an equivalent form to take advantage of indices
Select Entire Row latest row
set/unset event 44951
Doing re-organization of database every week is good or bad ?