| ORA-00018:maximum number of sessions exceeded,ORACLE 9i [message #63970] |
Tue, 30 November 2004 21:32  |
MEENA ELIZABETH
Messages: 3
Registered: November 2004
|
Junior Member |
|
|
select * from v$license;
SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MAX
------------ ---------------- ---------------- ------------------ ----------
0 0 151 163 0
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 processe;
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
SQL> show parameter license;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
license_max_sessions integer 0
license_max_users integer 0
license_sessions_warning integer 0
SQL>
We are running Oracle 9i:Version 9.0.1
Our users are frequently getting the message 'ORA-00018:MAXIMIUM NUMBER
OF SESSIONS EXCEEDED'.Can this problem be solved by increasing the number of sessions?The number
of sessions that currently we have is 170.What is the command that is to be used to increase
the number of sessions?
|
|
|
|
|
|
| Re: ORA-00018:maximum number of sessions exceeded,ORACLE 9i [message #63979 is a reply to message #63971] |
Wed, 01 December 2004 19:39  |
MEENA ELIZABETH
Messages: 3
Registered: November 2004
|
Junior Member |
|
|
We inserted the parameter 'sessions' in the
init< sid >.ora file and restarted the server.But the 'show parameter sessions'command still gives the same values as before.No change has been affected.
Any modification required for the parameter sqlnet.expire_time in sqlnet.ora?Now the value of this parameter is 10.How can we create the spfile from the pfile?Is it by copying or is there any command for that?
|
|
|
|
| Re: ORA-00018:maximum number of sessions exceeded,ORACLE 9i [message #63983 is a reply to message #63979] |
Wed, 01 December 2004 22:40 |
Milind Deshpande
Messages: 93
Registered: May 2004
|
Member |
|
|
Hi Meena,
I believe your database is using spfile and your changes are not reflected in it.
if you have made the required changes suggested by Mahesh the command for creating SPFILE from PFILE is:-
Connect system/manager as sysdba;
CREATE SPFILE='yourpath.ora'
FROM
PFILE=path of pfile .ora';
After an spfile is created, when you bounce the database you may encounter an error. To get around this, you have to reconnect as SYSDBA and use the STARTUP command.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
