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/