欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

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

程序员文章站 2024-03-23 16:55:22
...
今天意外重启服务器,导致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.