Forum Stats

  • 3,827,151 Users
  • 2,260,746 Discussions
  • 7,897,182 Comments

Discussions

Modifying a Listener file

User_KC6Y3
User_KC6Y3 Member Posts: 72 Green Ribbon

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

Best Answer

Answers