Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: External Procedures
jusungyang_at_yahoo.com (Jusung Yang) wrote in message news:<42ffa8fa.0208122141.da87895_at_posting.google.com>...
> 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.
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. Received on Tue Aug 13 2002 - 10:19:02 CDT