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
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博客 ” ，链接：https://blog.itpub.net/28793776/viewspace-1469772/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
