--数据库正常启动时报错 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等大小,才可解决此问题。