Http://weiyingjun.blog.hexun.com/50994330_d.html
Ora-00018 Maximum number of sessions exceeded exceeds maximum sessions
Oracel the default process value of 150 causes the actual session value to exceed the set value of Oracle (the number of sessions is process*1.1+5), so an error occurs.
Workaround:
It is recommended that the value of the process be changed to a large extent.
View the process in the current system
Sql> Show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- -------
Aq_tm_processes Integer 1
Db_writer_processes Integer 1
Job_queue_processes Integer 10
Log_archive_max_processes Integer 2
Processes integer 150
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
Set the process to 500
Sql> alter system set PROCESSES=500 Scope=spfile;
The system has changed.
Restart the database for the changes to take effect.
sql> shutdown immediate;
The database has been closed.
The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has started.
See again, indeed changed over.
Sql> Show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- -------
Aq_tm_processes Integer 1
Db_writer_processes Integer 1
Job_queue_processes Integer 10
Log_archive_max_processes Integer 2
Processes integer 500
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 550
Sessions Integer 555
Shared_server_sessions Integer 550
Note: If you have any further questions, please refer to the following methods as described in the above method.
If the report: Ora-00020 Maximum Number of processes (+) Execeed the error of exceeding the maximum process, it proves that the problem is not so simple
After restarting the database
Sql> Show User
USER? S "SYS"
Sql> Select COUNT (*) from v$session;
COUNT (*)
----------
496
Sql> Select COUNT (1) from v$session where status = ' INACTIVE ';
COUNT (1)
----------
486