Q
Problem solve Get help with specific problems with your technologies, process and projects.

Why is the listener terminating?

I installed Oracle 9.2 and everything seems to be running fine. However, when I connect using Enterprise Manager and start the SQL worksheet, the listener terminates. Do you know what's going on?
I have not experienced the symptom you're seeing, so I'd expect that you are experiencing a bug in the release or a platform-specific bug. The first thing I would do is to apply the 9.2.0.6 patchset and see if your issue disappears. You should also set a password on the listener just incase it is someone or something stopping your listener remotely. If it is still unclear what's happening to the listener and the listener.log file doesn't suggest anything obvious, you can also enable listener tracing using the trace_*_ parameters in the listener.ora. The only necessary parameter will be trace_level_ =16.

If none of those avenues uncover anything, then you should file a TAR with Oracle Support.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close