Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.multikabel.nl!surfnet.nl!newsfeeder.wxs.nl!divide.nova.planet.nl!posting.nova.planet.nl!not-for-mail
From: "Raymond" <dael@wxxxxxxxxxxxxs.nl>
Newsgroups: comp.databases.oracle.server
References: <42cb0556$0$17812$ba620dc5@text.nova.planet.nl> <pan.2005.07.06.00.08.23.943377@sbcglobal.net> <42cc50f5$0$2453$ba620dc5@text.nova.planet.nl> <55loc1dmf05cmb2a2psfip23solvtbtmd0@4ax.com>
Subject: Re: TNS no listener Oracle10g redhat es
Date: Thu, 7 Jul 2005 08:09:07 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Lines: 137
Message-ID: <42ccc6fd$0$2944$ba620dc5@text.nova.planet.nl>
NNTP-Posting-Host: 62.131.5.105
X-Trace: 1120716541 text.nova.planet.nl 2944 62.131.5.105:65125
X-Complaints-To: abuse@planet.nl
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:246752


"Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote in message
news:55loc1dmf05cmb2a2psfip23solvtbtmd0@4ax.com...
> On Wed, 6 Jul 2005 23:45:50 +0200, "Raymond" <daelen@wxs.nl> wrote:
>
> >
> >"Mladen Gogala" <gogala@sbcglobal.net> wrote in message
> >news:pan.2005.07.06.00.08.23.943377@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