windows下开启oracle的静态监听

一、场景

oracle在做备份、恢复、包括ramn或者第三方备份恢复，都需要开启oracle的静态监听

二、操作步骤

1、查看监听文件路径，通过lsnrctl status

 

 

 

2、关闭监听lsnrctl stop

 

 3、编辑listener文件，最好做好备份，复制一份，并且注意格式

# listener.ora Network Configuration File: C:\Users\Administrator\Desktop\WINDOWS.X64_193000_db_home\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\Users\Administrator\Desktop\WINDOWS.X64_193000_db_home)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\Users\Administrator\Desktop\WINDOWS.X64_193000_db_home\bin\oraclr19.dll")
)
(SID_DESC=
(GLOBAL_NAME = EBR19C)
(ORACLE_HOME = C:\Users\Administrator\Desktop\WINDOWS.X64_193000_db_home)
(SID_NAME = EBR19C)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBSERVER)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

 

 

 4、开启静态监听lsnrctl start，出现unknown说明开启成功