当前位置:数据库 > Oracle >>

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
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,