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

From: Peter Hand <phand_at_t2th.com>
Date: Sat, 26 Oct 2002 06:18:17 GMT
Message-ID: <pan.2002.10.26.06.19.32.689459@t2th.com>

SOLVED! Permissions on /var/tmp were 755, ownership root. The listener, being run by the oracle user could not create the .oracle file in that directory. I change the permissions to 777 and all is well.

Now to see if I can get DBD::Oracle to work!

:-)

Turk and Sybrand: Thanks for your energy!

Peter

On Fri, 25 Oct 2002 20:08:49 +0000, Peter Hand wrote:

> 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 Sat Oct 26 2002 - 01:18:17 CDT