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

From: <fdargo1_at_my-dejanews.com>
Date: Fri, 26 Feb 1999 18:08:15 GMT
Message-ID: <7b6nu7$j0u$1@nnrp1.dejanews.com>

Hi:
Check if you listener.ora has included the SID you especified in tnsnames.ora. Say:
...
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME = sidida.world)
      (SID_NAME = SIDID)
      (ORACLE_HOME = /oracle/app/oracle/product/7.3.2)
      (PRESPAWN_MAX = 10)

...

where SID_NAME has to be the same to

(CONNECT_DATA =
(SID = SIDIP) in the tnsnames.ora.
If all this is right, try connect username/password_at_bpm

I hope it be helpful.
Bye

Federico

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 Fri Feb 26 1999 - 12:08:15 CST