Re: dbms_job failed to execute

From: Magnus Andersen <mag.andersen_at_gmail.com>
Date: Thu, 27 Oct 2005 10:16:37 -0400
Message-ID: <5ea165840510270716v386b446eled76aecf9aab1fc5@mail.gmail.com>

I found two trace files with the same time stamp on them. These are the closest to when I saw the problem. Could this have "hung" since the database bounced?

--

Magnus Andersen
Systems Administrator / Oracle DBA
Walker & Associates, Inc.

 Trace file information...

Dump file /opt/oracle/ora92/rdbms/log /prd/bdump/prd_j000_9659.trc Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production
ORACLE_HOME = /opt/oracle/ora92
System name: Linux
Node name: oraprd.walkerassoc.com <http://oraprd.walkerassoc.com/>

Release: 2.4.21-32.0.1.ELsmp
Version: #1 SMP Tue May 17 17:52:23 EDT 2005
Machine: i686

Instance name: prd
Redo thread mounted by this instance: 1
Oracle process number: 28
Unix process pid: 9659, image: oracle_at_oraprd.walkerassoc.com (J000)

• 2005-10-22 00:38:58.415
• SESSION ID:(27.52095) 2005-10-22 00:38:58.391 OPIRIP: Uncaught error 1089. Error stack: ORA-01089: immediate shutdown in progress - no operations are permitted ORA-00448: normal completion of background process

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 27 2005 - 09:19:30 CDT