Re: Tnsping does not succeed

I know it's confusing sometimes - knowing which file Net8 uses. Being a client application, tnsping uses tnsnames.ora (instead of listener.ora). Client apps use tnsnames.ora; server (listener mostly) uses listener.ora. Of course, you can have both client and server on the same host, which is why you find both in %ORACLE_HOME%/network/admin.

-Roger Crowley

"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 - 08:22:04 CDT