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