找到oracle安装目录下network/admin/listener.ora
打开:SID_LIST_LISTENER =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\downLoad\WINDOWS.X64_193000_db_home)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\downLoad\WINDOWS.X64_193000_db_home\bin\oraclr19.dll")
)
)
将上面的SID_LIST_LISTENER中新增一条SID_DESC (注意oracle安装路径和数据库名字)
修改后:SID_LIST_LISTENER =
(SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = D:\downLoad\WINDOWS.X64_193000_db_home)