Re: TNS no listener Oracle10g redhat es

On Thu, 7 Jul 2005 08:09:07 +0200, "Raymond" <dael_at_wxxxxxxxxxxxxs.nl> wrote:

>Hereby the the TNSnames from client:
># tnsnames.ora Network Configuration File:
>C:\Oracle\product\10.1.0\Client_1\network\admin\tnsnames.ora
># Generated by Oracle configuration tools.
>
>vino =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = pomerol)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = vino)
> (server = dedicated)
> )
> )
>
>vino =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = pomerol)(PORT = 1521))
> )
> (CONNECT_DATA =
> (Sid = vino)
> )
> )
>
>
>
>
>
>and sqlnet.ora (from client):
>
># sqlnet.ora Network Configuration File:
>C:\Oracle\product\10.1.0\Client_1\network\admin\sqlnet.ora
># Generated by Oracle configuration tools.
>
>SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
>NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
>
>and listener from server:
># listener.ora Network Configuration File:
>/u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
>
># Generated by Oracle configuration tools.
>
>
>
>SID_LIST_LISTENER =
>
> (SID_LIST =
>
> (SID_DESC =
>
> (SID_NAME = PLSExtProc)
>
> (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
>
> (PROGRAM = extproc)
>
> )
>
> )
>
>
>
>LISTENER =
>
> (DESCRIPTION_LIST =
>
> (DESCRIPTION =
>
> (ADDRESS_LIST =
>
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
>
> )
>
> (ADDRESS_LIST =
>
> (ADDRESS = (PROTOCOL = TCP)(HOST = pomerol)(PORT = 1521))
>
> )
>
> )
>
> )
>
>Raymond
>
>
>

A few remarks
1 there are two identical tns service names in your tnsnames.ora I'm not sure Oracle is going to buy that. 2 The listener.ora doesn't support your SID, the sid_list_listener is incomplete, and needs a
> (SID_DESC =
>
> (SID_NAME = vino)
>
> (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
>
> )

in it.

Right now the listener.ora will support the service_name = vino in your tnsnames.ora only, provided the service_name (defaults to db_name if db_domain is '' and db_name||'.'||db_domain when db_domain is non blank) is actually vino.
If the service_name isn't vino, no joy.

The listener.ora needs to be corrected, I would make sure the tnsnames.ora is corrected as well (different tns service_names)  

--
Sybrand Bakker, Senior Oracle DBA