Can not connect to oracle database, max number of users reached

[Ratzie]

How do I connect to the oracle database to shut it down if the max number of connection have been reached?!!!

[Steven E. Protter]

Whats the error message?

Oracle doesn't built that kind of stuff into the database. You can do as many users as you wish.

You can log into sqlplus and log users out, if I'm wrong.

Also: Version of Oracle and the OS would be helpful to further assist you.

SEP

[Ratzie]

Sorry it is max number of processes

"You have exceeded the process limit" when you try to log into sqlplus
Oracle 8, sun 2.7

[john korterman · Accepted solution]

Hi,
first, locate one or more users and make them logoff. Then maybe this thread may help:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?admit=716493758+1098378742981+28353475&threadId=222600

regards,
John K.

[Jean-Luc Oudart]

check the "processes" entry in init.ora config file.

Obviously too low.
Increase it to expected number + margin , bounce database.

Regards
Jean-Luc

[Marcel Boogert_1]

Hi there,

You can also login to Oracle from HP-UX. Just use the following from the Oracle owner:

$ export ORACLE_SID=
$ sqlplus
For username enter: / as sysdba

This should do the trick.

MB.

[Ratzie]

Thank you for your help.