静的 orcl 1521
動的 PROD1 1522
動的 PROD2 1523
cdh
cd network/admin
cat samples/listener.ora
vim listener.ora
LISTENER_orcl=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=mmm111.example.com)(PORT=1521)))
SID_LIST_LISTENER_orcl=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=orcl.example.com)
(SID_NAME=orcl)
(ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1)))
LISTENER_PROD1 =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=mmm111.example.com)(PORT=1522))
)
LISTENER_PROD2 =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=mmm111.example.com)(PORT=1523))
)
lsnrctl start LISTENER_orcl
lsnrctl start LISTENER_PROD1
lsnrctl start LISTENER_PROD2
lsnrctl status LISTENER_orcl
lsnrctl status LISTENER_PROD1
lsnrctl status LISTENER_PROD2
