This discussion is archived
3 Replies Latest reply: Nov 21, 2012 1:11 AM by Antonio Navarro RSS

11g RAC Monitoring

KrishnaAgnihotri Explorer
Currently Being Moderated
Hi

I am new to 11g RAC. Kindly give me some metalink doc id or URL to refer for deily monitoring for 11g RAC database.

Thanks
Krishna
  • 1. Re: 11g RAC Monitoring
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    -Check CRS Logs
    -Check Alert log
    -Check Services
    -Check Locks
    -you can Use OEM for check also.
  • 2. Re: 11g RAC Monitoring
    P.Forstmann Guru
    Currently Being Moderated
    First try to see if OEM Database Control is not already configured:
    1. start OEM Database Control with Oracle software owner. Example on Linux:
    [oracle@rac1 ~]$ . oraenv
    ORACLE_SID = [+ASM1] ? RAC1
    The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 is /u01/app/oracle
    [oracle@rac1 ~]$ 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://rac1.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/rac1_RAC/sysman/log
    2. connect to URL (replace <host.domain> with the real hostname and domain name where you have run "emctl start dbconsole"):
    https://<host.domain>:1158/em 
    (make sure to use https).


    If not try to configure Database Control on the RAC database to be able to use Oracle Entreprise Manager:
    http://docs.oracle.com/cd/E11882_01/server.112/e10595/dbcontrol002.htm

    General OEM usage http://docs.oracle.com/cd/E11882_01/server.112/e10897/montune.htm#CHDDAFBD.

    OEM for RAC database: http://docs.oracle.com/cd/E11882_01/rac.112/e17264/racmon2.htm#BABHHGFC.


    Note that some features like AWR, ADDM ans ASH require additional licensing for Tuning pack and/or Diagnostic Pack.

    Edited by: P. Forstmann on 21 nov. 2012 09:32

    Edited by: P. Forstmann on 21 nov. 2012 10:22
  • 3. Re: 11g RAC Monitoring
    Antonio Navarro Pro
    Currently Being Moderated
    The best way is Grid Control, it is complete tool and standard for all Oracle Database. Maybe others like Patrol, Nagios, etc.

    HTH
    Antonio NAVARRO

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points