Tnsping does not succeed

From: Wolfhart Bauer <morpher_at_wolfhart-bauer.de>
Date: Tue, 6 Aug 2002 10:40:17 +0200
Message-ID: <aio221$ri6$1@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 - 03:40:17 CDT