Solved

the user SYSTEM has many inactive process for OMS program

Posted on 2007-11-19
5
2,481 Views
Last Modified: 2012-06-27
has anyone come across an issue where the user SYSTEM has many inactive process for OMS program, in fact all avaliable processes are taken up over a small time-frame giving a TNS-12516 error when you try to make a connection (for example via Toad) after all processes have been taken. In stopping the DBconsole service all these processes are killed and processes made available again. Also, when you open OEM you get the message "Enterprise Manager is not able to connect to the database instance. The state of the components are listed below." but the Instance, Listener and Agent Connection to Instance are showing up and running (you can see the up and green arrow!). Not sure why this is occuring and have researched but can not find a solution!!

0
Comment
Question by:kyithaw
  • 2
5 Comments
 
LVL 2

Expert Comment

by:auyuksel
ID: 20314612
It looks like there is an application in your computer which open connections and consumes  much more
process than your database PROCESSES definition defined in your spfile. You can increase the value of that.
0
 
LVL 9

Accepted Solution

by:
techji earned 500 total points
ID: 20326004
You are better off using SYSMAN or any other DBA account for logging in to dbconsole or OEM.

Your PROCESSES initialization parameter is obviously too low. Increase it to a sufficiently high number.

TNS-12516 : TNS:listener could not find instance with matching protocol stack
You get this error when LISTENER blocks any new connections to the database, cause all the processes were taken. When you get that error, do a lsnrctl status, you would see the state of the service handler for the instance to "blocked".

This is not a bug. By way of instance registration, PMON is responsible for updating the listener with information about a particular instance such as load and dispatcher information. Maximum load for dedicated connections is determined by the PROCESSES parameter. The frequency at which PMON provides SERVICE_UPDATE information varies according to the workload of the instance. The maximum
interval between these service updates is 10 minutes.

The listener counts the number of connections it has established to the instance but does not immediately get information about connections that have terminated. Only when PMON updates the listener via SERVICE_UPDATE is the listener informed of current load. Since this can take as long as 10 minutes, there can be a difference between the current instance load according to the listener and the actual instance load.

When the listener believes the current number of connections has reached maximum load, it may set the state of the service handler for an instance to "blocked" and begin refusing incoming client connections with either of the following errors:

TNS-12516 TNS:listener could not find instance with matching protocol stack
TNS-12519 TNS:no appropriate service handler found
0
 
LVL 9

Expert Comment

by:techji
ID: 20326030
for those inactive sessions, how many perl processes you see at the OS level when this happens ? and what OS is this btw ?
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20591482
Forced accept.

Computer101
EE Admin
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now