Re: intermittent ora-12545

"Gerry Sinkiewicz" <sinkiege_at_snet.net> wrote in message news:<K%WTb.31852$yT3.4028_at_newssvr33.news.prodigy.com>...
> "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
> news:u9bu109bpqnd10naqsn1jsst6n1df30njc_at_4ax.com...
> > On 2 Feb 2004 14:57:39 -0800, sparling_at_speakeasy.net (andrea) wrote:
> >
> > >tnsnames.ora - no sqlnet - the program is on the same machine as the
> > >sid
> >
> > If the program is on the server, why do you use the TCP/IP protocol to
> > connect? You should set ORACLE_SID prior to connecting and leave out
> > the @prod or use the IPC protocol.
> >
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA
>
> And perhaps TWO_TASK (for a unix machine).

My "dba" answers me this -

               no connections are local, all are tcp, no bequeath 
               dont need two_task 

So within his constraints, why would I get the intermittent error 12545?

Perhaps I could rewrite the Pro*C with a different method? ( I am connecting as "user_at_prod" )
We have ORACLE_SID set to prod
we do not have two_task Received on Thu Feb 05 2004 - 12:15:04 CST