Indirect interruption of ORA-12519 database connection
Current number of connections
Select count (*) from v $ process;
Set the maximum number of connections (default value: 150)
Select value from v $ parameter where name = 'processs ';
Modify the maximum number of connections
Alter system set processses = 300 scope = spfile;
When the maximum number of connections to the database is not enough, the client connection will fail intermittently, And the ORA-12519 is reported.
How to modify the maximum number of connections in Oracle
1. Go to "SQL * Plus Worksheet ",
2. Click "Change Database Connection ..." Button,
3. Enter the "database connection information" interface, enter the user name, password, and name of the database service for which you want to modify the maximum number of connections. Select "SYSDBA" as the connection identity, and click "OK ",
4. Enter the command "show parameter processes;" and run the command to check the current maximum number of connections,
5. Enter the command "alter system set processes = 600 scope = spfile;" and run the command. Change the maximum number of connections to 600,
6. Enter the command "create pfile from spfile;" and run the command to create a Profile,
7. Disable the "Enterprise Manager Console", restart the Oracle service, or restart the Oracle Database Server.
8. Repeat steps 1, 2, 3, and 4 to confirm that the maximum number of connections is successfully modified.
Install Oracle 11gR2 (x64) in CentOS 6.4)
Steps for installing Oracle 11gR2 in vmwarevm
Install Oracle 11g XE R2 In Debian