Having trouble starting the listener (lsnrctl) in oracle 11g server

[woodquest]

I'm a j2me developer interested in learning some oracle database skills. I' ve just installed oracle11g on fedora 11. Even though I had followed the prescribed installation guides strictly, still I couldn't start the listener.

Can anyone help me to resolve these errors?

Can anyone help me to examine the following outputs?


[oracle@woodquest ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-OCT-2009 16:41:49

Copyright © 1991, 2007, Oracle. All rights reserved.

Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/woodquest/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=woodquest.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12547: TNS:lost contact
TNS-12560: TNSrotocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=woodquest.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused


[oracle@woodquest ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 04-OCT-2009 16:42:07

Copyright © 1991, 2007, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=woodquest.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNSrotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused


*******************PLEASE NOTE******************************
The contents of the following files may also assist in tracing where i went wrong

listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = woodquest.localdomain)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl.localdomain)
(SID_NAME = DB11G)
(ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
)
)


tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = woodquest.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.localdomain)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = DB11G)
(GLOBAL_NAME = orcl.localdomain)
)
)

 

[karluk]

I've never seen this particular error, but a quick web search suggests that you may be missing a loopback entry in your /etc/hosts file. See, for example,

http://im-a-dba.blogspot.com/2009/08/tns-12547.html

 

[sem]

How many network adapters do you have?
Your firewall settings?

Regards, Dima

http://seminihin.narod.ru