Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Net trouble with Oracle 9i on Redhat 8

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

From: Peter Hand <phand_at_t2th.com>
Date: Sat, 26 Oct 2002 01:07:35 GMT
Message-ID: <pan.2002.10.26.01.08.49.570704@t2th.com>


I tried adding the line you suggested and got:

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory

Grrrr.... thank you for the suggestion anyway. I tried some different combinations and they have not worked. I will try revising the listener with netca including ipc this time.

Peter

On Fri, 25 Oct 2002 22:07:16 +0200, Sybrand Bakker wrote:

> 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 - 20:07:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US