Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Ratzie
Super Advisor

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

How do I connect to the oracle database to shut it down if the max number of connection have been reached?!!!
6 REPLIES
Steven E. Protter
Exalted Contributor

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

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Ratzie
Super Advisor

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

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
Honored Contributor
Solution

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

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.
it would be nice if you always got a second chance
Jean-Luc Oudart
Honored Contributor

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

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

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

Regards
Jean-Luc
fiat lux
Marcel Boogert_1
Trusted Contributor

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

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
Super Advisor

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

Thank you for your help.