Home » RDBMS Server » Server Administration » restarting the listener and database (11.2.0.1)
restarting the listener and database [message #488110] Tue, 04 January 2011 22:13 Go to next message
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
Senior Member
Hi,

I am using Oracle 11g. After rebooting the server listener and databases are not up and running but ASM is up.

How the listener and databases will be up?

I have entry in /etc/oratab file:

+ASM:/opt/grid/11.2.0/grid:N
IPDCDB2:/opt/oracle/product/11.2.0/db:Y

Please advice.
Re: restarting the listener and database [message #488111 is a reply to message #488110] Tue, 04 January 2011 22:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>but ASM is up.
Really.
Please post proof via COPY & PASTE.

the listener can be started by doing as below & after issuing command below post COPY the result then PASTE all back here.

lsnrctl start
Re: restarting the listener and database [message #488112 is a reply to message #488111] Tue, 04 January 2011 22:43 Go to previous message
grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad
Senior Member
After restarting listener, below is the output.

[oracle@bluemoon ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 05-JAN-2011 10:08:42

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

Starting /opt/oracle/product/11.2.0/db/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Log messages written to /opt/oracle/diag/tnslsnr/bluemoon/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bluemoon.wipro.com)(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 05-JAN-2011 10:08:42
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /opt/oracle/diag/tnslsnr/bluemoon/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=bluemoon.wipro.com)(PORT=1521)))
The listener supports no services
The command completed successfully

Previous Topic: Tablespace offline
Next Topic: Alter Tablespace
Goto Forum:
  


Current Time: Fri Nov 29 08:44:25 CST 2024