小编给大家分享一下Oracle 11gr2如何修改RAC集群的scan ip并处理ORA-12514问题,希望大家阅读完这篇文章之后都有所收获,下面让我们一起去探讨吧!注:-n后面跟的是/etc/hosts下scan的名称提示ORA-12514TNS:listener does not currently know of service requested in connect descriptor使用关键字“scan ip ORA-12514”在MOS上查找解决方案Top Issues That Cause Troubles with SCAN VIP and Listeners (文档 ID 1373350.1)After SCAN VIP and SCAN listener failover, instance does not register with the SCAN listener. It might happen for only 1 of the scan listener. Client connection gets intermittent ORA-12514 TNS:listener does not currently know of service requested in connect descriptor.1) For both above bugs, the workaround is to unregister and register remote listener on the database instance which does not register to a SCAN listener with following steps.
show parameter remote_listener
alter system set remote_listener=”;
alter system register;
alter system set remote_listener=’
alter system register;
2) Other p免费主机域名oints to check if service is not registered with SCAN listener:
a. remote_listener and local免费主机域名_listener is defined correctly
b. EZCONNECT is defined in sqlnet.ora, eg: NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
c. SCAN name with 3 IPs should NOT be defined in /etc/hosts, it should be defined in DNS
d. running nslookup
e. do not set SECURE_REGISTER_
相关推荐: MySQLæææ¶æ¥é ERROR 1819æä¹å
MySQL ERROR 1819 免费主机域名 mysql> grant select, insert,update on免费主机域名 cus_ent5ddf7b0e.* to fin_user@’192.168.2.78′; ERROR 1819 (H…