Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 724 of 2,288    |
|    Frank to Deepak    |
|    Re: TNS 12545 urgent !!    |
|    26 Nov 03 21:40:21    |
      From: fbortel@nescape.net              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/newto       ls/oracle_8.1.5/solaris/bin/oracle)(ARGV0=oracle)(ARGS='(DESCRIPTION=       > (LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DAT       =(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              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca