Oracle 10g listener issue on FC3

Peter Arremann loony at loonybin.org
Sun Dec 26 22:16:24 UTC 2004


On Sunday 26 December 2004 17:04, fedcore3 at alias.hotpop.com wrote:
> Both files look correct to me:
>
> [root at C5600i ~]# cat /etc/hosts
> # Do not remove the following line, or various programs
> # that require network functionality will fail.
> 192.168.1.101   C5600i C5600i
>
> [root at C5600i ~]# cat
> /usr/oracle/product/10.1.0/Db_1/network/admin/listener.ora
> # listener.ora Network Configuration File:
> /usr/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 = /usr/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 =C5600i)(PORT = 1521))
>       )
>     )
>   )
>
> A. Contreras

First - why did you remove/change the line for your loop back interface? it's 
a baaaaaaad idea to not have 127.0.0.1 there...

Other than that, your litener config seems ok... that together with the 
"Connection reset by peer" error message you're getting makes me think its a 
issue with the process not starting up correctly... Try again after you fixed 
your hosts file and then check the messages log, memory and disk usage. I 
assume you changed your kernel parameters according to the oracle docs?

Peter.




More information about the fedora-list mailing list