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(a)redhat.com
[mailto:fedora-list-bounces@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(a)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(a)redhat.com
To unsubscribe:
http://www.redhat.com/mailman/listinfo/fedora-list