ORACLE 11 ORA-00119 ORA-00132启动异常抛错处理 博客分类： linux

今天意外重启服务器，导致oracle异常出现。
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
在另一个终端进入
[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.