本帖最后由 新手386710 于 2022-9-13 17:55 编辑
一、需求场景 在调试bcakup备份一体机的数据库备份时,oracle在做备份、恢复、包括rman或者第三方备份恢复,都需要开启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说明开启成功 |