SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
I can't connect to Oracle 8.1.6

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
I can't connect to Oracle 8.1.6
Author Message
Alfredo Zuccotti



Joined: 31 Jan 2003
Posts: 1

Post I can't connect to Oracle 8.1.6 Reply with quote

I installed the DB tools for Oracle, but i cannot connect to my Oracle 8.1.6 database.
Using SQL*plus i can connect just fine. I have installed SQL*NET Client 2.3.4.0.0 connecting to an Oracle 8.1.6.3.

The message displayed is :

ORA-12203: TNS:unable to connect to destination

However, in the Host String, it's show me the tnsnames.ora databases list.


Fri Jan 31, 2003 7:56 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7838

Post Re: I can't connect to Oracle 8.1.6 Reply with quote

Do you have multiple versions of Oracle client installed in different directories?

If yes, DB Tools loads the first one it can find in the system search path, and that version tnsnames.ora file does not have the selected destination.

An easy solution is to search your computer for tnsnames.ora files and make sure each of them has this destination.

: I installed the DB tools for Oracle, but i cannot connect to my Oracle 8.1.6
: database.
: Using SQL*plus i can connect just fine. I have installed SQL*NET Client
: 2.3.4.0.0 connecting to an Oracle 8.1.6.3.

: The message displayed is : ORA-12203: TNS:unable to connect to destination

: However, in the Host String, it's show me the tnsnames.ora databases list.

Fri Jan 31, 2003 9:40 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.