ORA-12154: TNS: Could not resolve service name

From: Sebastian Niemann <S.Niemann_at_DeutschePost.de>
Date: Wed, 24 Feb 1999 11:01:27 +0100
Message-ID: <36D3CDF7.A7284181@DeutschePost.de>

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 - 04:01:27 CST