ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00443 background process "S%" did not start

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

原创 Linux操作系统 作者:YallonKing 时间:2012-04-30 16:23:19 0 删除 编辑
--数据库正常启动时报错 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-08-07

  • 博文量
    72
  • 访问量
    248879