Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: External Procedures
In article <e918b233.0208121304.50efce60_at_posting.google.com>, hatwarm_at_yahoo.com
says...
>
>Hello There,
> I am trying to call external procedures from within PL/SQL on Oracle
>8.1.7 on Linux.
>
>I was successful in doing this on a development machine which hosts
>only one instance and one database.
>
>But when I tried to do the same on the production machine which has
>three databases on the same instance of Oracle I get a ORA-28575
>error.
>
>I am including the Listener.ora and tnsnames.ora. Can someone give me
>an insight as to why I am getting this error..
>
does the sqlnet.ora on the server have a names.default_domain of myco.com in it? If not, the tnsnames entry is wrong
>TNSNAMES.ORA
>EXTPROC_CONNECTION_DATA.MYCO.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
>INST1_HTTP.MYCO.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = asp1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = asp.myco)
> (PRESENTATION = http://admin)
> )
> )
>
>ASP.MYCO.COM=
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = asp1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = asp.myco)
> )
> )
>
>STARS.MYCO.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = asp1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = stars.myco)
> )
> )
>
>STARS_D.MYCO.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = asp1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = stars_d.myco)
> )
> )
>
>
>
>
>LISTENER.ORA
>
>
>
>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = asp1)(PORT = 1521))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> )
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /oracle/8.1.7)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = asp.myco)
> (ORACLE_HOME = /oracle/8.1.7)
> (SID_NAME = asp)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = stars.myco)
> (ORACLE_HOME = /oracle/8.1.7)
> (SID_NAME = stars)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = stars_d.myco)
> (ORACLE_HOME = /oracle/8.1.7)
> (SID_NAME = stars_d)
> )
> )
>
>
>Thanks in advance.........
-- Thomas Kyte (tkyte@oracle.com) http://asktom.oracle.com/ Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Mon Aug 12 2002 - 18:43:12 CDT