Re: configure listener.ora and tnsnames.ora

From: <sybrandb_at_hccnet.nl>
Date: Thu, 06 Aug 2009 21:25:33 +0200
Message-ID: <udbm755q8a0coi287g1o2svahqubebvvjs_at_4ax.com>

On Thu, 6 Aug 2009 16:46:04 +0200, usenet2009_at_zacek.de (Viktor Zacek) wrote:

>ilbmbo <ilbimbo_at_gmail.com> wrote:
>
>> using your Listener.ora i have this error:
>
>We usually name our listeners... so try the following one, which I
>copied from a 10g server on a SLES9 machine:
>
>
>LISTENER10g =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = linux-gle.Id)(PORT = 1521))
> )
>
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = AFTIDI)
> (ORACLE_HOME = /opt/oracle/product/10.2/db_1)
> (PROGRAM = extproc)
> )
> )
>
>
>Listener would be started with:
>"lsnrctl start 10g"
>
>
>Best regards,
>Viktor

Actually this file is incorrect

It should be

LISTENER10g =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux-gle.Id)(PORT = 1521))   )

SID_LIST_LISTENER10g =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = AFTIDI)
      (ORACLE_HOME = /opt/oracle/product/10.2/db_1)
      (PROGRAM = extproc)

    )
  )

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Thu Aug 06 2009 - 14:25:33 CDT