 | | | oracle 10g SLES 9 sudden crash | oracle 10g SLES 9 sudden crash 2005-09-07 - By Bennett Leve
Seah Hong,
Look in the ORACLE_HOME for the CRS software in the crs/log directory.
The log file there may have some clues. Also important is the rdbms
ORACLE_HOME/racg/log directory and possibly the
ORACLE_BASE/admin/$ORACLE_SID/hdump files.
Something else that may be helpful. Create a $ORACLE_HOME/log directory
in the CRS ORACLE_HOME.
Usually the cause is a system problem where racgimon takes to long to
connect to the database to check its health so it shuts it down. There
is a few bugs on this thay may be at play. One of them may be issue
3764216/.
/ -Bennett
/
/Seah Hong Yee wrote:
>Hi,
>
>For quite some times, I get this problem where an instance crash once in a
>while usually when I am running EM. The following are the trace file that I
>finally found.
>
>Can anyone tell me what is going on ?
>
>Thanks
>
>
>
>u01/app/oracle/admin/compiere/bdump/compiere_lgwr_5940.trc
>Oracle Database 10g Release 10.1.0.3.0 - 64bit Production
>ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
>System name: Linux
>Node name: miller
>Release: 2.6.5-7.191-smp
>Version: #1 SMP Tue Jun 28 14:58:56 UTC 2005
>Machine: x86_64
>Instance name: compiere
>Redo thread mounted by this instance: 1
>Oracle process number: 5
>Unix process pid: 5940, image: oracle@(protected) (LGWR)
>
>*** SERVICE NAME:() 2005-08-30 16:52:47.007
>*** SESSION ID:(167.1) 2005-08-30 16:52:47.007
>Checking if LNS processes need to be shutdown..
>oracle@(protected):~/admin/compiere/bdump> more compiere_lgwr_5940.trc
>/u01/app/oracle/admin/compiere/bdump/compiere_lgwr_5940.trc
>Oracle Database 10g Release 10.1.0.3.0 - 64bit Production
>ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
>System name: Linux
>Node name: miller
>Release: 2.6.5-7.191-smp
>Version: #1 SMP Tue Jun 28 14:58:56 UTC 2005
>Machine: x86_64
>Instance name: compiere
>Redo thread mounted by this instance: 1
>Oracle process number: 5
>Unix process pid: 5940, image: oracle@(protected) (LGWR)
>
>*** SERVICE NAME:() 2005-08-30 16:52:47.007
>*** SESSION ID:(167.1) 2005-08-30 16:52:47.007
>Checking if LNS processes need to be shutdown..
>oracle@(protected):~/admin/compiere/bdump> more compiere_j000_6069.trc
>/u01/app/oracle/admin/compiere/bdump/compiere_j000_6069.trc
>Oracle Database 10g Release 10.1.0.3.0 - 64bit Production
>ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
>System name: Linux
>Node name: miller
>Release: 2.6.5-7.191-smp
>Version: #1 SMP Tue Jun 28 14:58:56 UTC 2005
>Machine: x86_64
>Instance name: compiere
>Redo thread mounted by this instance: 1
>Oracle process number: 12
>Unix process pid: 6069, image: oracle@(protected) (J000)
>
>*** 2005-08-23 13:00:18.639
>*** ACTION NAME:() 2005-08-23 13:00:18.639
>*** MODULE NAME:() 2005-08-23 13:00:18.639
>*** SERVICE NAME:(SYS$USERS) 2005-08-23 13:00:18.638
>*** CLIENT ID:() 2005-08-23 13:00:18.638
>*** SESSION ID:(161.3484) 2005-08-23 13:00:18.638
>DEBUG: AUTONOMOUS PROCESS REDO POOL ALLOCATED
>DEBUG: AUTONOMOUS PROCESS REDO POOL FREED
>*** 2005-08-25 13:00:38.363
>*** ACTION NAME:() 2005-08-25 13:00:38.363
>*** MODULE NAME:() 2005-08-25 13:00:38.363
>*** SERVICE NAME:(SYS$USERS) 2005-08-25 13:00:38.363
>*** CLIENT ID:() 2005-08-25 13:00:38.363
>*** SESSION ID:(161.9194) 2005-08-25 13:00:38.363
>DEBUG: AUTONOMOUS PROCESS REDO POOL ALLOCATED
>DEBUG: AUTONOMOUS PROCESS REDO POOL FREED
>*** 2005-08-27 21:00:17.193
>*** ACTION NAME:() 2005-08-27 21:00:17.193
>*** MODULE NAME:() 2005-08-27 21:00:17.193
>*** SERVICE NAME:(SYS$USERS) 2005-08-27 21:00:17.193
>*** CLIENT ID:() 2005-08-27 21:00:17.193
>*** SESSION ID:(161.15862) 2005-08-27 21:00:17.193
>DEBUG: AUTONOMOUS PROCESS REDO POOL ALLOCATED
>DEBUG: AUTONOMOUS PROCESS REDO POOL FREED
>*** 2005-08-30 13:00:33.942
>*** ACTION NAME:() 2005-08-30 13:00:33.942
>*** MODULE NAME:() 2005-08-30 13:00:33.942
>*** SERVICE NAME:(SYS$USERS) 2005-08-30 13:00:33.942
>*** CLIENT ID:() 2005-08-30 13:00:33.942
>*** SESSION ID:(127.11099) 2005-08-30 13:00:33.942
>DEBUG: AUTONOMOUS PROCESS REDO POOL ALLOCATED
>*** 2005-08-30 13:00:44.959
>DEBUG: AUTONOMOUS PROCESS REDO POOL FREED
>*** 2005-08-30 16:52:39.956
>*** ACTION NAME:() 2005-08-30 16:52:39.956
>*** MODULE NAME:() 2005-08-30 16:52:39.956
>*** SERVICE NAME:(SYS$USERS) 2005-08-30 16:52:39.956
>*** CLIENT ID:() 2005-08-30 16:52:39.956
>*** SESSION ID:(127.11561) 2005-08-30 16:52:39.956
>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
>
>
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
|