OraFAQ Forum: Networking and Gateways » Need help: ORA-03113 / Oracle Version 9.2.0.8

Home » RDBMS Server » Networking and Gateways » Need help: ORA-03113 / Oracle Version 9.2.0.8

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need help: ORA-03113 / Oracle Version 9.2.0.8 [message #211818]

Tue, 02 January 2007 08:12

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

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

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

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

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.

Report message to a moderator

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

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 1577 times)

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Raise a TAR.
There seems to be several related bugs.

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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?

Report message to a moderator