LISTENER PROBLEM

[shailendra]

hi

I am getting one problem when I connect to database through a java application it is connection but after few minutes it gives me an error that Netword Adaptor could not establish connection but when I stop and start the listner again it works again and again it gives me error after some time what could be the problem and what is the solution of it?

Shailendra

[shailendra]

Is there any solution?

[Edited by shailendra on 07-11-2002 at 06:56 AM]

[shailendra]

Moderator please have a look at my problem I need it very urgently

Shailendra

[gopi]

Absolutely guessing here (and I am a far cry from a moderator):

Is there any timeout sqlnet.ora (client and/or server) configurations?

Any network configuration that times out? (ask your network admin)

Are there any session resources defined in the database that limits the session duration?

Hey, it's a stab in the dark!

[sumit]

Hello

I hope u r using Default Listener port. Is that correct? There is something AUTO REGISTRATION in Oracle 8i.

Let me know, I can give u the solution.

Thanks
Sumit

[gopi]

Hi Sumit,

If shailendra were having a problem with the listener port would he/she not be capable of making the connection in the first place?

So, concentrating on the listener:
Might there be a listener.ora parameter causing timeout or a timeout on the port itself???

Due to shailendra being capable of making the connection, I tend to believe it is a timeout problem some where, some how !?!

Perhaps a non-default port is being used and then getting overlayed by another process?

Once again, I'm guessing here

[sumit]

Hi Gopi,

Even it get connects , still u may get this sort problem , because of AUOTO REGISTRATION of listener running on default port. I happened to me.

Bye the way, without put ourselves into the problem place we just can guess.

Thanks

Sumit

[Shestakov]

Originally posted by shailendra
Moderator please have a look at my problem I need it very urgently

Shailendra

Before this message and ask moderators, please post to forum some addition information:
-- version of oracle db.
-- version of jdk
-- type of jdbc driver (thin or oci) -- and version too
-- are u using connection poll or only single connections
-- does ur application multithread (and connection establish in seperate thred or no)
-- type of oracle server architecture (dedicated connection or mts)
...

[marist89]

Originally posted by shailendra
hi

I am getting one problem when I connect to database through a java application it is connection but after few minutes it gives me an error that Netword Adaptor could not establish connection but when I stop and start the listner again it works again and again it gives me error after some time what could be the problem and what is the solution of it?

Shailendra

What's the error you are getting?
What type of JDBC Driver? (Thick/Thin)?
What type of connection (Dedicated/Shared)?
Does SQL*Plus work?
Are you experiencing other network problems?

[marist89]

Ah, we're thinking along the same lines. There are a couple of JDBC bugs with various types of connections and listener configurations. JDBC Thin and MTS connections are notoriously buggy.