环境:HP UNIX
ORACLE版本:11.2.0.3.0
早上想用这台机器做测试,发现起不来,STARTUP OPEN没有反应,查看ALERT日志:
Dumping diagnostic data in directory=[cdmp_20130307185548], requested by (instance=1, osid=8433 (SMCO)), summary=[incident=4987].
Thu Mar 07 18:58:58 2013
Errors in file /oracle11/product/diag/rdbms/db11/db11/trace/db11_smco_8433.trc (incident=4988):
ORA-00445: background process "W001" did not start after 120 seconds
Incident details in: /oracle11/product/diag/rdbms/db11/db11/incident/incdir_4988/db11_smco_8433_i4988.trc
Thu Mar 07 18:59:06 2013
Dumping diagnostic data in directory=[cdmp_20130307185906], requested by (instance=1, osid=8433 (SMCO)), summary=[incident=4988].
Thu Mar 07 19:02:26 2013
Errors in file /oracle11/product/diag/rdbms/db11/db11/trace/db11_smco_8433.trc (incident=4989):
ORA-00445: background process "W001" did not start after 120 seconds
Incident details in: /oracle11/product/diag/rdbms/db11/db11/incident/incdir_4989/db11_smco_8433_i4989.trc
Thu Mar 07 19:02:32 2013
Dumping diagnostic data in directory=[cdmp_20130307190232], requested by (instance=1, osid=8433 (SMCO)), summary=[incident=4989].
Thu Mar 07 19:05:40 2013
Errors in file /oracle11/product/diag/rdbms/db11/db11/trace/db11_smco_8433.trc (incident=4990):
ORA-00445: background process "W001" did not start after 120 seconds
Thu Mar 07 19:08:57 2013
Errors in file /oracle11/product/diag/rdbms/db11/db11/trace/db11_smco_8433.trc (incident=4991):
ORA-00445: background process "W001" did not start after 120 seconds
Thu Mar 07 19:12:09 2013
Errors in file /oracle11/product/diag/rdbms/db11/db11/trace/db11_smco_8433.trc (incident=4992):
ORA-00445: background process "W001" did not start after 120 seconds
Thu Mar 07 19:15:26 2013
Errors in file /oracle11/product/diag/rdbms/db11/db11/trace/db11_smco_8433.trc (incident=6001):
ORA-00445: background process "W001" did not start after 120 seconds
Thu Mar 07 19:18:48 2013
整了一会,搞不定,就用旧的pfile:
[hp1131]:[/oracle11/product/admin/db11/pfile]$ ls -al
total 4
drwxr-x--- 2 oracle11 dba 96 Dec 31 00:38 .
drwxr-x--- 5 oracle11 dba 96 Dec 31 00:16 ..
-rw-r----- 1 oracle11 dba 1668 Dec 31 00:28 init.ora.113120120382
[hp1131]:[/oracle11/product/admin/db11/pfile]$
[hp1131]:[/oracle11/product/admin/db11/pfile]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 26 11:58:08 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup pfile='/oracle11/product/admin/db11/pfile/init.ora.113120120382';
ORACLE instance started.
Total System Global Area 1720328192 bytes
Fixed Size 2183296 bytes
Variable Size 1006636928 bytes
Database Buffers 704643072 bytes
Redo Buffers 6864896 bytes
Database mounted.
Database opened.
SQL>
SQL> conn / as sysdba
Connected.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /oracle11/product/11.2.0.3/dbs/arch
Oldest online log sequence 182
Current log sequence 184
SQL> create spfile from pfile;
File created.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1720328192 bytes
Fixed Size 2183296 bytes
Variable Size 1308626816 bytes
Database Buffers 402653184 bytes
Redo Buffers 6864896 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL>