| Oracle Not available [message #176544] |
Thu, 08 June 2006 13:46  |
faiz_hyd
Messages: 294
Registered: February 2006
|
Senior Member |
|
|
Hi
My Development DB went down suddenly , 15 minutes before it was fine now it is giving this message
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
I am not able to restart also using System user same message,
Where can i look into it.
Thanks
[Updated on: Thu, 08 June 2006 13:49] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Oracle Not available [message #176559 is a reply to message #176550] |
Thu, 08 June 2006 14:38  |
faiz_hyd
Messages: 294
Registered: February 2006
|
Senior Member |
|
|
Thanks all,
Mahesh i was able to see the log file but there is no information about the downtime it had , any how i just restarted using the SYS account but still there is no information on why it failed,
here is the last part of alert log file as for today's date i was seeing'
Thu Jun 8 13:51:36 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Jun 8 13:51:36 2006
SMON: enabling tx recovery
Thu Jun 8 13:51:37 2006
Database Characterset is AL32UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
i have 3 trace files also generated for todays date let's see that also but not able to fine why it was down.
Thanks for help.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
