监听配置文件路径:$ORACLE_HOME/NETWORK/ADMIN/listener.ora
静态监听:如果知道数据库的信息,可以先在监听文件里面配置好要监听的数据库的实例名,并配置server名称,这种就是静态监听,因为这个监听服务器是由监听程序发起的,所以状态一直是UNKNOWN,且数据库关闭后这个监听还会存在;
===配置静态listener.ora文件
[oracle@microserver02 admin]$ vi listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.5.4.69)(PORT = 1527))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME =XIAMEN01)
(ORACLE_HOME =/u01/app/oracle/product/12.2.0/dbhome_1)
(SID_NAME =testdb)
)
(SID_DESC =
(GLOBAL_DBNAME =XIAMEN)
(ORACLE_HOME =/u01/app/oracle/product/12.2.0/dbhome_1)
(SID_N