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

mcbil..._at_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 Received on Thu Mar 24 2005 - 11:18:13 CET