home bbs files messages ]

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 716 of 2,288   
   Frank to Deepak   
   Re: TNS 12545 urgent !!   
   25 Nov 03 21:53:40   
   
   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