Cause:the maximum number of active connections to remote databases per user login has been. Action:if the user has no open cursors, the current SQL statement accesses more than the maximum remote database S. Otherwise, the user may free remote database connections by closing all cursors that access the databases. If This occurs often, consider increasing the value of the initialization parameter open_links, which controls the Maximu M number of concurrent open connections to remote databases per user process.
Reason: The number of maximum active connections exceeds the Set action: If the user does not use a cursor, the running SQL command uses more database connections than is allowed, and if the user uses a cursor, the user can release the remote database connection by shutting down all cursors of the accessed database, if this problem occurs frequently, Consider adding a open_links parameter that controls the maximum number of remote database connections that each user process allows to open
Baidu gives the answer, sql> show parameter open_links;
NAME TYPE VALUE-----------------------------------------------------------------------------open_links integer 10 Open_links_per_instance Integer 4 Oracle defaults to 4:
Sql> alter system set OPEN_LINKS=10 Scope=spfile;
It would be nice to restart the database.
Problem, the user does not necessarily have permission to operate, the above method only uses the second processing way, closes the remote database connection way does not involve actually solves very simple. For an active connection, a commit or rollback disconnects the active connection sql> select * from V$dblink;
Db_link owner_id logged_on heterogeneous PROTOCOL open_cursors in_transaction update_sent commit_point_strength
-------------------------------------------------------------------------------- ---------- --------- ------------ - -------- ------------ -------------- ----------- ---------------------
Lnk_yybcv1
Use the command to close an open remote database connection, and the database connection does not need to be enclosed with a single quote sql> alter session closing database link lnk_yybcv1;
Session Altered
If the database connection requires a single quote-string in the stored procedure. Dbms_session.close_database_link (' lnk_yybcv1 ');
Complain, Baidu out of things really do not use.
