RAC 11G 虚拟机单节点启动无法启动的问题（ORA-00119、ORA-00132）

          在virtual box 安装11g RAC ， 在通过crsctl status resource  -t  检查时，节点2db的target状态为offline。

在节点2  登陆，启动实例如下

         [oracle@inds-02 dbs]$ sqlplus / as sysdba
         SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 12 11:09:45 2013
         Copyright (c) 1982, 2009, Oracle.  All rights reserved.
         Connected to an idle instance.

SQL> startup force;
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_RAC'

通过检查对比节点1和节点2的 listener.ora和 tnsname.ora文件，两个文件一直。

 grid的监听检查如下

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 12-MAR-2013 08:57:19
Uptime 0 days 2 hr. 18 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/grid/crs/network/admin/listener.ora
Listener Log File /oracle/grid/obase/diag/tnslsnr/inds-02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.202)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
The command completed successfully。

通过spfile检查启动实例，是成功的。

SQL> startup pfile='/oracle/database/admin/inds/pfile/init.ora.292013152738';
ORACLE instance started.

Total System Global Area 784998400 bytes
Fixed Size 2217464 bytes
Variable Size 528484872 bytes
Database Buffers 251658240 bytes
Redo Buffers 2637824 bytes
Database mounted.
Database opened.

最后解决的方法是：删除/oracle/database/product/11.2.0/db_1/dbs下的initinds2.ora文件， 把/oracle/database/admin/inds/pfile/init.ora.292013152738复制替换initinds2.ora。

[oracle@inds-02 dbs]$ cp /oracle/database/admin/inds/pfile/init.ora.292013152738  /oracle/database/product/11.2.0/db_1/dbs/initinds2.ora

DB实例启动成功，

[oracle@inds-02 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 12 11:09:45 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup force;
ORACLE instance started.

Total System Global Area 784998400 bytes
Fixed Size 2217464 bytes
Variable Size 528484872 bytes
Database Buffers 251658240 bytes
Redo Buffers 2637824 bytes
Database mounted.
Database opened.