External procedures and ORA-28575 - again. Listener failure?

From: vovchik <vmylniko_at_sct.com>
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

Original text of this message