Showing posts with label RAC. Show all posts
Showing posts with label RAC. Show all posts

Friday, May 11, 2012

Instance Does not Start After 11gR2 Grid Infrastructure Restart or Node Reboot [ID 1149003.1] - Oracle Support


Instance Does not Start After 11gR2 Grid Infrastructure Restart or Node Reboot [ID 1149003.1]


Modified 08-JAN-2012     Type PROBLEM     Status PUBLISHED


In this Document
  Symptoms
  Cause
  Solution


Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Add a component to the Oracle Restart configuration with SRVCTL


When you add a component to the Oracle Restart configuration with SRVCTL, you can specify optional configuration settings for the component.
To add a component to the Oracle Restart configuration with SRVCTL:
  1. Prepare to run SRVCTL as described in "Preparing to Run SRVCTL".
  2. Enter the following command:
    srvctl add object options
    
    where object is one of the components listed in Table 4-8. See the SRVCTL add command for available options for each component.

Viewing a List of All Databases Managed by Oracle Restart


srvctl config database

dbcrm
orcl

Wednesday, April 25, 2012

Check Listener status

srv1:oracle$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node srv2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node srv1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node srv3


Monday, January 24, 2011

Verifying Which Instances are Running


To verify which instances are running, on any node from a SQL*Plus prompt enter the following:

CONNECT SYS/as SYSDBA
Enter password: **********
SELECT * FROM V$ACTIVE_INSTANCES;

How to find the Cluster name?

barbaw:/ora$ $CRS_HOME/bin/cemutlo -n
RAC_barbaw_crs