Database Administration (MOSC)

MOSC Banner

Oraprod unix process

edited Jun 17, 2009 8:29AM in Database Administration (MOSC) 4 commentsAnswered
hi, experts,

I need your help very urgently. I have a lot of oraprod unix as shown below :

 oraprod 16874     1  0 22:44:35 ?         0:00 oraclePROD (LOCAL=NO)
 oraprod 17108     1  0 22:45:18 ?         0:00 oraclePROD (LOCAL=NO)
 oraprod 17132     1  0 22:45:18 ?         0:00 oraclePROD (LOCAL=NO)
 oraprod 17126     1  0 22:45:18 ?         0:00 oraclePROD (LOCAL=NO)
 oraprod 18500     1  0 23:00:02 ?         0:00 oraclePROD (LOCAL=NO)

the number of process keep increasing and exceed my maximum process set in initPROD.ora.

I have to restart server 2 times a day to clear all this process or user will have problem to login to Oracle.

I have try to create a profile with idletime = 10, and assign APPS to it, but  after this, I will get a lot of error message like :

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center