Home » RDBMS Server » Server Administration » TNSLISTENER is getting killed
TNSLISTENER is getting killed [message #136840] Sun, 11 September 2005 12:46 Go to next message
furseal
Messages: 6
Registered: September 2005
Location: US
Junior Member
I am using Oracle 9.2.5.0 version on my laptop (windows xp). All of sudden, tnslistener is getting killed whenever I tried to load data to DB via java application. Once it is killed, the CPU consumption by oracle.exe is 100%.
What's the root cause of this issue? How can I fix this?

Regards,
Hae-Goo

Report message to a moderator

Re: TNSLISTENER is getting killed [message #136896 is a reply to message #136840] Mon, 12 September 2005 03:02 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
enable tracing & then check.

Report message to a moderator

Re: TNSLISTENER is getting killed [message #136924 is a reply to message #136896] Mon, 12 September 2005 05:21 Go to previous messageGo to next message
furseal
Messages: 6
Registered: September 2005
Location: US
Junior Member

Hi Girishi,

First of all, I appreciate your reply.

I turned on trace and set the trc_level=support.
From listner.log, I was not able to get any meaningful message for issue tacking. Instead, I am uploading tarce.trc file for your reference. However, it seems that the last line does not show any error message.

nsbeqaddr: connect handshake is complete
nsbeqaddr: normal exit
nsbequeath: normal exit
nsglhe: exit
nsevwait: entry
nsevwait: 6 registered connection(s)
nsevwait: 0 pre-posted event(s)
nsevwait: waiting for transport event (0 thru 6)...

The full text of trace file is uploaded.

Regards,
Hae-Goo
  • Attachment: listener.trc
    (Size: 37.58KB, Downloaded 1000 times)

Report message to a moderator

Re: TNSLISTENER is getting killed [message #136934 is a reply to message #136924] Mon, 12 September 2005 06:03 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
looking at listener, it appears the listener is working fine. In fact it goes on waiting for new connection. Might be its getting terminated abnormally.

Can you enable further advance logging .. i.e. admin level & then see if any more is available.

you had mentioned that cpu utilization goes 100% when this problem occurs. Do you restart the listener then & the problem sorts out?

Report message to a moderator

Re: TNSLISTENER is getting killed [message #136944 is a reply to message #136934] Mon, 12 September 2005 07:20 Go to previous messageGo to next message
furseal
Messages: 6
Registered: September 2005
Location: US
Junior Member
Hi Girish,

I have updated a new trace log with admin option. Even if I restart the listener, the cpu utilization of oracle.exe is still 100% and the applicatons such as TOAD and JDBC loader do not work at all.
Is there anything that I can try?

Regards,
Hae-Goo

Report message to a moderator

Re: TNSLISTENER is getting killed [message #136952 is a reply to message #136944] Mon, 12 September 2005 07:58 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
This appears to be a issue related to system resources or the application program.

Is your listener running perfectly until you start the java program?

Report message to a moderator

Re: TNSLISTENER is getting killed [message #136954 is a reply to message #136952] Mon, 12 September 2005 08:07 Go to previous messageGo to next message
furseal
Messages: 6
Registered: September 2005
Location: US
Junior Member
Hi Girish,

It used to work fine. The problem also happens with non-java program such as sqlplus. After connecting to DB, if I execute a few select commands then it is being killed. Can this be caused by some anti-spyware program?

Regards,
Hae-Goo

Report message to a moderator

Re: TNSLISTENER is getting killed [message #137045 is a reply to message #136954] Mon, 12 September 2005 23:55 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
yeah might be.... because its not the normal behaviour of listener

Report message to a moderator

Re: TNSLISTENER is getting killed [message #137075 is a reply to message #137045] Tue, 13 September 2005 02:09 Go to previous messageGo to next message
furseal
Messages: 6
Registered: September 2005
Location: US
Junior Member
I there anyway to identify the applications that kill the listener? BTW, if that is the case, why the listener is killed only when I tried to use any DB connection? Do you have any clue on this?

Regards,
Hae-Goo

Report message to a moderator

Re: TNSLISTENER is getting killed [message #137174 is a reply to message #137045] Tue, 13 September 2005 10:14 Go to previous message
furseal
Messages: 6
Registered: September 2005
Location: US
Junior Member
Hi Girish,

Finally I found out a root cause. The problem was caused by spyware and after running spybot and isfix.exe, The problem went away.
Thanks for your help.

Regards,
Hae-Goo

Report message to a moderator

Previous Topic: ORA-01552 and ORA-01092 (merged 4 threads)
Next Topic: Documentation - SQLPLUS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 25 07:59:30 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.