Re: Oracle extproc not working the 1st time

I have a similar problem....the extproc is shared between two development databases and usually runs OK on both....However, in some cases, and for a reason unknown to myself, one of these instances can execute external procedures successfully whilst the other cannot..

At the moment restarting the instance rectifies the problem but this is impractical in a live environment and we require a better solution..

Has anyone any ideas ???

Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

Doug Cowles wrote in message <37D53150.846A3_at_bigfoot.com>...
>Let me know what you find out.. I have a similar problem, in that the
>extproc
>seems not to work when the database has been restarted until I change IPC
>
>to TPC or vice versa, then they alway work fine. Oracle 8.0.5.
>
>eva wrote:
>
>> Hello,
>>
>> I'm using Oracle 8.0.5 under Windows NT.
>> I've configured TNSNAMES.ORA and LISTENER.ORA
>> for the extproc. It works fine, just a problem.
>>
>> I open a SQL*Plus session and execute
>> a external procedure. After waiting for
>> some seconds it spans and error that it
>> can't open an RPC connection to external procedure agent. That's
>> ORA-28575 , and is the same error you get when you don't have
>> tnsnames.ora and listener.ora well configured.
>>
>> The good thing is: if you execute the same external procedure again a
>> second time it works!.
>>
>> Anybody knows about this error?
>>
>> How can i trace this?
>>
>> I think it has to be a timeout problem with
>> the process that is started for every new
>> session to serve external procedures.
>>
>> Thank you very much
>>
>> Ferran Foz
>
>
>
Received on Wed Sep 08 1999 - 03:27:25 CDT