RAC数据库实例启动报“ORA-00119”和“ORA-00132”错误

1.启动RAC各个节点报错：
SQL> startup：
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name scan-cluster.odb.com:1521'
2.分析原因：
通过在oracle用户下netca添加service时，导致RAC重启服务之后报错
$ORACLE_HOME/network/admin/tnsnames.ora:
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = scan-cluster.odb.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )
3.解决方法：
1)修改$ORACLE_HOME/network/admin/sqlnet.ora

# sqlnet.ora.odb01 Network Configuration File: /u01/app/oracle/product/11.2.0/db_2/network/admin/sqlnet.ora.odb01
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, EZCONNECT)
ADR_BASE = /u01/app/oracle
2)重启数据库

SQL> startup;      
ORACLE instance started.

Total System Global Area 1.0796E+11 bytes
Fixed Size      2266024 bytes
Variable Size   5.7445E+10 bytes
Database Buffers  5.0197E+10 bytes
Redo Buffers    318885888 bytes
Database mounted.
Database opened.
问题解决

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

转载于:http://blog.itpub.net/28793776/viewspace-1469772/