ORACLE 11 ORA-00119 ORA-00132启动异常抛错处理

ORACLE 11 ORA-00119 ORA-00132启动异常抛错处理
 
今天意外重启服务器，导致oracle异常出现。 
  www.zzzyk.com  
SQL> startup 
ORA-00119: invalid specification for system parameter LOCAL_LISTENER 
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL' 
在另一个终端进入   www.zzzyk.com  
[root@huang14 ~]# su - oracle 
[oracle@huang14 ~]$ cd /u01/oracle/product/10.2.0/db_1/dbs/ 
[oracle@huang14 dbs]$ strings spfileorcl.ora >initorcl.ora 
 
[oracle@huang14 dbs]$ grep local_liste initorcl.ora 
*.local_listener='(ADDRESS_LIST=(Address=(Protocol=TCP)(Host=172.0.0.1)(Port=1521)))' 
 
[oracle@huang14 dbs]$ vi initorcl.ora  
找到*.local_listener，替换成*.local_listener='(ADDRESS_LIST=(Address=(Protocol=TCP)(Host=172.0.0.1)(Port=1521)))' 
 
SQL> startup nomount pfile='/u01/oracle/product/10.2.0/db_1/dbs/initorcl.ora' 
ORACLE instance started. 
Total System Global Area 2147483648 bytes 
Fixed Size                  1220432 bytes 
Variable Size             218103984 bytes 
Database Buffers         1912602624 bytes 
Redo Buffers               15556608 bytes 
SQL> create spfile from pfile; 
File created. 
 
SQL> startup 
ORACLE instance started. 
 
Total System Global Area 2147483648 bytes 
Fixed Size                  1220432 bytes 
Variable Size             218103984 bytes 
Database Buffers         1912602624 bytes 
Redo Buffers               15556608 bytes 
Database mounted. 
Database opened. 
 

上一个：Oracle SQL分析工具
下一个：ORA-27125终极解决方法