Home » Infrastructure » Windows » connecting to db after installation in win NT
connecting to db after installation in win NT [message #119201] Wed, 11 May 2005 03:03 Go to next message
vinmoh
Messages: 1
Registered: May 2005
Junior Member
hi...i'm an oracle newbie!
just installed oracle 8 - the client part of the package.
i'm trying to connect to the local db using sql plus 8.0.
i tried t username - SCOTT and password - TIGER leaving the hoststring blank.
but i get the error mesg - TNS - unable to connect to destination.
so what shd. i do regarding this...expecting help
thank u
Vineet.
Re: connecting to db after installation in win NT [message #119319 is a reply to message #119201] Wed, 11 May 2005 15:33 Go to previous messageGo to next message
ender
Messages: 14
Registered: May 2005
Junior Member
I'm no expert but I only get the "TNS - unable to connect to destination." error when the server isn't started.

If by local db you mean one that is stored on your harddrive you will want to install the server as well and turn it on before trying to connect to the database.

Hope this will help.
Re: connecting to db after installation in win NT [message #119320 is a reply to message #119201] Wed, 11 May 2005 15:43 Go to previous message
llugaro
Messages: 1
Registered: May 2005
Location: South Carolina
Junior Member

Check your TNSNAMES.ORA file for SID Connection, eg. (C:\orant\NET80\ADMIN) directory, check with your system administrator, he/she should be able to tell you what is your connection string.
Previous Topic: Problems with UIW60.dll aborts (even after Forms 6i Patch 15 applied)
Next Topic: Looking for an Oracle Client Configuration Tool
Goto Forum:
  


Current Time: Mon Nov 25 03:22:15 CST 2024