Rem drv: <migrate type="schema_upgrade" version="11.2.0.0"/>
Rem $Header: osm_schema_upgrade.sql 03-jan-2008.22:11:39 asubba Exp $
Rem
Rem osm_schema_upgrade.sql
Rem
Rem Copyright (c) 2008, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      osm_schema_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    asubba      01/03/08 - removed set x y statements
Rem    asubba      01/02/08 - Created
Rem

Rem
Rem Register types for OFS
Rem
CREATE or replace TYPE SMP_EMD_CLUSTER_OFS_OBJ AS OBJECT(
    OFS_VOLUME_DEVICE     VARCHAR2(256),
    OFS_NAME              VARCHAR2(256),
    OFS_UP_NUM            NUMBER,
    OFS_DOWN_NUM          NUMBER,
    OFS_MOUNTED_NUM       NUMBER,
    OFS_DISMOUNTED_NUM    NUMBER,
    OFS_WARNING_ALERTS    NUMBER,
    OFS_CRITICAL_ALERTS   NUMBER,
    DG_ALLOC_SIZE_GB      NUMBER,
    OFS_SIZE_GB           NUMBER,
    OFS_USED_GB           NUMBER,
    OFS_USED_PCT          NUMBER);
/

CREATE or replace TYPE SMP_EMD_CLUSTER_OFS_OBJ_ARRAY AS TABLE OF SMP_EMD_CLUSTER_OFS_OBJ;
/
CREATE or replace TYPE SMP_EMD_ASM_SERVED_OFS AS OBJECT(
    MOUNT_POINT           VARCHAR2(256),
    AVAILABILITY          VARCHAR2(256),
    CORRUPT               VARCHAR2(256),
    OFS_STATE             VARCHAR2(256),
    OFS_VOLUME_NAME       VARCHAR2(256),
    OFS_VOLUME_DEVICE     VARCHAR2(256),
    OFS_DISKGROUP         VARCHAR2(256),
    DG_ALLOC_SIZE_GB      NUMBER,
    OFS_SIZE_GB           NUMBER,
    OFS_USED_GB           NUMBER,
    OFS_USED_PCT          NUMBER);
/

CREATE or replace TYPE SMP_EMD_ASM_SERVED_OFS_ARRAY AS TABLE OF SMP_EMD_ASM_SERVED_OFS;
/
CREATE or replace TYPE SMP_EMD_NONEOFS_VOL AS OBJECT(
    VOLUME_NAME           VARCHAR2(30),
    VOLUME_DEVICE         VARCHAR2(256),
    VOLUME_USAGE          VARCHAR2(30),
    VOLUME_STATE          VARCHAR2(8),
    VOLUME_DISKGROUP      VARCHAR2(30),
    SIZE_GB               NUMBER,
    DG_ALLOC_SIZE_GB      NUMBER,
    REDUNDANCY            VARCHAR2(8));
/

CREATE or replace TYPE SMP_EMD_NONEOFS_VOL_ARRAY AS TABLE OF SMP_EMD_NONEOFS_VOL;
/

CREATE or replace TYPE SMP_EMD_OFSHOSTS_INFO AS OBJECT(
    HOST_NAME            VARCHAR2(256),
    HOST_STATUS          NUMBER,
    OFS_STATUS           VARCHAR2(256),
    UP_SINCE             VARCHAR2(256),
    OFS_STATE            VARCHAR2(256),
    ASM_INST             VARCHAR2(256),
    ASM_STATUS           NUMBER,
    DISK_GROUP           VARCHAR2(256));
/

CREATE or replace TYPE SMP_EMD_OFSHOSTS_INFO_ARRAY AS TABLE OF SMP_EMD_OFSHOSTS_INFO;
/