sqlplus sys/123@crmdb1 as sysdba alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.188.105.77)(PORT = 1521))' scope=both sid='crmdb1';
sqlplus sys/123@crmdb2 as sysdba alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = 10.188.105.78)(PORT = 1521))' scope=both sid='crmdb2';
sqlplus sys/123@crmdb as sysdba alter system set local_listener='LISTENERS_CRMDB' scope=spfile sid='crmdb1'; alter system set local_listener='LISTENERS_CRMDB' scope=spfile sid='crmdb2'; create pfile from spfile; 然后重启数据库,并执行show parameter listener进行检查local_listener是否成功更改。