Re: ORA-12154: TNS: Could not resolve service name

Sebastian,

What does you host file look like? You can find that in %Winnt_Home%\winnt\system32\drivers\etc\ where 99% of the time %Winnt_Home%='c:'. Basically, a host file is a list of IP addresses and host names.

Try to ping the host name that you're using, and make sure that you can reach the Oracle NT Server via plain TCP/IP first. The resolved name will show you the IP address it corresponds to.

If you sucessfully ping the NIC on the Oracle Server, check the SID of the Oracle instance. The sid below is ORCL (default). If the starter database was not used, and a custom database was installed, the SID could be any four (or less) word. Ask your system administrator for the SID, open up control panel >> services and look for OracleService[SID], where the [SID] will be the sid of your database.

If the host name and SID are both correct, and you're still not getting a reply from a tnsping, check the ports that the listener is configured. The tnsnames.ora file is just one half of the equation - although this most likely is not the cause, as your friend is able to connect.

I hope that this info gets it for you.

Paul Drake
paled_at_home.remove.com

Sebastian Niemann wrote:
>
> I have installed Oracle 7.3.4. for Windows NT.
>
> I add a database-alias with NetEasy for Windows NT 3.2.2.1.0 and
> then I tried to make a connect to this database with SQL*Plus 3.3.4.0.0
> .
>
> But each time I try it, there comes an error:
> ORA-12154: TNS: Could not resolve service name.
>
> My collegue instead has no problems to connect to the database.
>
> Perhaps it is interesting, that we BOTH have an error while using
> TNSPING.exe to
> connect to our server k3170090 (see excerpt of my TNSNames.ora):
> TNS: 03505 Could not resolve Name.
>
> Ideas and solutions much appreciated!
>
> My TNSNames.ora:
>
> ...
>
> bpm.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = k3170090)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = k3170090)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = ORCL)
> )
> )
Received on Wed Feb 24 1999 - 23:44:54 CST