Oracle: TNS:lost contact on 11.11

[siddharth_2]

ooops! sorry for the multiple postings. My browser hung and...



Anyways, I'd appreciate any help on the problem.



thanks & apologies,

siddharth

[Anthony deRito]

This is what I found...

# oerr ora 12547

12547, 00000, "TNS:lost contact"
// *Cause: Partner has unexpectedly gone away, usually during process
// startup.
// *Action: Investigate partner application for abnormal termination. On an
// Interchange, this can happen if the machine is overloaded.

I guess you can get a before and after shot at the listener with lsof. Here is a listing I did on my listener:

# lsof -p 3402

COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
tnslsnr 3402 oracle cwd VDIR 64,0x1 5120 2 /
tnslsnr 3402 oracle txt VREG 64,0x90003 5575936 1780 /opt/ora.8.0.6.2.0 (/dev/vg09/lvol3)
tnslsnr 3402 oracle mem VREG 64,0x5 528384 1391 /usr/lib/libcma.1
tnslsnr 3402 oracle mem VREG 64,0x5 12288 1343 /usr/lib/libdld.1
tnslsnr 3402 oracle mem VREG 64,0x5 1863680 1160 /usr/lib/libc.1
tnslsnr 3402 oracle mem VREG 64,0x5 114688 1342 /usr/lib/dld.sl
tnslsnr 3402 oracle 0r VCHR 3,0x2 0t0 4610 /dev/null
tnslsnr 3402 oracle 1w VREG 64,0x1 146919 606 / (/dev/vg00/lvol1)
tnslsnr 3402 oracle 2w VREG 64,0x1 146919 606 / (/dev/vg00/lvol1)
tnslsnr 3402 oracle 3w VREG 64,0x170002 1504366 6 /opt/orasid (/dev/vg12/lvol2)
tnslsnr 3402 oracle 4r VREG 64,0x90003 11264 1375 /opt/ora.8.0.6.2.0 (/dev/vg09/lvol3)
tnslsnr 3402 oracle 5r PIPE 0x08d99b04 0 2085
tnslsnr 3402 oracle 6u unix 0x08e7ce00 0t0 /tmp/.oracle/sctaimp0
tnslsnr 3402 oracle 7r VREG 64,0x90003 39424 1397 /opt/ora.8.0.6.2.0 (/dev/vg09/lvol3)
tnslsnr 3402 oracle 8w PIPE 0x0890d704 0 2086
tnslsnr 3402 oracle 9u unix 0x08e7cb00 0t0 /tmp/.oracle/s#3402.1
tnslsnr 3402 oracle 10u inet 0x08d15b00 0t0 TCP *:ctaimp0_lsnr (LISTEN)
tnslsnr 3402 oracle 11u inet 0x08e59e00 0t0 UDP *:1253

Check if the process has lost contact with any open files.

After the problem occurs, run lsof again and compare results. Also watch glance at the process level before and after problem occurs.

Tony