Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Extproc setup Q?

RE: Extproc setup Q?

From: Munish Bajaj <mbajaj_at_quark.co.in>
Date: Thu, 24 Jul 2003 16:49:49 +0530
Message-Id: <26007.339408@fatcity.com>


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_01C351D5.7ED8D7D0
Content-Type: text/plain;

        charset="iso-8859-1"

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_at_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_at_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_at_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_01C351D5.7ED8D7D0
Content-Type: text/html;

        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Extproc setup Q?</TITLE>

<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>

<DIV><FONT face=Arial>
<P><FONT face="Courier New" color=#0000ff size=2><SPAN class=421262511-24072003>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.</SPAN></FONT></P> <P><FONT color=#0000ff><FONT size=2><FONT face="Courier New">LISTENER =</FONT> <BR><FONT face="Courier New">&nbsp; (DESCRIPTION =</FONT> <BR><FONT face="Courier New">&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = Linux)(PORT = 1521))</FONT> <BR><FONT face="Courier New">&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = IPC)(KEY = extproc_agent))</FONT> <BR><FONT face="Courier New">&nbsp; )</FONT> </FONT></FONT></P> <P><FONT color=#0000ff><FONT size=2><FONT face="Courier New">SID_LIST_LISTENER =</FONT> <BR><FONT face="Courier New">&nbsp; (SID_LIST =</FONT> <BR><FONT face="Courier New">&nbsp;&nbsp;&nbsp; (SID_DESC =</FONT> <BR><FONT face="Courier New">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SID_NAME = plsextproc)</FONT> <BR><FONT face="Courier New">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ORACLE_HOME = /oracle/app/product/9.2.0)</FONT> <BR><FONT face="Courier New">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (PROGRAM = extproc)</FONT>&nbsp;</FONT></FONT></P>
<P><FONT color=#0000ff><FONT size=2><SPAN class=421262511-24072003>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><FONT color=#ff0000>(ENVS="EXTPROC_DLLS=ANY")<BR></FONT><FONT
face="Courier New">&nbsp;&nbsp;&nbsp; )</FONT> <BR><FONT 
face="Courier New">&nbsp;&nbsp;&nbsp; (SID_DESC =</FONT> <BR><FONT 
face="Courier New">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (GLOBAL_DBNAME = Ora92)</FONT> 
<BR><FONT face="Courier New">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ORACLE_HOME = /oracle/app/product/9.2.0)</FONT> <BR><FONT face="Courier New">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SID_NAME = ora92)</FONT> <BR><FONT face="Courier New">&nbsp;&nbsp;&nbsp; )</FONT> <BR><FONT face="Courier New">&nbsp; )</FONT> <BR></FONT></FONT></P> <P><FONT><SPAN class=421262511-24072003><FONT color=#0000ff size=2>Regards</FONT></SPAN></FONT></P>
<P><FONT><SPAN class=421262511-24072003><FONT color=#0000ff size=2>Munish Bajaj</FONT></SPAN></P></FONT></FONT></DIV> <BLOCKQUOTE>
  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma   size=2>-----Original Message-----<BR><B>From:</B> Jack van Zanen   [mailto:JACK_at_QUANTSYSTEMS.NL]<BR><B>Sent:</B> Thursday, July 24, 2003   16:24<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B>   Extproc setup Q?<BR><BR></FONT></DIV>
  <P><FONT face="Courier New" size=2>Hi All,</FONT> </P>   <P><FONT face="Courier New" size=2>I am trying to setup EXTPROC but keep   getting ORA-28575 (Check your tnsnames.ora &amp; listener.ora)</FONT> </P>   <P><FONT face="Courier New" size=2>Attached are my files that look OK to   me</FONT> </P>
  <P><FONT face="Courier New" size=2>Anybody??</FONT> </P>   <P><FONT face="Courier New"
  size=2>****************************************************************************************************</FONT> 
  </P>
  <P><FONT face="Courier New" size=2>[oracle_at_Linux admin]$ cat   tnsnames.ora</FONT> <BR><FONT face="Courier New" size=2># TNSNAMES.ORA Network   Configuration File:
  /oracle/app/product/9.2.0/network/admin/tnsnames.ora</FONT> </P>   <P><FONT face="Courier New" size=2>ORA92 =</FONT> <BR><FONT face="Courier New"
  size=2>&nbsp; (DESCRIPTION =</FONT> <BR><FONT face="Courier New" 
  size=2>&nbsp;&nbsp;&nbsp; (ADDRESS_LIST =</FONT> <BR><FONT face="Courier New" 
  size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST = 
  Linux)(PORT = 1521))</FONT> <BR><FONT face="Courier New"
  size=2>&nbsp;&nbsp;&nbsp; )</FONT> <BR><FONT face="Courier New" 
  size=2>&nbsp;&nbsp;&nbsp; (CONNECT_DATA =</FONT> <BR><FONT face="Courier New" 
  size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SERVICE_NAME = Ora92)</FONT> <BR><FONT 
  face="Courier New" size=2>&nbsp;&nbsp;&nbsp; )</FONT> <BR><FONT 
  face="Courier New" size=2>&nbsp; )</FONT> <BR><FONT face="Courier New" 
  size=2>extproc_connection_data =</FONT> <BR><FONT face="Courier New" 
  size=2>&nbsp; (DESCRIPTION =</FONT> <BR><FONT face="Courier New" 
  size=2>&nbsp;&nbsp;&nbsp; (ADDRESS_LIST =</FONT> <BR><FONT face="Courier New" 
  size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = IPC)(KEY = 
  extproc_agent))</FONT> <BR><FONT face="Courier New"   size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (CONNECT_DATA = (SID =   plsextproc))</FONT> <BR><FONT face="Courier New" size=2>&nbsp;&nbsp;&nbsp;   )</FONT> <BR><FONT face="Courier New" size=2>&nbsp;&nbsp;&nbsp; )</FONT>   </P><BR>
  <P><FONT face="Courier New" size=2>[oracle_at_Linux admin]$ cat   listener.ora</FONT> <BR><FONT face="Courier New" size=2># LISTENER.ORA Network   Configuration File:
  /oracle/app/product/9.2.0/network/admin/listener.ora</FONT> </P><BR>   <P><FONT face="Courier New" size=2>LISTENER =</FONT> <BR><FONT   face="Courier New" size=2>&nbsp; (DESCRIPTION =</FONT> <BR><FONT   face="Courier New" size=2>&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL = TCP)(HOST Received on Thu Jul 24 2003 - 06:19:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US