[20151111]Startup失败ORA-00444 ORA-07446

[20151111]Database Startup fails with ORA-00444, ORA-07446.txt

--前几天同事在建立dg时少建立了user_dump_dest对应的目录,在startup时出现如下:

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

--自己也在测试环境模拟看看.

$ cd /u01/app/oracle/admin/test
$ mv bdump/ bdump.xxx

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

--从提示看很难发现问题在那里,检查alert*.log文件[^_^,没有这个目录bdump,自然建立不了]

$ ps -ef | grep sqlplus| grep sysdb[a]
oracle   16400 16291  0 09:12 pts/5    00:00:00 /usr/bin/rlwrap -p1;31 -s 9999 -c -r -i sqlplus / as sysdba
oracle   16401 16400  0 09:12 pts/8    00:00:00 sqlplus   as sysdba

$ strace -f -e open -p 16401
...
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
[pid 16522] open("/u01/app/oracle/admin/test/bdump/alert_test.log", O_WRONLY|O_CREAT|O_APPEND, 0660) = -1 ENOENT (No such file or directory)
...

--从这里可以确定目录没权限或者没有建立. 修改正确后ok.