Home » RDBMS Server » Networking and Gateways » Need help: ORA-03113 / Oracle Version 9.2.0.8
Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211818] Tue, 02 January 2007 08:12 Go to next message
pham
Messages: 17
Registered: August 2006
Junior Member
Hello,

after upgrating our oracle database server (windows) from 9.2 to 9.2.0.8, run the several pakages only 13 Seconds.
All the packages end with:

ORA-02068: following severe error from DWH_DB
ORA-03113: end-of-file on communication channel
ORA-02068: following severe error from DWH_DB
ORA-03113: end-of-file on communication channel
ORA-06512: at line 1

Notiz: we are using db-links, dynamic SQL in the packages.

thank a lot for your helps
cheers / regards
Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211821 is a reply to message #211818] Tue, 02 January 2007 08:18 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
More information is required.
This
>>ORA-02068: following severe error from DWH_DB
Usually means a dblink is been used to talk to a remote oracle database or an external non-oracle database using a gateway.
And this
>>ORA-03113: end-of-file on communication channel
says most probably the error has to do with a disconnection in the sql*net layer.
If there are two databases involved, check the availablity of other . Also check some dependencies are compatible (after the upgrade) or just left in an invalid state.
Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211825 is a reply to message #211821] Tue, 02 January 2007 08:27 Go to previous messageGo to next message
pham
Messages: 17
Registered: August 2006
Junior Member
I try to give more information:

this is a data ware house (schema A), from which the data readed from two other production schemas B and C.

there are links between the three schemas A. B and C.

All the schemas (users) are in the same instance and the same server. The clients and database server have the same version 9.2.0.8

Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211826 is a reply to message #211825] Tue, 02 January 2007 08:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Check what i have already asked for
and
look into your aler_<sid>.log for a trace file.
Post the relevant contents of logfile and tracefile.
Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211829 is a reply to message #211818] Tue, 02 January 2007 08:44 Go to previous messageGo to next message
pham
Messages: 17
Registered: August 2006
Junior Member
we have checked the alert.log. There is nothing => nothing changes.
we drop all the links and create new => the same

The packages write all sql-statements, what they do in a table. We can performance the sql-statements without problems.

I think: while the packages run, the connection get fail, so that the packages can't reach exceptions out

All packages - which run less then 13s - have no problems.
Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211830 is a reply to message #211818] Tue, 02 January 2007 08:49 Go to previous messageGo to next message
pham
Messages: 17
Registered: August 2006
Junior Member
we get at last a core dump.

here the file.

oracle try to use not allowed memory area.
  • Attachment: abn1CORE.LOG
    (Size: 424.06KB, Downloaded 431 times)
Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211831 is a reply to message #211829] Tue, 02 January 2007 08:51 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Raise a TAR.
There seems to be several related bugs.
Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211832 is a reply to message #211830] Tue, 02 January 2007 08:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
> we get at last a core dump.
Post the complete entry (the error message with an exception number) from alertlog.
Is this procedure using any function based indexes?
Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211834 is a reply to message #211818] Tue, 02 January 2007 09:15 Go to previous messageGo to next message
pham
Messages: 17
Registered: August 2006
Junior Member
sorry, was in a meeting.

yes, we have a funtion based index (only one).

I can take the index away and test the packages now
Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211835 is a reply to message #211818] Tue, 02 January 2007 09:23 Go to previous messageGo to next message
pham
Messages: 17
Registered: August 2006
Junior Member
only one procedure create a funtion based index. But this procedure is never called last time, so we don't have funtion based index in the database
Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211836 is a reply to message #211835] Tue, 02 January 2007 09:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Raise a TAR.
Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211837 is a reply to message #211818] Tue, 02 January 2007 09:41 Go to previous messageGo to next message
pham
Messages: 17
Registered: August 2006
Junior Member
OK!
done

thank a lot
Re: Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #213916 is a reply to message #211818] Fri, 12 January 2007 14:24 Go to previous message
business1
Messages: 5
Registered: December 2006
Junior Member
Thanks a lot that was very helpful.








[Updated on: Fri, 12 January 2007 14:26] by Moderator

Report message to a moderator

Previous Topic: PRESENTATION=RO in tnsnames
Next Topic: Question about Names Server in 10G
Goto Forum:
  


Current Time: Sat Dec 03 09:52:23 CST 2016

Total time taken to generate the page: 0.24118 seconds