Sorry...another ORA-12154 TNS:Could not resolve service name problem
Date: 24 Mar 2005 01:26:43 -0800
Message-ID: <1111656403.049815.285370_at_f14g2000cwb.googlegroups.com>
[Quoted] Hello all. I just installed the full Oracle 10g developer tools on a PC [Quoted] running Win XP Pro. I had 9.2 client on it before and it worked fine.
The installation was successful and I then ran the net configuration assistant. The connection test was successful. However, when I try to connect using SQLPlus or forms developer I get the "could not resolve service name" error.
Here's the config:
-Win XP Pro
-Oracle 10g full developer tools install
-IP address 192.168.0.202
TNSNAMES.ORA:
# TNSNAMES.ORA Network Configuration File:
c:\oracle\ora10g\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
DB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.250)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = db1.mcbill)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PLSExtProc)
)
The database I am attempting to connect to is a 9.2.0.5 database on a VMS server. Here is the server info:
-IP address: 192.168.0.250
-Oracle 9.2.0.5
-Global name: db1.mcbill
-port: 1521
I also installed Toad 8.0 and it connects fine. Any ideas?
Thank you.
Bill
Received on Thu Mar 24 2005 - 10:26:43 CET