External procedures and ORA-28575 - again. Listener failure?
Date: 20 Jul 2001 11:50:44 -0700
Message-ID: <cc6502e0.0107201050.40fe98a5_at_posting.google.com>
OK, that's again about external procedures - but a little diferent.
I'm trying to create a ctxsys.context index with Oracle intermedia -
and receive a whole bunch of errors including ORA-28575 - unable to
open RPC connection to external procedure agent ... bla bla bla. After
carefully studying all resourses and playing it seems I located the
problem.
I'm running Oracle 8.1.5 on Win NT 4.0 Server Sp5. If I stop and start
the listener everything works! But just for about couple of minutes.
I.e
1. Login locally (from the console) to WIN NT Server.
2 Stop listener - start lisitener.
3. Immediatily start sqlplus and try to create an index - everything
is fine.
4. Everything is fine during the session - i.e. untill I exit from
SQL+.
5. Start SQL+ again - receive ORA-28575. Need to completely exit from
SQL+, restart the listener, start sqlplus - everything OK.
If after restarting the listener I wait for about 5 minutes - external procedure call fails again.
So it look s like 'something somewhere' in those routines failes soon after the listener starts. What is that???
Again, this is not my external procedure - I just creatind a context index on CLOB column - using InterMedia text.
Any thoughts?
BTW - tnsping extproc_connection_data works OK all the time! Received on Fri Jul 20 2001 - 20:50:44 CEST