Re: strange ora-12545 when connecting with pro*c program

Hi,

By any chance, is the variable ORACLE_SID being populated while the Pro*C client tries to connect to the Oracle instance? If yes, you shall need to unset it. Perhaps, that is why Oracle is trying to make a local connection using the bequeath adapter.

regards
Bhooshan

pj_pl_at_yahoo.com (Johny) wrote in message news:<3d744c83.693767_at_news.tpi.pl>...
> Hi!
> I'm connecting from Solaris client to Solaris server machine.
> Everything is OK when connecting from client with SqlPlus. But the
> same connect string used in Pro*C program raises ora-12545 error...
>
> I've tried many configurations in client tnsnames.ora, all
> configurations and host name resloution seem to be ok.
>
> What is strange to me, is sqlnet.log. It seems like client is trying
> to use BEQUEATH:
>
> ***********************************************************************
> Fatal NI connect error 12545, connecting to:
>
> (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/steryd2/oradata/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=bzyk)(USER=bkucha))))
>
> VERSION INFORMATION:
> TNS for Solaris: Version 8.1.6.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for Solaris: Version 8.1.6.0.0 -
> Production
> Time: 02-WRZ-2002 12:53:36
> Tracing to file: /steryd2/oradata/network/trace/cli.trc
> Tns error struct:
> nr err code: 0
> ns main err code: 12545
> TNS-12545: Connect failed because target host or object does not
> exist
> ns secondary err code: 12560
> nt main err code: 515
> TNS-00515: Connect failed because target host or object does not
> exist
> nt secondary err code: 2
> nt OS err code: 0
>
>
> Can you tell me what could be the reason for this problem?
> Johny
Received on Tue Sep 03 2002 - 06:19:35 CDT