Home » RDBMS Server » Networking and Gateways » Problem Oracle Listner.log (Oracle version 9.2.0.1.0)
Problem Oracle Listner.log [message #342793] Mon, 25 August 2008 02:24 Go to next message
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.
Re: Problem Oracle Listner.log [message #342795 is a reply to message #342793] Mon, 25 August 2008 02:28 Go to previous messageGo to next message
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
Re: Problem Oracle Listner.log [message #342799 is a reply to message #342795] Mon, 25 August 2008 02:36 Go to previous messageGo to next message
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

Re: Problem Oracle Listner.log [message #342800 is a reply to message #342799] Mon, 25 August 2008 02:42 Go to previous message
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



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


Current Time: Fri Mar 29 01:00:25 CDT 2024