Sorry...another ORA-12154 TNS:Could not resolve service name problem

[Guest]

Hello all. I just installed the full Oracle 10g developer tools on a PC
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

[Guest]

mcbil...@yahoo.com wrote: Hello all. I just installed the full Oracle 10g developer tools on a
PC 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


Sorry...please ignore this. It ended up being a typical windows issue--
all I had to do was reboot one more time and now I can connect.

Bill