Re: SQL*Net trouble with Oracle 9i on Redhat 8

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 25 Oct 2002 22:07:16 +0200
Message-ID: <5v8jrugs8rpv0rcrcssdvi0c36fkco76l1@4ax.com>

On Fri, 25 Oct 2002 18:53:15 GMT, "Peter Hand" <phand_at_t2th.com> wrote:

>listener.ora
>#######################
># LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/listener.ora
># Generated by Oracle configuration tools.
>
>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
> )
> )
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /opt/oracle/product/9.2.0)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = MYDB)
> (ORACLE_HOME = /opt/oracle/product/9.2.0)
> (SID_NAME = MYDB)
> )
> )

Your listener.ora's address_list section is incorrect, also the listener won't start if tcp/ip is the first protocol defined. The first section needs to read

>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =

          (address=(protocol=ipc)(key=extproc0))


>        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))

>      )

> )
> )

The extra line is for some reason, correctly in your tnsnames.ora, but it is missing in tnsnames.ora and it *needs* to be there.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Oct 25 2002 - 15:07:16 CDT