ORA-00445: background process "W001" did not start after 120 seconds

环境: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>

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值