OraFAQ Forum: Server Administration » number of processes exceeded in Oracle

Home » RDBMS Server » Server Administration » number of processes exceeded in Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

number of processes exceeded in Oracle [message #55737]

Thu, 13 February 2003 02:23

sahaslad
Messages: 23
Registered: May 2002

Junior Member

Hi,
I am having a stange problem & i dont know why this occured & would like to hear a solution from you.

The Problem is i got an error in my application as:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[[Microsoft]][[ODBC driver for Oracle]][[Oracle]]ORA-00020: maximum number of processes () exceeded

The problem got solved when i rebotted my machine.
Any idea why the error occured..

Thanks

Report message to a moderator

Re: number of processes exceeded in Oracle [message #55740 is a reply to message #55737]

Thu, 13 February 2003 05:21

Remi Visser
Messages: 44
Registered: December 2002

Member

INIT parameter processes reached treshhold:

To solve:

See what the value is of your processes parameter, you can look in the init.ora file or use this query:

SQL> SELECT * FROM sys.v_$parameter WHERE name = 
'processes';

Now you can look how many processes are attached:

SQL> SELECT COUNT(1) FROM V$PROCESS;

  COUNT(1)
----------
        14

Hope this helps!

Remi

http://ora-0000.com

Report message to a moderator

Previous Topic:	Re: LOG MEMBER??
Next Topic:	Install 9i and 9iAS on unix machine.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 28 09:11:30 CST 2024