Home » SQL & PL/SQL » SQL & PL/SQL » SQL Navigator
SQL Navigator [message #37276] Mon, 28 January 2002 13:02 Go to next message
Aleksei Wolff
Messages: 1
Registered: January 2002
Junior Member
Hello,

I am trying to log onto a oracle 8i db using sql/navigator. I have successfully logged onto the db using sqlplus on the unix command line using

lawtest@test
and then enterting the password.

But when I try to enter the db using sql navigator I am not exactly sure what to enter in the "COnnect String" I know I have to edit the tnsnames.ora file which I did but it still does not work.

My entry is:

TEST-MHS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.1.133)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TEST)

)
)

ANy idea what I am doing wrong? Is their a configuration file some place in a standard Oracle install that will tell me what values to enter in the tnsnames.ora file?

Thank You.
Re: SQL Navigator [message #37284 is a reply to message #37276] Tue, 29 January 2002 03:53 Go to previous message
Jon
Messages: 483
Registered: May 2001
Senior Member
The connect string should be TEST. Did you try that and have it not work?
Previous Topic: Re: msagent and oracle plz help
Next Topic: UNION ALL
Goto Forum:
  


Current Time: Sat Jul 04 07:06:15 CDT 2020