Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_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>
face="Courier New"> )</FONT> <BR><FONT face="Courier New"> (SID_DESC =</FONT> <BR><FONT face="Courier New"> (GLOBAL_DBNAME = Ora92)</FONT><BR><FONT face="Courier New"> (ORACLE_HOME = /oracle/app/product/9.2.0)</FONT> <BR><FONT face="Courier New"> (SID_NAME = ora92)</FONT> <BR><FONT face="Courier New"> )</FONT> <BR><FONT face="Courier New"> )</FONT> <BR></FONT></FONT></P> <P><FONT><SPAN class=421262511-24072003><FONT color=#0000ff size=2>Regards</FONT></SPAN></FONT></P>
size=2>****************************************************************************************************</FONT></P>
size=2> (DESCRIPTION =</FONT> <BR><FONT face="Courier New" size=2> (ADDRESS_LIST =</FONT> <BR><FONT face="Courier New" size=2> (ADDRESS = (PROTOCOL = TCP)(HOST =Linux)(PORT = 1521))</FONT> <BR><FONT face="Courier New"
size=2> )</FONT> <BR><FONT face="Courier New" size=2> (CONNECT_DATA =</FONT> <BR><FONT face="Courier New" size=2> (SERVICE_NAME = Ora92)</FONT> <BR><FONT face="Courier New" size=2> )</FONT> <BR><FONT face="Courier New" size=2> )</FONT> <BR><FONT face="Courier New" size=2>extproc_connection_data =</FONT> <BR><FONT face="Courier New" size=2> (DESCRIPTION =</FONT> <BR><FONT face="Courier New" size=2> (ADDRESS_LIST =</FONT> <BR><FONT face="Courier New" size=2> (ADDRESS = (PROTOCOL = IPC)(KEY =extproc_agent))</FONT> <BR><FONT face="Courier New" size=2> (CONNECT_DATA = (SID = plsextproc))</FONT> <BR><FONT face="Courier New" size=2> )</FONT> <BR><FONT face="Courier New" size=2> )</FONT> </P><BR>
![]() |
![]() |