not able to start lsnrctl [message #597006] |
Sun, 29 September 2013 23:03 |
|
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 #597012 is a reply to message #597011] |
Sun, 29 September 2013 23:47 |
|
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 #597217 is a reply to message #597215] |
Tue, 01 October 2013 12:13 |
|
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?
|
|
|