一次“ORA-00444: background process "MMAN" failed while starting”处理

测试环境的机器断电，Oracle起不来。报错如下：

SQL> startup nomount
ORA-00444: background process "MMAN" failed while starting
ORA-07446: sdnfy: bad value '' for parameter .
SQL>

 

看了网上的介绍， 原址如下：

http://space.itpub.net/563971/viewspace-626462

startup
ORA-00444: background process “MMAN” failed while starting
ORA-07446: sdnfy: bad value ” for parameter .

Problem
The path to bdump,adump or udump does not exist. Oracle itself does not create any path if a path does not exist. So, you have to change the value of user_dump_dest in the initialize parameter.

Solution
If you use pfile to start your database then edit the pfile with any editor (for example vi on unix) and either change the location of user_dump_dest or remove the parameter user_dump_dest from pfile. And then perform. startup.

也有不少说是用spfile建pfile。其实不行：

SQL> create pfile='/tmp/a.ora' from spfile;
create pfile='/tmp/a.ora' from spfile
*
ERROR at line 1:
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

SQL>

 

其实原因就在那，要么，要么补上文件夹。查看以前的pfile，配置信息如下：

background_dump_dest=/xxx/app/oracle/admin/xxx/bdump
user_dump_dest=/xxx/app/oracle/admin/xxx/udump
core_dump_dest=/xxx/app/oracle/admin/xxx/cdump

 

然后查看当前目录，发现“background_dump_dest”不在。那就建。

mkdir /xxx/app/oracle/admin/xxx/bdump

 

然后启动， OK。

SQL> startup
ORACLE instance started.

Total System Global Area  838860800 bytes
Fixed Size                  1270244 bytes
Variable Size             197135900 bytes
Database Buffers          637534208 bytes
Redo Buffers                2920448 bytes
Database mounted.
Database opened.
SQL>