Thomas Kyte <tkyte_at_oracle.com> wrote in message news:<aj9h6g0808_at_drn.newsguy.com>...
> 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.........
The sqlnet.oRA has the following set
NAMES.DEFAULT_DOMAIN = MYCO.COM
on both the machines.
Should I specify in the connect_data clause SERVER=SHARED for the
extproc_connection_data.MYCO.COM??
Received on Tue Aug 13 2002 - 07:45:03 CDT
