Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

External Procedures

0 views
Skip to first unread message

Murali

unread,
Aug 12, 2002, 5:04:26 PM8/12/02
to
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..

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

unread,
Aug 12, 2002, 7:43:12 PM8/12/02
to
In article <e918b233.02081...@posting.google.com>, hat...@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

--
Thomas Kyte (tk...@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 Corp

Jusung Yang

unread,
Aug 13, 2002, 1:41:27 AM8/13/02
to
As Tom indicated, better post SQLNET.ora as well. Also,

1. do a
tnsping EXTPROC_CONNECTION_DATA
and see if you can get something useful out of it.
2. Whenever you get an error, check the log files under ORACLE_HOME\network\log
You minght find something useful there.
3. Compare all 3 net config. files on both servers.

Murali

unread,
Aug 13, 2002, 8:45:03 AM8/13/02
to
Thomas Kyte <tk...@oracle.com> wrote in message news:<aj9h6...@drn.newsguy.com>...

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??

Murali

unread,
Aug 13, 2002, 9:37:05 AM8/13/02
to
jusun...@yahoo.com (Jusung Yang) wrote in message news:<42ffa8fa.0208...@posting.google.com>...

When I did tnsping I am getting No Listener error.
When I go into lsnrctl services then I do not see this service enabled
but I see all the other services avalable for asp, stars and stars_d.
How can start the EXTPROC_CONNECTION_DATA service on the problem
machine??

Murali

unread,
Aug 13, 2002, 11:19:02 AM8/13/02
to
jusun...@yahoo.com (Jusung Yang) wrote in message news:<42ffa8fa.0208...@posting.google.com>...

TNS Listener was not running in the appropriate shell and it works now
after I restared/rebooted teh machine.( Also there were lot of other
OS problems which was indirectly causing this problem.

Thanks for your guidance.

Murali

unread,
Aug 13, 2002, 11:20:23 AM8/13/02
to
Thomas I did get the problem fixed. The IS was droppping the listener
for some reason and it disappered after we rebooted the nachine.

Thanks for your help and guidance....

Jusung Yang

unread,
Aug 13, 2002, 2:28:51 PM8/13/02
to
Well, that's why you should compare all 3 *.ora files on both servers
as I had suggested. The problem will become apparent when you do that.
Did you see PLSExtProc from lsnrctl services? That's the one external
procedure needs. Look up the listener.ora and see if something like
the following is there. I cut this from your posted listener.ora by
the way.


> >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)
> > )


>

0 new messages