Fenng (Fenng@itpub.net)
Copyright statement: Please indicate the author and the source
Foreword Each DBA is inevitable in the process of database management (ORA-XXXX). Some errors are called "classic mistakes" by DBA due to frequent reasons, and are complicated by DBA. ORA- 3113 "End of Fileon Communication Channel" is one.
We can easily understand this error as an Oracle client process and database background process connection interruption. However, there are many reasons that lead to this error, which is not properly set, any behavior that can cause database background process crashes may result. This error is often accompanied by other errors, such as: ORA-1034 Oracle NOT AVAILABLE.
In addition, the scene appears complicated, which may appear:
When the Oracle started; when trying to create a database; try to connect to the database; when the client is running SQL / PL / SQL; the backup / recovery of the database; other circumstances. . . . . .
In the forum, you can often see the assistance of this problem. Simple in this question is sorted out. Improper, please advise!
Error Reason Variety According to the situation on the network, there are about these errors:
UNIX core parameters Setting Umbs Oracle Execute File Permissions Incorrect / Environment Variable Problem Client Communication Does Correctly Processing Database Server Crash / Operating System Crash / Process by Kill Oracle Internal Error Specific SQL, PL / SQL Causes The wrong space is not enough Firewall problem Others the reason
Before starting to solve the problem, do the following things:
1. Recalling what do you do before the error occurs, the more detailed, the better the background_dump_dest directory, the alertsid.log file in the background_dump_dest directory is also what you have to do; 3, Google, there are many information on the Internet, etc. Go to find out, don't ask others. Of course, if you find something very helpful to you - this document doesn't have to read, don't delay your time, huh, huh.
Unix core parameters Setup / init parameter settings If the database does not set the correct operating system core variable during the installation process, there is no problem in the installation of the database file, and the 03113 error occurs when the database is created. Another reason for this is that the processes parameter in the init.ora parameter file specifies the unreasonable value, starting the database, resulting in errors (of course, this is also the problem of the core parameters).
This error message is usually as follows:
ORA-03113: End-of-file on communication channel ora-01034: Oracle Not Available ORA-27101: Shared Memory Realm Does Not Exist
There are two solutions: 1 Modify the core parameters to increase the value of the corresponding core parameters (recommendation); 2 reduces the value of the processes of the init.ora parameter.
It should be noted that the SEMMSL must be set to at least 10 process number. SemMns also depends on the process parameter values on each database.
-------------------------------------------------- ---------------------------- Note: This error type only appears on the UNIX platform. If the processes is too large on Windows , Will appear: ORA-00068: Invalid value 24200001 for parameter max_rollback_segments, Must Be Between 2 and 65535 / * The specified parameter value exceeded 65535 * / or ORA-27102: Out of memory / * a large Parameter value * / My software environment: Windows 2000 Version 5.0 Service Pack 3, CPU Type 586racle Rdbms Version: 8.1.7.0.0. --------------------- -------------------------------------------------- ------ Change the core parameters on a particular platform may differ, please refer to the installation document on Oracle TechNet (http://otn.oracle.com). The installation document on a specific UNIX platform also has a core Explanation of parameters.
Parameters in init.ora If the setting is not set, it will generate this error. Experience shows that Shared_Pool_SIZE sets an error, and the setting of TIMED_STATISTISTICS = TRUE will also bring problems.
Oracle Execute File Permissions Incorrect / Environment Variable Issues This problem only appears on UNIX platform. Frequently, there are time to use the system administrator to use UNIX TAR commands, or system administrators Specifies that additional OS users can also manage the database but do not specify the correct environment variable.
Oracle execution file In the $ ORACLE_HOME / BIN directory, if there is a problem, you should use the following UNIX similar command to correct:
CHMOD 7755 $ Oracle_Home / Bin / Oracle
Have time to do Relink to Oracle. When installing on UNIX, the problem of environmental variables often occurs, and individual execution program connection issues. LD_LIBRARY_PATH If the incorrect settings will cause problems, in this situation Next, you need to replace the Oracle. If the executable Oralcle is destroyed, it is also necessary to Relink.
If the parallel server option is installed, the Distributed Lock Manager is not installed or run correctly.
Client communication does not correctly handle the SQL * NET drive: If the version is relatively low, replace it to the new version of the driver. SQL * NET driver is not connected to the Oracle executable can cause errors.
Check if the network is smooth
Frequently Asked Questions of the Windows platform: When you create a database in the Windows platform, if this problem can be considered: First check the local network settings. View Have the same name on the network or conflict IP. If the problem is still You can use the following method: 1. Disable the NIC: Change the local connection status to disabled; 2. Open the SQLNET.ORA file (in a notebook form) NTS verification comment: # SQLNET.AUThentication_Services = .3. Create a database; 4. After the creation is successful, restore local connections.
The database server crash / operating system crash / process is killed in the connection process if the Oracle database server crashes or the operating system where the database is located. The cause of the crash will be killed because the main background process is dead. The error has been used. If this is the reason is more easily resolved. In addition, the time of the OS-related application exists in memory leak (or viral), will also cause the Oracle background program problem.
Recommended Quick Measures: 1. Check whether the application software related process is running normally; 2. View without memory leaks; 3, kill viruses; Other uncertain factors. . . . . . Oracle Internal Error / BUG If you look at the Alert.log in the background_dump_dest directory found that there is an ORA-600 and other errors, you can view specific information and its solutions on the MetaLink site. Generally, the software patch should be made. Specific SQL, PL / SQL Incorrect
Try SQL separately, or use SQL_Trace to track, find a SQL statement that causes problems: under SQLPLUS: ALTER session set SQL_TRACE TRUE;
The illegal characters and unreasonable processing results in the SQL statement will occasionally bring problems.
The system space is not enough to ensure that the database system has enough space. If user_dump_dest and background_dump_dest do not have the remaining space, this problem will cause this problem. In addition, if the audit is opened, the audit directory is sufficient, if the trace is activated The trace directory is sufficient for space.
Dave Wotton's documentation indicates that when the data is inserted into the table, if the file exceeds 2G (the file system has 2G restrictions), it will cause this issue.
The problem of firewall If the data is to be passed through the firewall, please contact the system administrator, ask if the database data is filtered or the traffic port is suddenly prohibited. If you have a personal firewall, please check your local settings.
Other aspects
There are many reasons why this error is there. It is only some typical situations listed above. It is often going to go to some database technology forums may be helpful. For example, ITPUB (http://www.itpub.net), cnoug (http: // Www.cnoug.org, etc.
Reference information / More reading http://metalink.Oracle.com Oracle's technical support site, you have a CSI number to log in. Reference NOTE number: NOTE: 17613.1ORA-3113 on UNIX - What Information To Collect: 131207.1 How To Collect: 131207.1 How To SET UNIX Environment Variables Note: 131321.1how to relink Oracle Database Software on UnixNote: 22080.1
http://www.google.com/grphp?hl=zh-cn Google News Group
Http://www.jlcomp.demon.co.uk/faq/ora-3113.html Technical Experts Jonathan Lewis's site on a FAQ
Http://home.clara.Net/dwotton/dba/ora3113.htmdave Wotton summarizes a very classic document.
