Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00603: ORACLE server session terminated by fatal error (oracle,10g,Linux)
ORA-00603: ORACLE server session terminated by fatal error [message #333462] Fri, 11 July 2008 13:39 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I have logged in database it shows error oracle fatl error.

Error:

ORA-00603: ORACLE server session terminated by fatal error
ORA-00604: error occurred at recursive SQL level 52
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00604: error occurred at recursive SQL level 52
ORA-00036: maximum number of recursive SQL levels (50) exceeded

And i have checked with alert log file. the log file shows
Errors in file /opt/oracle/admin/michael/udump/orchid_ora_4197.trc:
ORA-00604: error occurred at recursive SQL level 52
ORA-00036: maximum number of recursive SQL levels (50) exceeded
ORA-00604: error occurred at recursive SQL level 52
ORA-00036: maximum number of recursive SQL levels (50) exceeded

what is the error?
how we can resolve this issue?
Re: ORA-00603: ORACLE server session terminated by fatal error [message #333465 is a reply to message #333462] Fri, 11 July 2008 14:44 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer to the same question 2 days ago:
http://www.orafaq.com/forum/m/332658/102589/?srch=maximum+number+of+recursive+SQL+levels#msg_332658

Please SEARCH BEFORE POSTING.

Regards
Michel
Previous Topic: Update Table based on Separate Query
Next Topic: Alter Table for insert the Column
Goto Forum:
  


Current Time: Tue Dec 06 12:20:03 CST 2016

Total time taken to generate the page: 0.15277 seconds