Hi: just getting back into Oracle, been a few years, getting rusty...
I have a services created: OracleServiceAGSOFT2021
and would like to add it to my Listener.ora file; here is the current file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\App\Oracle\21.0.0)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\App\Oracle\21.0.0\bin\oraclr.dll")
)
)
i THINK that I should add this entry:
(SID_DESC =
(SID_NAME = AGSOFT2021)
(ORACLE_HOME = C:\App\Oracle\21.0.0)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\App\Oracle\21.0.0\bin\oraclr.dll")
)
but I am unsure what values I should provide for "Program" and "ENVS"
Any assistance would be appreciated.
Thanks
Murray