Re: Tnsping does not succeed

From: Henk Hultink <hhu_at_stopspam.stoas.nl>
Date: Tue, 6 Aug 2002 14:44:06 +0200
Message-ID: <3d4fc49d@news.wau.nl>

Hi,

You should locate the file TNSNAMES.ORA (usually located in the same directory as your LISTENER.ORA and SQLNET.ORA) and find out the instance-alias that your instance uses; that is the parameter that you would use tigether with TNSPING.

For Example, part of your TNSNAMES.ORA might look like this:

ORCL.COMPIERE.ORG =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (Host = <server_name or ip_number>)

          (Port = 1521)

        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

Then you should use:

TNSPING orcl.compiere.org

BTW Falls es Dich stört wenn die Meldungen in Deutsch erscheinen kannst Du natürlich auch NLS_LANGUAGE ändern :-)

--
H. Hultink
Software Engineer
Stoas, Division IOAL
Wageningen, The Netherlands
"Activating Knowledge"
http://www.stoas.nl

e-mail: hhu_at_stopspam.stoas.nl

"Wolfhart Bauer" <morpher_at_wolfhart-bauer.de> wrote in message
news:aio221$ri6$1_at_news.online.de...
> Hi,
>
> I need to install Oracle as db backend for another software. However, I
have
> a problem with the installation. I created a sample database using the
> assistent and tried to tnsping it:
>
> tnsping compiere.compiere.org
>
> I only get the following results:
>
> > TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
> 06-AUG-20
> > 02 10:36:11
> >
> > Copyright (c) 1997 Oracle Corporation.  All rights reserved.
> >
> > Parameterdateien benutzt:
> > E:\oracle\ora92\network\admin\sqlnet.ora
> >
> > TNS-03505: Name konnte nicht aufgel÷st werden
>
> Sorry that it is in german. :-(
>
> My sqlnet.ora looks as follows:
>
> # SQLNET.ORA Network Configuration File:
> E:\oracle\ora92\NETWORK\ADMIN\sqlnet.ora
> # Generated by Oracle configuration tools.
>
> NAMES.DEFAULT_DOMAIN = compiere.org
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> My listeners.ora looks as follows:
>
> # LISTENER.ORA Network Configuration File:
> E:\oracle\ora92\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
>   (DESCRIPTION_LIST =
>     (DESCRIPTION =
>       (ADDRESS_LIST =
>         (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
>       )
>       (ADDRESS_LIST =
>         (ADDRESS = (PROTOCOL = TCP)(HOST = sonja)(PORT = 1521))
>       )
>     )
>   )
>
> SID_LIST_LISTENER =
>   (SID_LIST =
>     (SID_DESC =
>       (SID_NAME = PLSExtProc)
>       (ORACLE_HOME = E:\oracle\ora92)
>       (PROGRAM = extproc)
>     )
>     (SID_DESC =
>       (GLOBAL_DBNAME = compiere.compiere.org)
>       (ORACLE_HOME = E:\oracle\ora92)
>       (SID_NAME = compiere)
>     )
>   )
>
> The name of my machine is "sonja", pinging works. The listener service
seems
> to be up. What is happening here? Why doesn't the tnsping utility use the
> listener.ora file?
>
> Thanks for any answers
> Wolfhart
>
>
>
>

Received on Tue Aug 06 2002 - 07:44:06 CDT