棘手的ora-03113

metalink上的不错的总结

Introduction

An ORA-3113 "end of file on communication channel" error is a general error usually reported by a client process connected to an Oracle database. The error basically means 'I cannot communicate with the Oracle shadow process'. As it is such a general error more information must be collected to help determine what has happened - this error by itself does not indicate the cause of the problem. For example, ORA-3113 could be signalled for any of these scenarios:

• Server machine crashed
• Your server process was killed at O/S level
• Network problems
• Oracle internal errors / aborts on the server
• Client incorrectly handling multiple connections
• etc.. etc.. etc.. - a lot of possible causes !!

This short article describes what information to collect for an ORA-3113 error. It is common for this error to be accompanied by other errors such as:

• ORA-1041 internal error. hostdef extension doesn't exist
• ORA-3114 not connected to ORACLE
• ORA-1012 not logged on

These are all symptomatic of being disconnected from Oracle.

Please collect as much information as possible from the items listed below and submit this information to Oracle support. Where a step produces an output file / trace file this may be needed by Oracle Support to help determine the cause of the error. The more information you can present in one go the better your chance of a speedy solution. Note that some sections may not be applicable.

If viewing this article on a Web Browser you can follow the links, otherwise manually go to the relevant section.

You may find it useful to scan the checklist in Section E at the end of this article. This covers some questions / issues relevant to all problem sections.

(A) ORA-3113 when attempting to STARTUP Oracle

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/936/viewspace-60523/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/936/viewspace-60523/