Oracle Database is really not neat

From Installing oracle on Linux to using Oracle for just a few days, hundreds of problems are encountered. Listener refused the connection with the following error ora-12519 listener refused the connection with the following error: ORA-12519, TNS: no appropriate service handler foundthe connection descriptor used by the client was: XXX

At the beginning, I thought that the listener client was not good. After a long time, the connection was still not successful.

Later I log on to the database server, execute sqlplus to check whether the database is normal, but there is a ORA-00020: Maximum number of processes (% s) exceeded error, this was suddenly realized. A waste of time.

 

I searched the internet and found the solution.

1. Put your application firstProgramTo reduce the number of Oracle connections.

2. log on to the database as sysdba

3. Run show parameter process to check the value of processes.

4. Execute alter system set processes = <number greater than the processes value you just saw> scope = spfile

5. Shutdown immediate

6. startup

 

Try again. The above error will not occur.