<div>
It looks like there is an application in your computer which open connections and consumes &nbsp;much more <br />
process than your database PROCESSES definition defined in your spfile. You can increase the value of that.<br />

</div>


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.


<div>
for those inactive sessions, how many perl processes you see at the OS level when this happens ? and what OS is this btw ?
</div>


for those inactive sessions, how many perl processes you see at the OS level when this happens ? and what OS is this btw ?

<div>
Forced accept.<br />
<br />
Computer101<br />
EE Admin
</div>


<div>
<div class="content wysiwyg-content">
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 &quot;Enterprise Manager is not able to connect to the database instance. The state of the components are listed below.&quot; 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!!<br />
<br />

</div>
</div>


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!!



the user SYSTEM has many inactive process for OMS program

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.