Listner dies after making a connection

[ifxtechie]

Hi
I need some help. Since this problem is with JDBC-JAVA-Oracle, I posted here. I am trying to access the db using JSP through Tomcat webserver. Once my JSP makes connection, the listner dies. The same thing happens with Java program also. I have to restart the listner through services and again i have to run my jsp.I don't know where the problem is.
History : I just added one more connection to another db and I removed. Then I was getting the error as
'Io exception: The Network Adapter could not establish the connection - oracle error in jdbc '
[Even now I get this error whenever I try to make new db connection in Oracl JDeveloper.]
Environment : Windows-2000, Oracle 9i, Tomcat, Oracle J Developer, java 1.3.1_01.
Can anybody tell me how to retain the listner so that a continuos connection is there
thanks in advance
P

Parthasarathy

 

[Turkbear]

In general there must be something causing an error ( big surprise) since the listener should remain running with no additional action on your part once it is started.
The Listener 'hands off' the connection to the database and ceases to be involved after that, so maybe it is seen as 'inactive' and is killed by some cleanup process???

Perhaps the memory on the PC
(with all those things running - W2K,Tomcat,DataBase Instance, a listener,JDeveloper, etc)
is insufficent...
Does the Event Log reveal anything interesting? How about the alert log in Oracle?

 

[jee]

Another way to get information:

Turn on tracing in your listener.ora file

TRACE_LEVEL_LISTENER = 16

Then restart the listener and do whatever you do that causes the problem. Then look at the trace file:

On Windows this would be
<Oracle-home>\network\trace\listener.trc

 

[ifxtechie]

Hi Jee & Turkbear,
Thanks for the suggestions.
Since I don't know much about Listner.ora file, I need some help in settinng that as above. can you pls help me as to how the entry can be added. My Listner.ora file looks like as below:
# LISTENER.ORA Network Configuration File: F:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = compaq-lptp)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = par)
(ORACLE_HOME = F:\Oracle\Ora81)
(SID_NAME = par)
)
)

thanks
p

Parthasarathy

 

[jee]

You can put it right at the end, on a line by itself after the last &quot&quot;.

 

[Jiri]

Hi!

I am having the same problem. I have two application servers and one db. From one I can connect to the database without any problem, the second one throws exception &quot;Network adapter could not establish the connection&quot;. What is funny, is that I can connect to the db from both server by sqlplus. Every server is on own machine. I connect to db by JDBC.