https://docs.oracle.com/cd/F19136_01/rilin/local-listener-for-an-oracle-rac-database.html
https://docs.oracle.com/cd/F19136_01/netrf/oracle-net-listener-parameters-in-listener-ora.html#GUID-652C8E04-0A5E-4C9F-B50F-21F5CF5C2CDD
※gridで実施
netca
※oracleで実施
alter system set local_listener='(DESCRIPTION=
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=mmdb131-vip)(PORT=1522))
(ADDRESS=(PROTOCOL=TCP)(HOST=mmdb132-vip)(PORT=1522))))' sid='CRM1';
alter system set local_listener='(DESCRIPTION=
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=mmdb131-vip)(PORT=1522))
(ADDRESS=(PROTOCOL=TCP)(HOST=mmdb132-vip)(PORT=1522))))' sid='CRM2';
echo 'select instance_name from v$instance;' | sqlplus system/oracle@mmdb131-vip:1522/CRM
echo 'select instance_name from v$instance;' | sqlplus system/oracle@mmdb132-vip:1522/CRM