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

最新推荐文章于 2024-06-26 23:53:45 发布

原创最新推荐文章于 2024-06-26 23:53:45 发布 · 784 阅读

CC 4.0 BY-SA版权

本文详细记录了解决Oracle 11g RAC实例在启动过程中遇到的远程监听配置错误问题的过程，包括检查对比listener.ora和tnsname.ora文件、使用spfile启动实例、最终通过替换initinds2.ora文件成功解决问题的步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在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.