This content has been marked as final. Show 5 replies
I am trying to start the database (oracle 10.2 on Linux4.9) and I got this error message:
[oracle@okc ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Mon Dec 10 10:20:43 2012
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 1265892 bytes
Variable Size 708841244 bytes
Database Buffers 360710144 bytes
Redo Buffers 2924544 bytes
ORA-00603: ORACLE server session terminated by fatal error
I need help please
consider looking alert_SID.log file for additional clues
[oracle@localhost ~]$ oerr ora 603 00603, 00000, "ORACLE server session terminated by fatal error" // *Cause: An ORACLE server session was in an unrecoverable state. // *Action: Login to ORACLE again so a new server session will be created
when did Oracle last start without error?
What changed since then?
Refer to MOS note :
Connect Fails With ORA-00603 Oracle Server Session Terminated [ID 338484.1]
Alert log should be the thing to have a look first, this should contain some error message about this.
Your password file might have been corrupted and you may need to create a new one as I have experience of having this problem because of bad password file. See alert log file to find out the clue.
Thanks Salman. My alert log doesn't have any message.
Please refer to MOS notes and if you need any help we are here .