| Re: Urgent: Ora-03113 end-of-file on communication channel and Ora-12560 TNS:protocol adapter error [message #51695] |
Fri, 07 June 2002 07:05 |
kwalther
Messages: 9
Registered: April 2002
|
Junior Member |
|
|
The first thing you need to do is check your alert files located in $ORACLE_HOME/rdbms/log directory (or wherever you put your alert files).
Look for any reference to an offending command, and this command may be in your init<SID>.ora file. If it is in your init<SID>.ora file, find it, and put a # in front of the command and the problem will go away.
Another very important thing is seperate the process when starting the database. First try to start it using "startup nomount". This only reads the init<SID>.ora file. If you get the ORA-03113 error here, it means you have a syntax error somewhere in the init file. The next step is "startup mount", if the error occurs here, it is because the controlfile is reporting bad information. The next step is "alter database open" and if the error is here, then it relates to the data files somewhere.
Again....VERY IMPORTANT TO CHECK THE ALERT FILES!!!! JUST DO IT!!!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
