| ORA-00018 [message #117953] |
Mon, 02 May 2005 02:10  |
JoinNepal
Messages: 33
Registered: October 2003
|
Member |
|
|
hi,
I am facing this message..
ORA-00018 maximum number of sessions exceeded
Cause: All session state objects are in use.
Shall I Increase processes = more than existing numbers??
Thanks..
REgards,
ROshan
|
|
|
|
| Re: ORA-00018 [message #117956 is a reply to message #117953] |
Mon, 02 May 2005 02:41  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi ,
Error: ORA-00018: maximum number of sessions exceeded
Cause: You tried to execute a statement that requested a resource. Since the maximum number of sessions have been reached, Oracle will not process any new resource requests.
Action: The options to resolve this Oracle error are:
You can wait a few minutes and try to re-execute the statement(s).
You can shut down Oracle, increase the SESSIONS parameter in the initialization parameter file, and restart Oracle
From :- Sunil
|
|
|
|
| Re: ORA-00018 [message #117963 is a reply to message #117956] |
Mon, 02 May 2005 03:29 |
JoinNepal
Messages: 33
Registered: October 2003
|
Member |
|
|
Hi,
Thanks but I am asking how to increase the SESSIONS parameter in the initialization parameter file? I have Oracle 8i Database...
Thanks,,,
Regards,
Roshan
|
|
|
|
| Re: ORA-00018 [message #117985 is a reply to message #117963] |
Mon, 02 May 2005 07:43 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
###########################################
# Processes and Sessions
###########################################
processes=150
you can change that value of parameter processes and save it in your init.ora file i hope it should work
And if it dont work please let me know .
from :- sunil
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
