Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_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)
(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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =charset=3DUS-ASCII">
<TITLE>Extproc setup Q?</TITLE> </HEAD> <BODY>
<P><FONT SIZE=3D2 FACE=3D"Courier New">Hi All,</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">I am trying to setup EXTPROC but =
keep getting ORA-28575 (Check your tnsnames.ora & =
listener.ora)</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">Attached are my files that look =
OK to me</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">Anybody??</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Courier =
New">*******************************************************************= *********************************</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">[oracle_at_Linux admin]$ cat =
tnsnames.ora</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"># TNSNAMES.ORA Network =
Configuration File: =
/oracle/app/product/9.2.0/network/admin/tnsnames.ora</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">ORA92 =3D</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> (DESCRIPTION =3D</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> =(ADDRESS_LIST =3D</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> = (ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D Linux)(PORT =3D 1521))</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> )</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> = (CONNECT_DATA =3D</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> = (SERVICE_NAME =3D Ora92)</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> )</FONT><BR><FONT SIZE=3D2 FACE=3D"Courier New"> )</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New">extproc_connection_data = =3D</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> (DESCRIPTION =3D</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> = (ADDRESS_LIST =3D</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> = (ADDRESS =3D (PROTOCOL =3D IPC)(KEY =3D extproc_agent))</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> = (CONNECT_DATA =3D (SID =3D plsextproc))</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> )</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> )</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">[oracle_at_Linux admin]$ cat =
listener.ora</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"># LISTENER.ORA Network =
Configuration File: =
/oracle/app/product/9.2.0/network/admin/listener.ora</FONT>
</P>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Courier New">LISTENER =3D</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> (DESCRIPTION =3D</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> (ADDRESS =3D =(PROTOCOL =3D TCP)(HOST =3D Linux)(PORT =3D 1521))</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> (ADDRESS =3D = (PROTOCOL =3D IPC)(KEY =3D extproc_agent))</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> )</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">SID_LIST_LISTENER =3D</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> (SID_LIST =3D</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> (SID_DESC ==3D</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New"> )</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier New"> )</FONT> <BR><FONT SIZE=3D2 FACE=3D"Courier = New">*******************************************************************= *********************************</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">TIA</FONT> Received on Thu Jul 24 2003 - 04:55:10 CDT
![]() |
![]() |