Oracle Automatic Disconnect database connection solution ___ Database

 

Recently, customers have proposed the use of Plsql developer tools in the application of the system, the database is frequently automatically disconnected, is not used in the case (at intervals) of the anomaly, but also a strange image, that is, the same network segment has not seen such a phenomenon, because the developer mentioned, On the Internet to find the appropriate information, there are three ways to solve.

Method One, directly modify the resource configuration file

The first step is to query the resource file to find the profile name where Connect_time is located.

Select Resource_name,profile from Dba_profiles;

The second step is to modify the value in profile with alter command;

Alter profile monitoring_profile limit Connect_time unlimited; (or with a time value, such as 1000, in minutes)

Alter profile monitoring_profile limit Idle_time unlimited;

The third step, use the following command to view the value in profile;

Select Resource_name,limit from Dba_profiles where profile= ' monitoring_profile ';

Method Two: Complete by creating a resource configuration file and making user assignments.

Three steps are completed in a sqlplus environment. [This method has no effect on other databases connecting users]

The first step is to view and modify the status of the Resource_limit.

Sql>show parameter resource_limit; If False, it is modified to true, otherwise the configuration does not take effect:

Sql>alter system set Resource_file=true;

The second step is to create a new profile file with the Create Profiles command:

Sql>create profile [profile filename] limit connect_time unlimited Idle_time unlimited;

[Example: Create profile Test_profile limit Connect_time unlimited Idle_time Unlimited;]

The third step is to assign this new profile to the user:

Sql>alter user [user_name, such as root_qy] profile [profile filename];

[Example: Alter user ROOT_QY profile Test_profile;]

There is also a way to set parameters in the listening file Listener.ora file connect_timeout_listener=0

There is also a possible network instability caused by

At present, only the first approach to look at the following two days of reflection, if there are corresponding problems, and then continue to follow up ....