Database Networking (MOSC)

MOSC Banner

how to configure extproc in listener.ora on 11gR2 RAC ?

edited Jan 25, 2010 12:55AM in Database Networking (MOSC) 3 commentsAnswered
configure listener with netca ,and add extproc with netmgr, but raise error:
SQL> select spkg.encrypt(rawtohex('a')) from dual;

select spkg.encrypt(rawtohex('a')) from dual

ORA-28595: Extproc agent : Invalid DLL Path
ORA-06512: at "ADMIN.SPKG", line 6377

1:RAC env:
      11gR2,redhat linux 5 ,x86-64

2: listener.ora

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (PROGRAM = extproc)
      (ENV = 'EXTPROC_DLLS=ANY')
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/11.2.0/grid)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
  )

ADR_BASE_LISTENER = /opt/11.2.0/crs

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

LISTENER_SCAN1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center