Re: dbms_job failed to execute

  • From: Magnus Andersen <mag.andersen@xxxxxxxxx>
  • Date: Thu, 27 Oct 2005 10:16:37 -0400

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@xxxxxxxxxxxxxxxxxxxxxx (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

Other related posts: