Re: ORA-00447: fatal error in background process( Urgent!)

Re: ORA-00447: fatal error in background process( Urgent!)

 

  

Here is the description of this error:
00447, 00000, "fatal error in background process"
// *Cause: One of the background processes died unexpectedly.
// *Action: Warm start the system.

Did you try to restart the database?
Ruth
----- Original Message -----
From: "Ashish Saxena" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, March 29, 2002 1:33 PM
Subject: ORA-00447: fatal error in background process( Urgent!)


> Hello Gurus:
> Oracle 8.1.7.0.0
> Platform: SunOS 5.7 Generic_106541-16 sun4u sparc
> SUNW,Ultra-80
>
> One of our production databases was hung this morning.
> None of the unix commands(ls -la etc.) could work.
> svrmgrl was also hanging so I asked the sys admin to
> reboot the box. Upon starup, I lloked at the alert.log
> file. I had this following entry from the time
> database hanged.
>
> Fri Mar 29 08:40:30 2002
> WARNING: aiowait timed out 1 times
> CKPT: terminating instance due to error 1110
> Fri Mar 29 08:42:39 2002
> ARCH: Archival stopped, error occurred. Will continue
> retrying
> Fri Mar 29 08:42:39 2002
> Instance terminated by CKPT, pid = 571
>
> I looked at the trace files during this time & saw two
> of them.
> 1. rio06sj_ckpt_571.trc
> Dump file
> /rio_u02/oradata/rio06sj/bdump/rio06sj_ckpt_571.trc
> Oracle8i Enterprise Edition Release 8.1.7.0.0 -
> Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
> ORACLE_HOME = /opt/oracle/8.1.7
> System name: SunOS
> Node name: ded-rio06-sj
> Release: 5.7
> Version: Generic_106541-16
> Machine: sun4u
> Instance name: rio06sj
> Redo thread mounted by this instance: 1
> Oracle process number: 5
> Unix process pid: 571, image: [Email Address Removed] (CKPT)
>
> *** 2002-03-29 08:40:30.871
> *** SESSION ID:(4.1) 2002-03-29 08:40:30.487
> WARNING: aiowait timed out 1 times
> *** 2002-03-29 08:42:38.534
> error 1110 detected in background process
>
> And the other file is:
>
> 2. rio06sj_snp1_579.trc
> Dump file
> /rio_u02/oradata/rio06sj/bdump/rio06sj_snp1_579.trc
> Oracle8i Enterprise Edition Release 8.1.7.0.0 -
> Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
> ORACLE_HOME = /opt/oracle/8.1.7
> System name: SunOS
> Node name: ded-rio06-sj
> Release: 5.7
> Version: Generic_106541-16
> Machine: sun4u
> Instance name: rio06sj
> Redo thread mounted by this instance: 1
> Oracle process number: 9
> Unix process pid: 579, image: [Email Address Removed] (SNP1)
>
> *** 2002-03-29 08:42:39.257
> *** SESSION ID:(81.29837) 2002-03-29 08:42:38.639
> error 1110 detected in background process
> OPIRIP: Uncaught error 447. Error stack:
> ORA-00447: fatal error in background process
> ORA-01110: data file : ''
>
> Please let me know if this is an oracle bug or a unix
> CPU/MEMORY issue.
> Thanks,
>
> Ashish
>
>
> =====
> Ashish Saxena
> Oracle DBA
> Sprint E|Solutions
> Kansas City MO
> eMail: [Email Address Removed] __________________________________________________
> Do You Yahoo!?
> Yahoo! Greetings - send holiday greetings for Easter, Passover
> http://greetings.yahoo.com/
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>

Oracle LazyDBA home page