Idle Oracle Process has removed automatically in AIX5.2 - AIX

balareddy · #1 (**permalink**) 02-13-2007

Hello,

I am creating oracle connection from one aix5.2 machine to another aix5.2 database machine. Oracle connection i am reusing it always. If there is now work for java thread to process, oracle instance will be idle and will be active once java thread processes.

We have installed OS Technical patch(5200-09) recently in both machines. After this patch, Oracle connection is getting removed after sometime in database AIX machine. So, Java application is getting ORA-03113 error.

There is no timeout parameters for oracle. It was working fine before installing new OS patch.

IS there any kernal parameter removing oracle process after some hours of idle time????

prash_prabhu · #2 (**permalink**) 06-26-2008

Hi,
I am also facing same problem.
Both client which is connecting to oracle db and oracle db are in same server AIX 5.3.
There is no timeout parameter for oracle and there is no trace file generated for this error.

What could be the problem.

Regards,
Prashant Prabhu.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Oracle 10G best practices on Power6 AIX5.3	JodyTek	AIX	1	05-07-2008 04:41 AM
How to see if the process is idle	pbsrinivas	UNIX for Dummies Questions & Answers	1	11-26-2007 03:16 AM
Oracle Process has removed from AIX5.2	balareddy	AIX	0	02-13-2007 07:34 AM
finding idle time of a process	Krrishv	Shell Programming and Scripting	36	01-10-2007 05:34 AM
How to start Oracle database automatically	greg0320	SUN Solaris	3	03-30-2005 02:46 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode