Home » RDBMS Server » Performance Tuning » db job (oracle,HP UNIX)
db job [message #298100] Tue, 05 February 2008 00:38 Go to next message
Messages: 9
Registered: January 2008
Junior Member

ive scheduled a db job and it will run every day in the morning.
after the completion of that job one trace file is generating EVERY DAY
the content of that trace file is as follows

Dump file /prepaid2/KLPREPAID/bdump/snp2_1134.trc
Oracle8i Enterprise Edition Release - Production
With the Partitioning option
JServer Release - Production
ORACLE_HOME = /oracle/ora817/8.1.6
System name: OSF1
Node name: kocprecdr
Release: V5.1
Version: 2650
Machine: alpha
Instance name: PREPAID
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 1134, image: oracle@kocprecdr (SNP2)

*** 2008-02-05 10:40:32.409
*** SESSION ID:(16.5947) 2008-02-05 10:40:32.384
error 2068 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-02068: following severe error from HICASH
ORA-03113: end-of-file on communication channel

This job will fetch some records from a remote db

i enquired with my network team,they are saying that the link is working perfectly.
what might be the cause for the above error?im getting this every day!!
Re: db job [message #298111 is a reply to message #298100] Tue, 05 February 2008 00:55 Go to previous message
Michel Cadot
Messages: 63930
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support.
Also associated see trace files.

Previous Topic: Query not running in oracle
Next Topic: oracle 10g analyze table temporary segments
Goto Forum:

Current Time: Thu Oct 27 02:44:44 CDT 2016

Total time taken to generate the page: 0.12849 seconds