RE: Extproc setup Q?

[Munish Bajaj]

Title: Extproc setup Q?

Please add the line in red to your listener.ora file. Extproc has been made secure in Oracle 9i. The following line has to be added to execute your own external procedures.

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521))
    (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = plsextproc)
      (ORACLE_HOME = /oracle/app/product/9.2.0)
      (PROGRAM = extproc) 

            (ENVS="EXTPROC_DLLS=ANY")
    )
    (SID_DESC =
      (GLOBAL_DBNAME = Ora92)
      (ORACLE_HOME = /oracle/app/product/9.2.0)
      (SID_NAME = ora92)
    )
  )

Regards

Munish Bajaj

-----Original Message-----
From: Jack van Zanen [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 16:24
To: Multiple recipients of list ORACLE-L
Subject: Extproc setup Q?

Hi All,

I am trying to setup EXTPROC but keep getting ORA-28575 (Check your tnsnames.ora & listener.ora)

Attached are my files that look OK to me

Anybody??

****************************************************************************************************

[EMAIL PROTECTED] admin]$ cat tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /oracle/app/product/9.2.0/network/admin/tnsnames.ora

ORA92 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = Ora92)
    )
  )
extproc_connection_data =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent))
      (CONNECT_DATA = (SID = plsextproc))
    )
    )

[EMAIL PROTECTED] admin]$ cat listener.ora
# LISTENER.ORA Network Configuration File: /oracle/app/product/9.2.0/network/admin/listener.ora

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521))
    (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent))
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = plsextproc)
      (ORACLE_HOME = /oracle/app/product/9.2.0)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = Ora92)
      (ORACLE_HOME = /oracle/app/product/9.2.0)
      (SID_NAME = ora92)
    )
  )
****************************************************************************************************

TIA

Jack van Zanen