dbms_job failed to execute 2005-10-27 - By Magnus Andersen
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@(protected) (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 (See ORA-01089.ora-code.com): immediate shutdown in progress - no operations are permitted
ORA-00448 (See ORA-00448.ora-code.com): normal completion of background process
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?<span class="q"><br clear="all"><br>-- <br>Magnus
Andersen<br>Systems Administrator / Oracle DBA<br>Walker & Associates, Inc.
<br>
<br>
<br></span>
Trace file information...<br>
<br>
Dump file /opt/oracle/ora92/rdbms/log
<div id="mb_2">/prd/bdump/prd_j000_9659.trc<br>
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production<br>
With the Partitioning, OLAP and Oracle Data Mining options<br>
JServer Release 9.2.0.6.0 - Production<br>
ORACLE_HOME = /opt/oracle/ora92<br>
System name: Linux<br>
Node name: <a href="http://oraprd.walkerassoc.com
/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">oraprd
.walkerassoc.com</a><br>
Release: 2.4.21-32.0.1.ELsmp<br>
Version: #1 SMP Tue May 17 17:52:23
EDT 2005<br>
Machine: i686<br>
Instance name: prd<br>
Redo thread mounted by this instance: 1<br>
Oracle process number: 28<br>
Unix process pid: 9659, image: <a href="mailto:oracle@(protected)"
target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">oracle
@(protected)</a> (J000)<br>
<br>
*** 2005-10-22 00:38:58.415<br>
*** SESSION ID:(27.52095) 2005-10-22 00:38:58.391<br>
OPIRIP: Uncaught error 1089. Error stack:<br>
ORA-01089 (See ORA-01089.ora-code.com): immediate shutdown in progress - no operations are permitted<br>
ORA-00448 (See ORA-00448.ora-code.com): normal completion of background process</div>
|
|
