ORA-00443 background process "S%" did not start

--数据库正常启动时报错 ora-00443
--初步猜测是相关参数设置不当，解决过程如下：
[oracle@m1hfdata ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on 星期一 4月 30 15:50:10 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORA-00443: background process "MMAN" did not start
SQL> startup nomount
ORA-00443: background process "PMON" did not start
SQL> startup nomount
ORACLE instance started.

Total System Global Area 2443997184 bytes
Fixed Size                  1338224 bytes
Variable Size            1191183504 bytes
Database Buffers         1241513984 bytes
Redo Buffers                9961472 bytes
SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.

--上边虽然还是最后正常启动了实例，但是中途报错来看，估计是process参数设定较低造成

SQL> show parameter process

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
aq_tm_processes                      integer
0
cell_offload_processing              boolean
TRUE
db_writer_processes                  integer
12
gcs_server_processes                 integer
0
global_txn_processes                 integer

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
1
job_queue_processes                  integer
5
log_archive_max_processes            integer
4
processes                            integer
150

SQL> alter system set processes=500 scope=spfile;

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2443997184 bytes
Fixed Size                  1338224 bytes
Variable Size            1258292368 bytes
Database Buffers         1174405120 bytes
Redo Buffers                9961472 bytes
Database mounted.
Database opened.

--可见修改参数后，启动正常。
--其他错误可能有：ORA-12518: TNS: 监听程序无法分发客户机连接
--相关问题见博文： http://space.itpub.net/26143577/viewspace-719803

 

--后来继续出现此问题，需要修改参数文件中的sga、pga等大小，才可解决此问题。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26143577/viewspace-722492/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26143577/viewspace-722492/