PL/SQL (MOSC)

MOSC Banner

ORA-06520: PL/SQL: Error loading external library

edited Feb 15, 2012 7:33PM in PL/SQL (MOSC) 4 commentsAnswered
hello,version oracle: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production  on windows 2003server

My library is not loading, this is my configuration  of  listener.ora and tnsnames.ora files:



LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = extproc))
    )
  )


SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = extproc)
      (ORACLE_HOME = c:\app\Administrator\product\11.1.0\db_1)
      (ENVS="EXTPROC_DLLS=ANY") 
      (PROGRAM =extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME =DB)
      (ORACLE_HOME =c:\app\Administrator\product\11.1.0\db_1)
      (SID_NAME = DB)
    )
)
**********************************************************

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = extproc)(HOST = x.x.x.x)(PORT = 1521))

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