ORA-12154 with Toad and Designer
Date: 21 Apr 2003 11:23:28 -0700
Message-ID: <1efdad5b.0304211023.7d6ec948_at_posting.google.com>
[Quoted] [Quoted] Yes, I know there are lots of posts on ORA-12154 and I read them. Didnt get what I want.
On my new site we have:
Oracle 8.1.7 database instances(several) on several Solaris v5.08
platforms
I have 817 client installed
Second Oracle home Designer 2.1.2
Also have toad installed
No problem connecting to any databases with SQLPLUS. I have my TNSNAMES.ORA in the appropriate network/admin and net80/admin directories.
[Quoted] However, when I try to connect to the database with either TOAD or Designer I get the ORA-12154: unable to resolve service names.
In toad you can set your SQLNET and I do set it to one of my Oracle homes(need two homes because older version of designer needs older home) and its says my SQLNET is correct, but still get the error.
any ideas?
also, anyone got a link to a tech support forum on quest software site? couldnt find it. Received on Mon Apr 21 2003 - 20:23:28 CEST