Re: TNS no listener Oracle10g redhat es

From: Raymond <dael_at_wxxxxxxxxxxxxs.nl>
Date: Thu, 7 Jul 2005 08:09:07 +0200
Message-ID: <42ccc6fd$0$2944$ba620dc5@text.nova.planet.nl>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:55loc1dmf05cmb2a2psfip23solvtbtmd0_at_4ax.com...
> On Wed, 6 Jul 2005 23:45:50 +0200, "Raymond" <daelen_at_wxs.nl> wrote:
>
> >
> >"Mladen Gogala" <gogala_at_sbcglobal.net> wrote in message
> >news:pan.2005.07.06.00.08.23.943377_at_sbcglobal.net...
> >> On Wed, 06 Jul 2005 00:10:50 +0200, Raymond wrote:
> >>
> >> >
> >> > What to do next to figure out the problems?
> >> > TIA
> >>
> >> Try defining the TNS descriptor with netca. Make sure you don't skip
the
> >> test.
> >>
> >> --
> >> http://www.mgogala.com
> >>
> >
> >Hmm not sure what you mean, but I created the database etc right after
> >installation, so using the config tools Oracle would use!
> >Running netca did not alter the situation!
> >
> >Raymond
> >
>
> Post listener.ora (from server) and sqlnet.ora/tnsnames.ora ( from
> client)
>
> You must be doing something wrong.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

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 Received on Thu Jul 07 2005 - 01:09:07 CDT