Oracle 10g listener issue on FC3

[fedcore3 at alias.hotpop.com]

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




-----Original Message-----
From: fedora-list-bounces at redhat.com
[mailto:fedora-list-bounces at redhat.com]On Behalf Of Peter Arremann
Sent: Sunday, December 26, 2004 3:38 PM
To: For users of Fedora Core releases
Subject: Re: Oracle 10g listener issue on FC3


On Sunday 26 December 2004 15:11, fedcore3 at alias.hotpop.com wrote:
> Hi all. Running into a bit of an issue with Oracle 10g.
>
> Installed without issues, and can access the database locally.
>
> Getting the listener to work hasn't succeeded:
>
> LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 26-DEC-2004 15:08:10
>
> Copyright (c) 1991, 2004, Oracle.  All rights reserved.
>
> Starting /usr/oracle/product/10.1.0/Db_1/bin/tnslsnr: please wait...
>
> TNSLSNR for Linux: Version 10.1.0.3.0 - Production
> System parameter file is
> /usr/oracle/product/10.1.0/Db_1/network/admin/listener.ora
> Log messages written to
> /usr/oracle/product/10.1.0/Db_1/network/log/listener.log
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
> Listening on:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=C5600i)(PORT=1521)))
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
> TNS-12547: TNS:lost contact
>  TNS-12560: TNS:protocol adapter error
>   TNS-00517: Lost contact
>    Linux Error: 104: Connection reset by peer
> Connecting to
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=C5600i)(PORT=1521))) TNS-12541:
> TNS:no listener
>  TNS-12560: TNS:protocol adapter error
>   TNS-00511: No listener
>    Linux Error: 111: Connection refused
>
> I have SELinux disabled, no firewall on the server (IPTables or other)
>
> Not sure where to look next. Tried changing the HOST to the machine name,
> with and without domain name, IP address, no luck.
>
> Any ideas?
Have you followed the instructions of Werner Puschitz' website?
(http://www.puschitz.com/InstallingOracle10g.shtml)
10g works for me (including listener) - what does your /etc/hosts file look
like? Also, can you cut and paste your listener.ora file?

Peter.

--
fedora-list mailing list
fedora-list at redhat.com
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list