Message-Id: <26007.339404@fatcity.com> From: Jack van Zanen Date: Thu, 24 Jul 2003 11:55:10 +0200 Subject: 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_01C351C9.AB649D40 Content-Type: text/plain 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_01C351C9.AB649D40 Content-Type: text/html Content-Transfer-Encoding: quoted-printable 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 =3D
  (DESCRIPTION =3D
    = (ADDRESS_LIST =3D
      = (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D Linux)(PORT =3D 1521))
    )
    = (CONNECT_DATA =3D
      = (SERVICE_NAME =3D Ora92)
    )
  )
extproc_connection_data = =3D
  (DESCRIPTION =3D
    = (ADDRESS_LIST =3D
      = (ADDRESS =3D (PROTOCOL =3D IPC)(KEY =3D extproc_agent))
      = (CONNECT_DATA =3D (SID =3D plsextproc))
    )
    )


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


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

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

TIA