| ORA00018:MAXIMUM NUMBER OF SESSION EXCEEDED,ORACLE 9i [message #64010] |
Sun, 05 December 2004 19:25  |
MEENA ELIZABETH
Messages: 3
Registered: November 2004
|
Junior Member |
|
|
Our sid name is bsnl1.The number of processes in the initbsnl1.ora file is 250.But the command "SHOW PARAMETER SESSIONS;" is giving only 170 sessions and "SHOW PARAMETER PROCESSES;" is giving only 150 procsesses.We added a line SESSIONS=300 in the initbsnl1.ora file and did a normal
restart of the server.But the number of sessions and processes remain the same and the same error 'ORA-00018:MAXIMIUM NUMBER OF SESSIONS EXCEEDED' is repeating.
SQL> SHOW PARAMETER SESSIONS;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
mts_sessions integer 165
sessions integer 170
shared_server_sessions integer 165
SQL> SHOW PARAMETER PROCESSES;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
job_queue_processes integer 0
log_archive_max_processes integer 1
processes integer 150
|
|
|
|
| Re: ORA00018:MAXIMUM NUMBER OF SESSION EXCEEDED,ORACLE 9i [message #64012 is a reply to message #64010] |
Mon, 06 December 2004 02:00  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
In Ora9i onwards oracle use spfile for the init parameters. So after changing the parameter in initsid.ora create a new spfile from it using :
create spfile '/home/oracle/spfile.ora' from pfile='oracle_base/admin/sid/pfile/initsid.ora';
And replace the old spfile with newly created one. It will solve your problem.
Daljit Singh.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
