Re: TNS Resolve Problem

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 08 Sep 2005 13:55:05 +0200
Message-ID: <dfp8cf$pb0$1@news1.zwoll1.ov.home.nl>

tomtailor_at_freesurf.fr wrote:
> OK now i tried
> D:\>sqlplus sysman/****@KTP.ci-test.CI_BHG
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Mon Aug 8 10:44:40 2005
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> ERROR:
> ORA-12154: TNS:could not resolve the connect identifier specified
>

Which means your tnsnames.ora entry is incorrectly defined. It is there, and found (which is a step forward).

If you get tired of typing @KTP.ci-test.CI_BHG, and rather type @ktp, then add the following to sqlnet.ora: names.default_domain = ci-test.CI_BHG

>
> Enter user-name:
> ^V
>
> and
> D:\>sqlplus sysman/****
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Mon Aug 8 10:44:52 2005
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> ERROR:
> ORA-12560: TNS:protocol adapter error
>
>
> Enter user-name:
> ^V
> D:\>
>
> As you can see, there is no chance to connect. In the NetManager there
> is also an "Test" option and it means:

No I don't see the're no way. IF (yes, capitals! IF) your database is on the same machine as your sqlplus, you could try and use set oracle_sid=KTP
and then try your sqlplus sysman/manager again.

> Versuch, die Verbindung mit folgender Benutzer-Id herzustellen: op
> Der Verbindungstest war erfolgreich.
> -> Witch means everything is OK.

If you have a userid there, yes. Copy it over; you still have two oracle_homes!
>
> So my SQLNET.ora contains:
> D:\>type D:\oracle\product\10.1.0\db_1\network\admin\sqlnet.ora
> # sqlnet.ora Network Configuration File:
> D:\oracle\product\10.1.0\db_1\network\a
> dmin\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> ... seems to be ok, tnsnames is in the path.

Time to take a peek into the documentation - it means no such thing at all. It dictates the means of connecting (use a directory, or LDAP, server, use a configuration file, or...)
>
> The winXP Registry seems to be too complex to me, it's not quite easy
> than the Enviroments under my SuSE Oracle (witch works very well).
> Thing is, I have to do this damn Oracle Thing under Windows and it
> seems to be impossible to get it work.

Then get used to the refistry! Or dump Windows.

Part of your tnsnames.ora says:

    (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = KTP)

    )

Are you sure you named it KTP, and not ktp.ci-test.CI_BHG?!? BTW, ci-test is very odd in a network; ci_test would be OK, the minus (in stead of underscore) can cause problems.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Thu Sep 08 2005 - 06:55:05 CDT