关于修改scan ip后,报错ORA-12514的处理
解决方式:通过修改 remote_listener参数,解决该问题
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL> show parameter remote;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_dependencies_mode string TIMESTAMP
remote_listener string rac-scan:1521
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
result_cache_remote_expiration integer 0
SQL> alter system set remote_listener='';
System altered.
SQL> alter system register;
System altered.
SQL> alter system set remote_listener='rac-scan:1521';
System altered.
通过验证,新的scan ip能够连到数据库,修改成功!