Home » RDBMS Server » Networking and Gateways » not able to start lsnrctl (oracle 11gr2(11.2.0.1.0) OEL5.5)
not able to start lsnrctl [message #597006] Sun, 29 September 2013 23:03 Go to next message
9390512774
Messages: 103
Registered: January 2011
Location: hyd
Senior Member
Hi Experts,
I created a database on my machine. When I trying to start my lsnrctl in Linux machine. I am not able to start it.
here are my files,
listener.ora
[oracle@localhost admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.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 = localhost.localdomain)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@localhost admin]$ cat sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = /u01/app/oracle

[oracle@localhost admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DB11GR2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DB11gR2)
    )
  )


the below is the cmd i used to start my lsnrctl DB11gR2 and the following error message
[oracle@localhost admin]$ lsnrctl status DB11gR2

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-SEP-2013 09:28:49

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=DB11gR2)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused

My database is already running and it's SID is DB11gR2. If I need to create a lsnrctl How to create it.

Thanks in Advance.
Re: not able to start lsnrctl [message #597007 is a reply to message #597006] Sun, 29 September 2013 23:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
listener.ora file is NOT required to start or use the listener.

move, remove, rename, or otherwise eliminate the listener.ora file then do as below

lsnrctl start

COPY the results from above then PASTE all back here
Re: not able to start lsnrctl [message #597008 is a reply to message #597007] Sun, 29 September 2013 23:13 Go to previous messageGo to next message
9390512774
Messages: 103
Registered: January 2011
Location: hyd
Senior Member
I am good to use the above cmd previously also. My aim is I want to start the lsnrctl specific to Database.
Because my oracle Enterprise manager is not loading the page.

when i used the https://localhost.localdomain:1158/em it's showing a message like below
Failed to Connect

Firefox can't establish a connection to the server at localhost.localdomain:1158.
Though the site seems valid, the browser was unable to establish a connection.

    * Could the site be temporarily unavailable? Try again later.
    * Are you unable to browse other sites?  Check the computer's network connection.
    * Is your computer or network protected by a firewall or proxy? Incorrect settings can interfere with Web browsing.
Re: not able to start lsnrctl [message #597009 is a reply to message #597008] Sun, 29 September 2013 23:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I am good to use the above cmd previously also.
>My aim is I want to start the lsnrctl specific to Database.
listener should NEVER be "dedicated" to any specific database.
listener should service every instance that runs on the DB Server

>>Because my oracle Enterprise manager is not loading the page.
when listener uses "localhost", then no remote client can ever connect to the listener.

move, remove, rename, or otherwise eliminate the listener.ora file then do as below

lsnrctl start
lsnrctl status

COPY the results from above then PASTE all back here


Re: not able to start lsnrctl [message #597010 is a reply to message #597009] Sun, 29 September 2013 23:27 Go to previous messageGo to next message
9390512774
Messages: 103
Registered: January 2011
Location: hyd
Senior Member
removed the listener.ora.
now I am using the lsnrctl start below is the output
[oracle@localhost admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-SEP-2013 09:51:09

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

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

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                30-SEP-2013 09:51:09
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully


the result of the cmd lsnrctl status is below
[oracle@localhost admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-SEP-2013 09:51:55

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                30-SEP-2013 09:51:09
Uptime                    0 days 0 hr. 0 min. 45 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully


Why I am not able to load my Enterprise manager
Re: not able to start lsnrctl [message #597011 is a reply to message #597010] Sun, 29 September 2013 23:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
issue the OS commands below

lsnrctl service
emctl start dbconsole
emctl status dbconsole

COPY the results from above then PASTE all back here

[Updated on: Sun, 29 September 2013 23:32]

Report message to a moderator

Re: not able to start lsnrctl [message #597012 is a reply to message #597011] Sun, 29 September 2013 23:47 Go to previous messageGo to next message
9390512774
Messages: 103
Registered: January 2011
Location: hyd
Senior Member
[oracle@localhost ~]$ lsnrctl service

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-SEP-2013 10:07:52

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "DB11gR2" has 1 instance(s).
  Instance "DB11gR2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:178 refused:0 state:ready
         LOCAL SERVER
Service "DB11gR2XDB" has 1 instance(s).
  Instance "DB11gR2", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: localhost.localdomain, pid: 9014>
         (ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=26728))
The command completed successfully

[oracle@localhost ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://localhost.localdomain:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ......... started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost.localdomain_DB11gR2/sysman/log


[oracle@localhost ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://localhost.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/localhost.localdomain_DB11gR2/sysman/log


Now I am good to use enterprise manager.
but the problem is after few minutes it's getting disconnected.
Re: not able to start lsnrctl [message #597013 is a reply to message #597012] Sun, 29 September 2013 23:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Now I am good to use enterprise manager.
>but the problem is after few minutes it's getting disconnected.

Do you realize that now this is the THIRD different problem you are reporting?
I fixed the listener problem.
I got you connected via EM.
I suggest that you only use MS ACCESS which is a much more user friendly application.
Re: not able to start lsnrctl [message #597215 is a reply to message #597010] Tue, 01 October 2013 11:49 Go to previous messageGo to next message
sudheergodgeri
Messages: 7
Registered: December 2010
Location: Mumbai, India
Junior Member


Normally you do not need to configure listener for connectivity to running db as registration is dynamic.

BUT if you are planning to use ENTERPRISE MANAGER / physical standby etc. -- please add the service name
to the SID_LIST_LISTENER entry ( if not present, plz. add manually to the listener.ora file)

eg. entries of your listener cud be:

LISTENER =
( ADDRESS = (HOST=LOCALHOST.LOCALDOMAIN.COM)(PROTOCOL=TCP)(PORT=1521))
)

##ADD BELOW ENTTRY FOR ENTERPRISE MANAGER TO WORK-- my db name is meruprod.fauna sid=meruprod
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /data/app)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = meruprod.fauna)
(ORACLE_HOME = /data/app)
(SID_NAME=meruprod)
)
)


-- thats all then reload listener/restart it , startup your enterprise manager -- everything will work ok.


Re: not able to start lsnrctl [message #597217 is a reply to message #597215] Tue, 01 October 2013 12:13 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
> thats all then reload listener/restart it , startup your enterprise manager -- everything will work ok.
How does above have any impact on OP being disconnected after a few minutes?
Previous Topic: mysql oracle integration
Next Topic: TNS-12537 TNS:connection closed
Goto Forum:
  


Current Time: Thu Mar 28 19:15:00 CDT 2024