[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.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-1828146/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/267265/viewspace-1828146/