Solved

the user SYSTEM has many inactive process for OMS program

Posted on 2007-11-19
5
2,612 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
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…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

688 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