Re: TNS 12545 urgent !!

Deepak wrote:

> I have my Oracle 9i database running on my XP box. I can connect to it
> from Solaris 5.8. I am able to connect from sqlplus. But during a
> install, script is not able to establish connection. My sqlnet.log
>
> Fatal NI connect error 12545, connecting to:
>  
> (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/pinmaster/newtools/oracle_8.1.5/solaris/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION=
> (LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=salvo)(USER=deepak))))
>
>   VERSION INFORMATION:
>         TNS for Solaris: Version 8.1.5.0.0 - Production
>         Oracle Bequeath NT Protocol Adapter for Solaris: Version
> 8.1.5.0.0 - Production
>   Time: 24-NOV-03 18:41:38
>   Tracing not turned on.
>   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
>
> I can connect using sqlplus from both XP and solaris. That means ip,
> port, username, password, SID, service name, etc. are correct. Also
> this means my listener and service are running fine on XP. Does the
> log point to any potential problems?

You use BEQ - that's a local protocol (e.g. will only work
on the solaris box).
Do NOT set the SID in the Solaris environment (which you didn't)
and use a tns alias in the connect string.

Your script is wrong, and does a connect or something similar,
without a connect string
--
Regards, Frank van Bortel