| Database open issue [message #426366] |
Thu, 15 October 2009 02:40  |
skm_karthik
Messages: 4
Registered: August 2009
|
Junior Member |
|
|
Hi all,
I am not able to open the database. But database is mounting. When i give database open command it's terminate the instance also.
The error is ORA-01092: ORACLE instance terminated. Disconnection forced
I have checked the alert log files,initfile and spfile . I am not getting any solution.
Pls help me to open the database. Below the sampel alert log files.
Alert log files
----------------
SMON: enabling cache recovery
Thu Oct 15 12:43:52 2009
Successfully onlined Undo Tablespace 1.
Thu Oct 15 12:43:52 2009
SMON: enabling tx recovery
Thu Oct 15 12:43:52 2009
Database Characterset is WE8ISO8859P1
Updating 7.0.0.0.0 NLS parameters in sys.props$
-- adding 9.2.0.7.0 NLS parameters.
Thu Oct 15 12:43:52 2009
Errors in file /u01/app/oracle/admin/INORA/udump/inora_ora_1675.trc:
ORA-00600: internal error code, arguments: [13304], [], [], [], [], [], [], []
Thu Oct 15 12:43:54 2009
Errors in file /u01/app/oracle/admin/INORA/udump/inora_ora_1675.trc:
ORA-00600: internal error code, arguments: [13304], [], [], [], [], [], [], []
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 1675
ORA-1092 signalled during: alter database open...
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Database open issue [message #426398 is a reply to message #426366] |
Thu, 15 October 2009 04:49  |
cookiemonster
Messages: 13925
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
You can still (and should) use the the ORA-00600 lookup tool on Metalink as ThomasG suggested. Hopefully this will be a known issue with a known fix.
Otherwise you're probably going to have to upgrade to 10g.
|
|
|
|
|
|
|
|
| Re: Database open issue [message #427616 is a reply to message #427591] |
Fri, 23 October 2009 09:17 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
skm_karthik wrote on Fri, 23 October 2009 05:31
Hi all,
Still the problem is there. I came to know some data files have been lost. But we don't have the backup. Please suggest me.
If you have a recent copy of alert_SID.log file, you can create a replacement pfile (initSID.ora)
alert_SID.log file shows all non-default parameters & values; so just CUT & PASTE appropriate lines.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
