This section describes how to solve the problem that the connection to the database fails.
Problem description
A database connection failure alarm is generated on the LMT and the login to the BMU fails.
Problem analysis
1. The BMU logs contain many SESSIONS_RER_USER limit errors.
2. Log in to the Oracle database and run the following statement. It is found that the DEFAULT is used:
SELECT * FROM DBA_PROFILES P1 WHERE P1.PROFILE = 'ORA11GSECPROFILE'AND P1.RESOURCE_NAME = 'SESSIONS_PER_USER';
3. Check the value of SESSIONS_PER_USER DEFAULT:
select resource_name, limit from dba_profiles where profile='DEFAULT';
4. Check the number of current connections, the number of connections has reached the upper limit.
SELECT count(*) as connections, username FROM v$session GROUP BY username ORDER BY username;
Solution
1. Log in to the database as the oracle user and run the sqlplus / as sysdba command.
2. Query the total number of connections.
show parameter process;
3. Change the upper limit of SESSIONS_PER_USER to the required value.
ALTER PROFILE DEFAULT LIMIT SESSIONS_PER_USER 4000;
4. Check whether the value of DEFAULT upper limit is the new value.
select resource_name,limit from dba_profiles where profile='DEFAULT';
