Login or Register to Ask a Question and Join Our Community


AIX

Oracle Process has removed from AIX5.2

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Operating Systems AIX Oracle Process has removed from AIX5.2
# 1  
Old 02-13-2007
Oracle Process has removed from AIX5.2
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????
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Kill all process of Oracle user

Hi folks, I want to kill all process of oracle user and won't kill shell, should i try this? Please confirm. 1st way pgrep -u oracle | sudo xargs kill -9 2nd way killall -u oracle (2 Replies)
Discussion started by: learnbash
2 Replies

2. AIX

SIGHUP killing Oracle Listener Process

I have a cold backup script which backs up my database and then restarts the oracle listener and database at around 01:30 I can see at this time that my database and listener are indeed running. However at around 02:17 my listener process receives a SIGHUP 1 signal from the AIX OS ( version 5.3 )... (2 Replies)
Discussion started by: jimthompson
2 Replies

3. AIX

oracle process appears to die

periodically my oracle 11.2.0.1 listener process 'tnslsnr' seems to crash and disappear ( I am using an AIX 6.1 unix platform ). When this happens I am able to restart my listener ok. However when this happens there is is no stop recorded in my listener log (as there normally would be - hence why I... (1 Reply)
Discussion started by: jimthompson
1 Replies

4. Shell Programming and Scripting

Oracle Process Memory calculation

Hello, I am using Rehat Oracle Enterprise server. Every time almost 150 process running on my server. #ps -ef | grep oracle | wc -l Now i want to calculate how much memory spend by each process or all process together. (1 Reply)
Discussion started by: telnor
1 Replies

5. AIX

How to upgrade AIX5.3TL6-07 to AIX5.3TL8-04?

Hello All, After creating lpp_source/spot from AIX 5.3TL6-07 DVD on the NIM(AIX6.1), I went online and download the fix pack for reaching TL8-04. (it was less than 200Mgegs total) then I did define a newer lpp_source530TL8-04 via a copy from the older lpp_source530TL6-07 (I diduse a command... (2 Replies)
Discussion started by: sangers
2 Replies

6. AIX

Idle Oracle Process has removed automatically in AIX5.2

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... (1 Reply)
Discussion started by: balareddy
1 Replies

7. AIX

Oracle 10G best practices on Power6 AIX5.3

Can anyone point me to any best practices for partitioning, resource prerequisites, and implementation of Oracle 10G release 2 with RAC on 2 power6 550's running AIX5.3 as a cluster? (1 Reply)
Discussion started by: JodyTek
1 Replies

8. UNIX for Dummies Questions & Answers

How to find the port number of the oracle process

Hi Unix Gurus, Can we find out the port number used by the oracle process is running.I tried to search the forum but coudnt find. Can anyone help me out with the command (2 Replies)
Discussion started by: thana
2 Replies

9. UNIX for Advanced & Expert Users

oracle process query !

This query is For HP-UX 11i server. I have certain oracle process that are running on my system as below :- rotmgr 3986 1 0 07:49:33 ? 0:00 oracleedjlive (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) rotmgr 26356 1 0 08:14:32 ? 0:00 oracleedjlive... (4 Replies)
Discussion started by: kpatel786
4 Replies

10. UNIX for Dummies Questions & Answers

killing parallel oracle process

Hi guys: I have a an oracle job which uses 10 parallel hints and would like to killit when it hangs. I want to kill all the processes that have been spawned. what I do right now is get the pid of the scheduler process which initiated theis job and the do a ps -ef| grep 'pid' and trace through... (1 Reply)
Discussion started by: oracle8
1 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

make-sqldeveloper-package

MAKE-SQLDEVELOPER-PACKAGE(1)			    Oracle SQL Developer Debian package builder 		      MAKE-SQLDEVELOPER-PACKAGE(1)

NAME

       make-sqldeveloper-package - Oracle SQL Developer Debian package builder

SYNOPSIS

       make-sqldeveloper-package [options] <file>

DESCRIPTION

       make-sqldeveloper-package is a utility that builds a Debian package for Oracle SQL Developer.

       The  Oracle  SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with
       the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility
       to  use	the  resulting package acordingly with the OTN license, a copy of which is included in the created package, that you must agree on
       when downloading the source.

       This utility will require you to download the "Oracle SQL Developer  for  other	platforms"  archive  from  <http://www.oracle.com/technet-
       work/developer-tools/sql-developer/> to create the Debian package from.

OPTIONS

       -b|--build-dir <dir>
	      base directory to build package (autogenerated)

       -e|--email <email>
	      local maintainer email (use DEBEMAIL or auto-generate)

       -i|--install
	      install the generated package - needs root privilege (no)

       -k|--keep-dir
	      keep the build directory (no)

       -l|--revision <number>
	      local revision to append to package version (1)

       -m|--maintainer <name>
	      local maintainer name (use DEBFULLNAME or leave empty)

       -r|--root-command <command>
	      command to gain root privilege for package build (fakeroot)

       -u|--upstream-version <version>
	      force the upstream version (autodetected)

       -h|--help
	      display the help screen

       -v|--version
	      show the program version

       <file> the "Oracle SQL Developer for other platforms" archive from <http://www.oracle.com/technetwork/developer-tools/sql-developer/>

AUTHOR

       make-sqldeveloper-package was written by Lazarus Long <lazarus.long@bigfoot.com>.

       This manual page was written by Lazarus Long <lazarus.long@bigfoot.com>, for the Debian project (but may be used by others).

GNU
								    2012-11-13					      MAKE-SQLDEVELOPER-PACKAGE(1)