恢复数据库参数错误无法启动
1.问题:
当设置参数SQL>alter system set dispatchers=' ' scope=spfile;错误时
2.现象:此时数据库无法启动
SQL>shutdown immediate;
SQL>startup;
ORA-00119: invalid specification for system parameter DISPATCHERS
ORA-00111: invalid attribute X
3.解决问题:
方法一:
SQL>create pfile from spfile;
SQL>exit
$pwd
$ /u01/app/oracle/product/10.2.0/db_1/dbs
$vi initMYDB.ora
====================
参数修改正确
*.dispatchers=''
保存退出
$sqlplus / as sysdba
SQL>create spfile from pfile;
SQL>startup
Database opened.
方法二:
SQL>create pfile from spfile;
SQL>exit
$pwd
$ /u01/app/oracle/product/10.2.0/db_1/dbs
$vi initMYDB.ora
====================
参数修改正确
*.dispatchers=''
保存退出
$sqlplus / as sysdba
SQL>startup pfile='/u01/app/oracle/product/10.2.0/db_1/dbs/initMYDB.ora'
Database opened.
向 Secooler致敬!
Johnson
12-4-22
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20985606/viewspace-721975/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20985606/viewspace-721975/