Home » RDBMS Server » Server Administration » Please help: ORA-03113
Please help: ORA-03113 [message #237992] Wed, 16 May 2007 05:28 Go to next message
user82
Messages: 49
Registered: June 2006
Location: Romania
Member
I'm working on Oracle 10g Enterprise Edition Release 10.2.0.1.0 on Linux OS. I'm getting the following error:


SQL>  select * from flashback_transaction_query where table_name='SOLD.INTRARI';

select * from flashback_transaction_query where table_name='SOLD.INTRARI'

ORA-03113: end-of-file on communication channel

SQL> 


the user which issues the SQL statement has DBA role. I checked alert log file but i could'n see any relevant things. Could anyone give me some hints ?

Thanks
Re: Please help: ORA-03113 [message #238020 is a reply to message #237992] Wed, 16 May 2007 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
3113 is a generic error, you have to call support.

Regards
Michel
Re: Please help: ORA-03113 [message #238026 is a reply to message #237992] Wed, 16 May 2007 06:53 Go to previous messageGo to next message
kamkan
Messages: 27
Registered: April 2007
Location: Chennai, INDIA
Junior Member
Agree with Michel. Improper oracle installation/upgradation have a chance to cause this error. Have done any upgradation recently?
Re: Please help: ORA-03113 [message #238033 is a reply to message #237992] Wed, 16 May 2007 07:03 Go to previous message
user82
Messages: 49
Registered: June 2006
Location: Romania
Member
No i didn't make any upgrade recently.....any way thanks for your advice but i think i should call support..i' ve issued the same SQL under SYS user and it returns some records but suddenly i get again ORA-03113, before ending the listing of all records....it seems to be a serious problem...
Previous Topic: Finding last DML done for a table
Next Topic: Connection error
Goto Forum:
  


Current Time: Mon Dec 02 12:37:54 CST 2024