SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.10.115)(PORT=1521))' sid='devdb1';
System altered.
SQL> conn sys/oracle@devdb2 as sysdba
Connected.
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.10.116)(PORT=1521))' sid='devdb2';
System altered.
[@more@]也可以在建库之后,备份PFILE之后,在pfile中修改
例如
pfile.bak
prk2.local_listener='LISTENER_PRK2'
prk1.local_listener='LISTENER_PRK1'
tnsnames.ora
LISTENER_PRK2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.60.5.88)(PORT = 1521))
LISTENER_PRK1 =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.60.5.89)(PORT = 1521))
客户端配置
CRM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.10.5)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.10.6)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = devdb)
(instance_name=devdb1)
(instance_name=devdb2) (FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/271063/viewspace-1029703/ ，如需转载，请注明出处，否则将追究法律责任。
