Ask for help,
The system server is installed on the telecom cloud server server version server08 R2 version ORACLE 11 g the client to the cloud server network is normal, router, firewall also all off, telecommunications hardware firewalls add the client's address to the routing from inside the filter,
Question:
After installed the ORACLE database on the server, the client computers using the application, every 10 minutes don't operate a computer, the application is automatically disconnected ORACLE prompt ORA - 03113 error, is very trouble,
Hope everybody to help

CodePudding user response:

May be oracle setup into consideration (if you firewall of what won't give you disconnect)

Complete three steps in up sqlplus environment,
As a first step, the query resource file, located a CONNECT_TIME profile name,
The select resource_name, profile from dba_profiles;
The second step, using the alter command to change the values in the profile;
The alter profile MONITORING_PROFILE limit connect_time unlimited; (or with a time value, such as 1000, the unit is minutes)
The alter profile MONITORING_PROFILE limit idle_time unlimited;
The third step, use the following command to view the values in the profile.
The select resource_name, limit the from dba_profiles where profile='MONITORING_PROFILE';

CodePudding user response:

The building Lord solved? I also met

CodePudding user response:

C/S structure of the deployment?
Look at the alert log and log monitoring, there should be more useful information,

CodePudding user response:

reference 1st floor js14982 response:

may be oracle setup into consideration (if you firewall of what won't give you disconnect)

Complete three steps in up sqlplus environment,
As a first step, the query resource file, located a CONNECT_TIME profile name,
The select resource_name, profile from dba_profiles;
The second step, using the alter command to change the values in the profile;
The alter profile MONITORING_PROFILE limit connect_time unlimited; (or with a time value, such as 1000, the unit is minutes)
The alter profile MONITORING_PROFILE limit idle_time unlimited;
The third step, use the following command to view the values in the profile.
The select resource_name, limit the from dba_profiles where profile='MONITORING_PROFILE';

CodePudding user response:

The

reference 3 floor jdsnhan response:

C/S structure of the deployment?
Look at the alert log and log monitoring, there should be more useful information,

Yes is cs architecture but log shows that most of the TNS 12 * * such as no ora_03113 client error

CodePudding user response:

reference 5 floor u013893508 reply:

Quote: refer to the third floor jdsnhan response:

C/S structure of the deployment?
Look at the alert log and log monitoring, there should be more useful information,

Yes is cs architecture but log shows that most of the TNS 12 * * such as no client error ora_03113

What is the specific error,

And, in addition to the 1st floor, check outbound_connect_time is how to set up

CodePudding user response:

Is the client access server networks outside every minutes to report errors ora_03113 end file... Do not have this problem Intranet access
Net is 100 m domestic telecom network, server network and telecommunications

CodePudding user response:

refer to 6th floor jdsnhan response:

Quote: refer to the fifth floor u013893508 reply:

Quote: refer to the third floor jdsnhan response:

C/S structure of the deployment?
Look at the alert log and log monitoring, there should be more useful information,

Yes is cs architecture but log shows that most of the TNS 12 * * such as no client error ora_03113

What is the specific error,

Also, in addition to the 1st floor, check outbound_connect_time is how to set up

Is the client access server networks outside every minutes to report errors ora_03113 end file... Do not have this problem Intranet access
Net is 100 m domestic telecom network, server network and telecommunications

CodePudding user response:

The building Lord solved? I also met this problem, ask for help