ORA-00603: ORACLE server session terminated by fatal error
-
Hello All , I am trying to connect my server with oracle database. but getting the following error-- Can anyone suggest me what to do ---- ===================================================== sqlplus / as sysdba SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 13 20:23:32 2011 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Connected to an idle instance. SQL> set head off SQL> grant dba to msdp; grant dba to msdp * ERROR at line 1: ORA-01034: ORACLE not available SQL> startup ORACLE instance started. Total System Global Area 566231040 bytes Fixed Size 1291772 bytes Variable Size 243272196 bytes Database Buffers 314572800 bytes Redo Buffers 7094272 bytes Database mounted. ORA-00603: ORACLE server session terminated by fatal error SQL> Thanks
Ish Kumar Kapila
-
Hello All , I am trying to connect my server with oracle database. but getting the following error-- Can anyone suggest me what to do ---- ===================================================== sqlplus / as sysdba SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 13 20:23:32 2011 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Connected to an idle instance. SQL> set head off SQL> grant dba to msdp; grant dba to msdp * ERROR at line 1: ORA-01034: ORACLE not available SQL> startup ORACLE instance started. Total System Global Area 566231040 bytes Fixed Size 1291772 bytes Variable Size 243272196 bytes Database Buffers 314572800 bytes Redo Buffers 7094272 bytes Database mounted. ORA-00603: ORACLE server session terminated by fatal error SQL> Thanks
Ish Kumar Kapila
-
Check what error messages you have in the alert.log after the startup command (easiest to start to read the log from the end).
The need to optimize rises from a bad design.My articles[^]
Hi , I am unabel to find the alert.log in oracle installation folder. Can u help me where to relocate it. Thanks
Ish Kumar Kapila
-
Hi , I am unabel to find the alert.log in oracle installation folder. Can u help me where to relocate it. Thanks
Ish Kumar Kapila
-
it should be in a directory like
/admin//bdump
You can also search for a file named
alert*.logThe need to optimize rises from a bad design.My articles[^]
Hello Buddy ....!!! Sorry , dear unable to find the file. any other way around ... :( Thanks
Ish Kumar Kapila
-
Hello Buddy ....!!! Sorry , dear unable to find the file. any other way around ... :( Thanks
Ish Kumar Kapila
I hope this is a stupid question. But you are looking on the server, right?
-
Hello Buddy ....!!! Sorry , dear unable to find the file. any other way around ... :( Thanks
Ish Kumar Kapila
Without finding the alert.log, it's quite hard to find out the cause for the error. If the server is windows, open a command prompt on the server where the Oracle is installed, go to each of your drives root (for example c:\, d:\, e:\) and try find the file with dir:
dir /s alert*.log
The need to optimize rises from a bad design.My articles[^]
-
I hope this is a stupid question. But you are looking on the server, right?
Well Buddy , I am new to oracle and did what ever was possible ... but no luck :( Thanks 4 the help :)
Ish Kumar Kapila
-
Without finding the alert.log, it's quite hard to find out the cause for the error. If the server is windows, open a command prompt on the server where the Oracle is installed, go to each of your drives root (for example c:\, d:\, e:\) and try find the file with dir:
dir /s alert*.log
The need to optimize rises from a bad design.My articles[^]
Sorry ......... :(
Ish Kumar Kapila
-
Sorry ......... :(
Ish Kumar Kapila
Then I'm afraid there's not much to work with. The error you got can be caused because of several different reasons. I'm sorry to say, but without getting the details, it's just wild goose chase.
The need to optimize rises from a bad design.My articles[^]
-
Hi , I am unabel to find the alert.log in oracle installation folder. Can u help me where to relocate it. Thanks
Ish Kumar Kapila
Sorry for the rant, but even WinXP has a 'search' function in it's Explorer, so you should easily able to locate the file - if it exists ... {Addition] www.giyf.com the 4th result (from ora-00603) leads to a response like: ???\oracle\admin\aso\udump\aso_ora_1360.trc HTH
modified on Wednesday, April 13, 2011 6:10 PM