Oracle DBMS_CLUSTDB
Version 12.1.0.1

General Information
Purpose RAC cluster validation
AUTHID DEFINER
Dependencies
DBMS_REGISTRY REGISTRY$ V$OPTION
OBJ$ USER$  
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/catclust.sql
Source Code CREATE OR REPLACE PACKAGE dbms_clustdb AS
PROCEDURE validate;
END dbms_clustdb;
/

CREATE OR REPLACE PACKAGE BODY dbms_clustdb AS

PROCEDURE validate IS
 start_time DATE;
 end_time   DATE;
 option_val VARCHAR2(64);
 g_null     CHAR(1);
BEGIN
  BEGIN
    SELECT null INTO g_null FROM obj$
    WHERE owner#=0 AND name='V$CACHE_TRANSFER';

    -- valid if v$ges_statistics exists
    SELECT value INTO option_val FROM v$option
    WHERE parameter = 'Real Application Clusters';

    -- check if RAC option has been linked in
    IF option_val = 'TRUE' THEN
      dbms_registry.valid('RAC');
    ELSE
      dbms_registry.invalid('RAC');
    END IF;
  EXCEPTION
    WHEN NO_DATA_FOUND THEN
      dbms_registry.invalid('RAC');
  END;
END validate;

END dbms_clustdb;
/
 
VALIDATE
Validate cluster database dbms_clustdb.validate;
exec dbms_clustdb.validate;

Related Topics
DBMS_REGISTRY
Packages
RAC

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved