Message-Id: <26007.339423@fatcity.com> From: Jack van Zanen Date: Thu, 24 Jul 2003 15:11:11 +0200 Subject: RE: Extproc setup Q? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C351E5.0DBA9C40 Content-Type: text/plain Tried that still the same error message. Any other hints & tips for me to try? Just curious though ,why is it DLLS if I'm working on LINUX Jack -----Original Message----- From: Munish Bajaj [mailto:mbajaj@quark.co.in] Sent: Thursday, July 24, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: 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:JACK@QUANTSYSTEMS.NL] 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?? **************************************************************************** ************************ [oracle@Linux 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)) ) ) [oracle@Linux 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 ------_=_NextPart_001_01C351E5.0DBA9C40 Content-Type: text/html Message

Tried that still the same error message.

Any other hints & tips for me to try? 
 
Just curious though ,why is it DLLS if I'm working on LINUX
 
 
Jack
-----Original Message-----   
From: Munish Bajaj [mailto:mbajaj@quark.co.in]
Sent: Thursday, July 24, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: 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:JACK@QUANTSYSTEMS.NL]
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??

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

[oracle@Linux 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))
    )
    )


[oracle@Linux 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)
    )
  )
****************************************************************************************************