Both files look correct to me:
[root@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@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@xxxxxxxxxx
[mailto:fedora-list-bounces@xxxxxxxxxx]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@xxxxxxxxxxxxxxxx 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@xxxxxxxxxx
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list
