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

Hello,

  From what you say, I'm guessing that the problem is that the host string you specify when using SQL*Plus is wrong. Make sure to use the alias in your TNSNAMES.ORA file (bpm) and not the SID or something else. If the problem persists, I suggest you copy your colleague's TNSNAMES.ORA and SQLNET.ORA files to your machine. Be sure to save your present TNSNAMES.ORA and SQLNET.ORA files so that if you are successful, you can compare them to the files obtained from your colleague to see what was wrong.

When you get it all figured out or if you need additional help, drop me a line at cary_at_nams.net. Good luck!

Cary

In article <36D3CDF7.A7284181_at_DeutschePost.de>,   Sebastian Niemann <S.Niemann_at_DeutschePost.de> 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)
> )
> )
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 25 1999 - 11:02:36 CST