ORA-12518: Error Client Connection Failed solution: Step 1: process and session change large check process and sessiona) local use to connect to oracle, view process count: selectcount (*) fromv $ process; -obtain the current number of processes in the database. Selectvaluefromv $ parameterwherename
ORA-12518: Error client connection failure solution: Step 1: process and session change large check process and session a) local use to connect to oracle, view process count: select count (*) from v $ process;-obtains the current number of processes in the database. Select value from v $ parameter where name =
ORA-12518: Error Client Connection Failed
Solution:
Step 1: process and session increase
- Check process and session
A) the local machine is connected to oracle to view the number of process processes:
Select count (*) from v $ process;-obtains the current number of processes in the database.
Select value from v $ parameter where name = 'processs';-obtain the maximum number of processes.
B) view the number of session sessions:
Select count (*) from v $ session;-obtains the current number of sessions of the database.
Select value from v $ parameter where name = 'session';-the upper limit of the number of sessions is obtained.
Check whether the current process and sessions are close to the upper limit. If it is close, you can increase it.
Adjust the values of these two parameters.
A) modify the process value.
Alter system set processes = 800 scope = spfile;-increase the process value
B) modify the session Value
Alter system set sessions = 1200 scope = spfile;-increase the sessions value.
3. Back up pfile and restart oracle
A) Back up pfile after modification.
Create pfile from spfile;-create pfile (system configuration) from spfile (runtime configuration)
The generated file is in the same directory as the spfile under $ ORACLE_HOME/dbs /.
Windows
D: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ database
If there is a problem with the startup, you can start it like this. Generally, there will be no problems. Feel free to change it.
Startup pfile = 'd: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ database \ init. ora ';
C) Restart oracle
In Windows, you can directly restart the service in the service.