OraFAQ Forum: Networking and Gateways » Problem Oracle Listner.log

Home » RDBMS Server » Networking and Gateways » Problem Oracle Listner.log (Oracle version 9.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem Oracle Listner.log [message #342793]

Mon, 25 August 2008 02:24

deepti.misra
Messages: 2
Registered: August 2008
Location: luck

Junior Member

I required help regarding oracle listner.log.

Problem: Why Oracle listner.log is showing more jdbc connection?

With the help of pcp tool output it is showing connection to the java.

My objective is that i don't want unnecessary connection establishment to java.

Please help me.what i do to prevent this unnecessary connection establishment (as shown in listner.log)

Thanks in advance.

Report message to a moderator

Re: Problem Oracle Listner.log [message #342795 is a reply to message #342793]

Mon, 25 August 2008 02:28

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

There is no problem with listener.log file.

this is just a log file which logged database connection information.

you have to review your JAVA application and FIX them so they open minimum connection.

Regards,
Taj

Report message to a moderator

Re: Problem Oracle Listner.log [message #342799 is a reply to message #342795]

Mon, 25 August 2008 02:36

deepti.misra
Messages: 2
Registered: August 2008
Location: luck

Junior Member

Thanks a lot you respond me.

It means problem with java application but one thing i want to share with you.How we can see the log of connection is expired because session must be expired.It should be logged.

Ok i am going for code review.

I will ping you if i didn't found out the problem with JAVA Application Code.

Thanks

Report message to a moderator

Re: Problem Oracle Listner.log [message #342800 is a reply to message #342799]

Mon, 25 August 2008 02:42

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

..expired because session must be expired.It should be logged...

you can set idle_time in user profile so that after fixed time period session will automatically disconnected.

Regards,
Taj

Report message to a moderator

Previous Topic:	gateway for drda(db2udb8.1) ora-28527
Next Topic:	WARNING: Subscription for node down event still pending

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 02:01:02 CDT 2025