startup 实例时报ORA-00119、ORA-00132

环境：
系统：ORACLE Linux 6.5
数据库：11.2.0.4  3节点RAC

今天有其他运维人员反映数据库实例启动不起来，报错如下：
[root@yxjcsjdb02 ~]# su - oracle
[oracle@yxjcsjdb02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 29 10:52:03 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00119 : invalid specification for system parameter REMOTE_LISTENER
ORA-00132 : syntax error or unresolved network name 'yxjcsjd-cluster:1522'
SQL> 

第一反应百度查看是否有类似报错信息：
http://blog.chinaunix.net/uid-24612962-id-3189342.html

处理过程：
1、由于数据库是RAC环境，spfile放在ASM中的，在节点1本地生成pfile
[oracle@yxjcsjdb01 oracle]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 29 11:05:35 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> create pfile='/oracle/soft/pfile.txt' from spfile;
--注意：在rac环境中切记不要直接create pfile from spfile;  因为RAC环境中$ORACLE_HOME/dbs目录下pfile文件只是指定了数据库spfile的位置，直接生成会覆盖原来pfile文件，下次启动实例时直接走pfile文件。

SQL> exit

2、查看新生成的pfile信息，发现节点2的明显和节点1、3不同，修改
[oracle@yxjcsjdb01 soft]$ vi pfile.txt
将以下内容
epmfdp2.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.138.17.167)(PORT=1522))))'
epmfdp3.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=yxjcsjdb03)(PORT=1522)))'
epmfdp1.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=yxjcsjdb01)(PORT=1522)))'
改为
epmfdp2.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=yxjcsjdb02)(PORT=1522)))'
epmfdp3.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=yxjcsjdb03)(PORT=1522)))'
epmfdp1.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=yxjcsjdb01)(PORT=1522)))'

3、生成新的spfile
SQL> create spfile from pfile='/oracle/soft/pfile.txt'

4、再到节点2启动实例
[oracle@yxjcsjdb02 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 29 10:52:03 2015
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
Total System Global Area 1.6195E+11 bytes
Fixed Size                  2261968 bytes
Variable Size            2.6844E+10 bytes
Database Buffers         1.3475E+11 bytes
Redo Buffers              345251840 bytes
Database mounted.
Database opened.

SQL> select inst_id,status from gv$instance;


   INST_ID STATUS
---------- ------------
         1 OPEN
         2 OPEN
         3 OPEN

实例正常。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29953799/viewspace-1420014/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29953799/viewspace-1420014/