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

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 8.1.6.3.0 - Production
With the Partitioning option
JServer Release 8.1.6.3.0 - 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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support.
Also associated see trace files.

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


Current Time: Sat Nov 23 05:01:11 CST 2024