Oracle 11g on ECS 测试实践--安装案例

参考文档:MOS Doc ID 472408.1
基于 AMERICAN_AMERICA.US7ASCII 字符集

[oracle@orcl1 schema]$ cd /u01/app/oracle/product/11.2.0/db_1/demo/schema/
[oracle@orcl1 schema]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jul 25 15:54:50 2019

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @mkplug.sql

specify password for SYS as parameter 1:
Enter value for 1: oracle

specify password for HR as parameter 2:
Enter value for 2: oracle

specify password for OE as parameter 3:
Enter value for 3: oracle

specify password for PM as parameter 4:
Enter value for 4: oracle

specify password for IX as parameter 5:
Enter value for 5: oracle

specify password for  SH as parameter 6:
Enter value for 6: oracle

specify password for  BI as parameter 7:
Enter value for 7: oracle

specify INPUT metadata import file as parameter 8:
Enter value for 8: /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/example.dmp

specify INPUT database backup file for tablespace EXAMPLE as parameter 9:
Enter value for 9: /u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/example01.dfb

specify OUTPUT database file for tablespace EXAMPLE as parameter 10:
Enter value for 10: /oradata/ORCL/example01.dbf

specify OUTPUT log directory as parameter 11:
Enter value for 11: /home/oracle/log.txt

specify OUTPUT dump file directory as parameter 12:
Enter value for 12: /home/oracle/

Sample Schemas are being plugged in  ...

Connected.

TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:07

1 row selected.

old   1: CREATE USER hr IDENTIFIED BY &&password_hr
new   1: CREATE USER hr IDENTIFIED BY oracle

User created.

old   1: CREATE USER oe IDENTIFIED BY &&password_oe
new   1: CREATE USER oe IDENTIFIED BY oracle

User created.

old   1: CREATE USER ix IDENTIFIED BY &&password_ix
new   1: CREATE USER ix IDENTIFIED BY oracle

User created.

old   1: CREATE USER sh IDENTIFIED BY &&password_sh
new   1: CREATE USER sh IDENTIFIED BY oracle

User created.

old   1: CREATE USER pm IDENTIFIED BY &&password_pm
new   1: CREATE USER pm IDENTIFIED BY oracle

User created.

old   1: CREATE USER bi IDENTIFIED BY &&password_bi
new   1: CREATE USER bi IDENTIFIED BY oracle

User created.

SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL> 
SQL> CREATE OR REPLACE DIRECTORY data_file_dir AS '/u01/app/oracle/product/11.2.0/db_1/demo/schema/sales_history/';

Directory created.

SQL> CREATE OR REPLACE DIRECTORY log_file_dir  AS '/u01/app/oracle/product/11.2.0/db_1/demo/schema/log/';

Directory created.

SQL> CREATE OR REPLACE DIRECTORY media_dir     AS '/u01/app/oracle/product/11.2.0/db_1/demo/schema/product_media/';

Directory created.

SQL> 
SQL> GRANT READ ON DIRECTORY media_dir      TO pm;

Grant succeeded.

SQL> GRANT READ ON DIRECTORY log_file_dir   TO sh;

Grant succeeded.

SQL> GRANT READ ON DIRECTORY data_file_dir  TO sh;

Grant succeeded.

SQL> GRANT WRITE ON DIRECTORY log_file_dir  TO sh;

Grant succeeded.

SQL> EXECUTE DBMS_DATAPUMP_UTL.REPLACE_DEFAULT_DIR;

PL/SQL procedure successfully completed.

SQL> EXECUTE ORACLE_OCM.MGMT_CONFIG_UTL.create_replace_dir_obj;

PL/SQL procedure successfully completed.

SQL> 
SQL> GRANT CREATE SESSION                    TO hr;

Grant succeeded.

SQL> GRANT ALTER SESSION                     TO hr;

Grant succeeded.

SQL> GRANT CREATE DATABASE LINK              TO hr;

Grant succeeded.

SQL> GRANT CREATE SEQUENCE                   TO hr;

Grant succeeded.

SQL> GRANT CREATE SYNONYM                    TO hr;

Grant succeeded.

SQL> GRANT CREATE VIEW                       TO hr;

Grant succeeded.

SQL> GRANT RESOURCE                          TO hr;

Grant succeeded.

SQL> GRANT execute ON sys.dbms_stats         TO hr;

Grant succeeded.

SQL> 
SQL> GRANT CREATE SESSION                    TO oe;

Grant succeeded.

SQL> GRANT CREATE DATABASE LINK              TO oe;

Grant succeeded.

SQL> GRANT CREATE SYNONYM                    TO oe;

Grant succeeded.

SQL> GRANT CREATE VIEW                       TO oe;

Grant succeeded.

SQL> GRANT RESOURCE                          TO oe;

Grant succeeded.

SQL> GRANT CREATE MATERIALIZED VIEW          TO oe;

Grant succeeded.

SQL> GRANT QUERY REWRITE                     TO oe;

Grant succeeded.

SQL> GRANT execute ON sys.dbms_stats         TO oe;

Grant succeeded.

SQL> 
SQL> GRANT CONNECT                           TO pm;

Grant succeeded.

SQL> GRANT RESOURCE                          TO pm;

Grant succeeded.

SQL> GRANT execute ON sys.dbms_stats         TO pm;

Grant succeeded.

SQL> GRANT READ ON DIRECTORY media_dir       TO pm;

Grant succeeded.

SQL> 
SQL> GRANT CONNECT                           TO ix;

Grant succeeded.

SQL> GRANT RESOURCE                          TO ix;

Grant succeeded.

SQL> 
SQL> GRANT aq_administrator_role             TO ix;

Grant succeeded.

SQL> GRANT aq_user_role                      TO ix;

Grant succeeded.

SQL> 
SQL> GRANT ALTER SESSION TO ix;

Grant succeeded.

SQL> GRANT CREATE CLUSTER TO ix;

Grant succeeded.

SQL> GRANT CREATE DATABASE LINK TO ix;

Grant succeeded.

SQL> GRANT CREATE SEQUENCE TO ix;

Grant succeeded.

SQL> GRANT CREATE SESSION TO ix;

Grant succeeded.

SQL> GRANT CREATE SYNONYM TO ix;

Grant succeeded.

SQL> GRANT CREATE TABLE TO ix;

Grant succeeded.

SQL> GRANT CREATE VIEW TO ix;

Grant succeeded.

SQL> GRANT CREATE CLUSTER TO ix;

Grant succeeded.

SQL> GRANT CREATE INDEXTYPE TO ix;

Grant succeeded.

SQL> GRANT CREATE OPERATOR TO ix;

Grant succeeded.

SQL> GRANT CREATE PROCEDURE TO ix;

Grant succeeded.

SQL> GRANT CREATE SEQUENCE TO ix;

Grant succeeded.

SQL> GRANT CREATE TABLE TO ix;

Grant succeeded.

SQL> GRANT CREATE TRIGGER TO ix;

Grant succeeded.

SQL> GRANT CREATE TYPE TO ix;

Grant succeeded.

SQL> GRANT CREATE SESSION TO ix;

Grant succeeded.

SQL> 
SQL> GRANT CONNECT, RESOURCE, SELECT_CATALOG_ROLE TO ix;

Grant succeeded.

SQL> 
SQL> GRANT EXECUTE ON sys.dbms_stats         TO ix;

Grant succeeded.

SQL> GRANT EXECUTE ON DBMS_AQ                TO ix;

Grant succeeded.

SQL> GRANT EXECUTE ON DBMS_AQADM             TO ix;

Grant succeeded.

SQL> GRANT EXECUTE ON DBMS_APPLY_ADM         TO ix;

Grant succeeded.

SQL> GRANT EXECUTE ON DBMS_CAPTURE_ADM       TO ix;

Grant succeeded.

SQL> GRANT EXECUTE ON DBMS_FLASHBACK         TO ix;

Grant succeeded.

SQL> GRANT EXECUTE ON DBMS_PROPAGATION_ADM   TO ix;

Grant succeeded.

SQL> GRANT EXECUTE ON DBMS_STREAMS_ADM       TO ix;

Grant succeeded.

SQL> GRANT SELECT ANY DICTIONARY             TO ix;

Grant succeeded.

SQL> 
SQL> EXECUTE DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( -
>     privilege    => DBMS_RULE_ADM.CREATE_RULE_SET_OBJ,  -
>     grantee      => 'ix', -
>     grant_option => FALSE);

PL/SQL procedure successfully completed.

SQL> 
SQL> EXECUTE DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( -
>     privilege    => DBMS_RULE_ADM.CREATE_RULE_OBJ,  -
>     grantee      => 'ix', -
>     grant_option => FALSE);

PL/SQL procedure successfully completed.

SQL> 
SQL> GRANT CREATE SESSION                    TO sh;

Grant succeeded.

SQL> GRANT CREATE TABLE                      TO sh;

Grant succeeded.

SQL> GRANT CREATE VIEW                       TO sh;

Grant succeeded.

SQL> GRANT CREATE CLUSTER                    TO sh;

Grant succeeded.

SQL> GRANT ALTER SESSION                     TO sh;

Grant succeeded.

SQL> GRANT CREATE SEQUENCE                   TO sh;

Grant succeeded.

SQL> GRANT CREATE SYNONYM                    TO sh;

Grant succeeded.

SQL> GRANT CREATE DATABASE LINK              TO sh;

Grant succeeded.

SQL> GRANT CREATE DIMENSION                  TO sh;

Grant succeeded.

SQL> GRANT QUERY REWRITE                     TO sh;

Grant succeeded.

SQL> GRANT CREATE MATERIALIZED VIEW          TO sh;

Grant succeeded.

SQL> GRANT CREATE VIEW                       TO sh;

Grant succeeded.

SQL> GRANT RESOURCE                          TO sh;

Grant succeeded.

SQL> GRANT select_catalog_role               TO sh;

Grant succeeded.

SQL> GRANT cwm_user                          TO sh;

Grant succeeded.

SQL> GRANT execute ON sys.dbms_stats         TO sh;

Grant succeeded.

SQL> rem   ALTER USER sh GRANT CONNECT THROUGH olapsvr;
SQL> 
SQL> GRANT CREATE SESSION                    TO bi;

Grant succeeded.

SQL> GRANT CREATE TABLE                      TO bi;

Grant succeeded.

SQL> GRANT CREATE VIEW                       TO bi;

Grant succeeded.

SQL> GRANT CREATE CLUSTER                    TO bi;

Grant succeeded.

SQL> GRANT ALTER SESSION                     TO bi;

Grant succeeded.

SQL> GRANT CREATE SEQUENCE                   TO bi;

Grant succeeded.

SQL> GRANT CREATE SYNONYM                    TO bi;

Grant succeeded.

SQL> GRANT CREATE DATABASE LINK              TO bi;

Grant succeeded.

SQL> GRANT RESOURCE                          TO bi;

Grant succeeded.

SQL> 
SQL> --
SQL> -- Restoring database file backup
SQL> -- (Using RMAN works in OMF, OCFS, raw devices and in normal file systems)
SQL> --
SQL> 
SQL> 
SQL> set echo off;

TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:07

1 row selected.

old  30:       dbms_backup_restore.restoreDataFileTo(data_file_id,'&data_file_name');
new  30:       dbms_backup_restore.restoreDataFileTo(data_file_id,'/oradata/ORCL/example01.dbf');
old  33:     dbms_backup_restore.restoreBackupPiece('&dump_path'||'&data_file_backup', done);
new  33:     dbms_backup_restore.restoreBackupPiece('/home/oracle/'||'/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/example01.dfb', done);
Allocating device....
Specifying datafiles...
Specifing datafiles...
Restoring ...
declare
*
ERROR at line 1:
ORA-19624: operation failed, retry possible
ORA-19870: error while restoring backup piece
/home/oracle/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/exampl
e01.dfb
ORA-19505: failed to identify file
"/home/oracle/u01/app/oracle/product/11.2.0/db_1/assistants/dbca/templates/examp
le01.dfb"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 5937
ORA-06512: at line 33






1 row selected.


TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:07

1 row selected.

old   1: create or replace directory SS_IMPEXP_DIR as '&dump_path'
new   1: create or replace directory SS_IMPEXP_DIR as '/home/oracle/'

Directory created.


Grant succeeded.

old   1: create or replace directory SS_LOGPATH_DIR as '&log_path'
new   1: create or replace directory SS_LOGPATH_DIR as '/home/oracle/log.txt'

Directory created.


Grant succeeded.

LRM-00118: syntax error at '=' at the end of input


Connected.

TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:08

1 row selected.

ALTER TABLESPACE example READ WRITE
*
ERROR at line 1:
ORA-00959: tablespace 'EXAMPLE' does not exist



TABLESPACE_NAME FILE_NAME                                      STATUS
--------------- ---------------------------------------------- ---------
SYSTEM          /oradata/ORCL/system01.dbf                     AVAILABLE
SYSAUX          /oradata/ORCL/sysaux01.dbf                     AVAILABLE
UNDOTBS1        /oradata/ORCL/undotbs01.dbf                    AVAILABLE
USERS           /oradata/ORCL/user01.dbf                       AVAILABLE

4 rows selected.


Creating sequences, views, procedures and objects privileges for HR ...

TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:08

1 row selected.

Connected.

Sequence created.


Sequence created.


Sequence created.

  regions r
  *
ERROR at line 41:
ORA-00942: table or view does not exist



Procedure created.

  BEFORE INSERT OR UPDATE OR DELETE ON employees
                                       *
ERROR at line 2:
ORA-00942: table or view does not exist


ALTER TRIGGER secure_employees DISABLE
*
ERROR at line 1:
ORA-04080: trigger 'SECURE_EMPLOYEES' does not exist



Warning: Procedure created with compilation errors.

  AFTER UPDATE OF job_id, department_id ON employees
                                           *
ERROR at line 2:
ORA-00942: table or view does not exist



Commit complete.

GRANT REFERENCES, SELECT ON employees   TO oe
                            *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT REFERENCES, SELECT ON countries   TO oe
                            *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT REFERENCES, SELECT ON locations   TO oe
                            *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON jobs                    TO oe
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON job_history             TO oe
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON departments             TO oe
                *
ERROR at line 1:
ORA-00942: table or view does not exist



Creating synonyms, sequences, views and functions for OE ...

TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:08

1 row selected.

Connected.

Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Sequence created.

,      product_descriptions d
       *
ERROR at line 22:
ORA-00942: table or view does not exist


,      products    p
       *
ERROR at line 8:
ORA-00942: table or view does not exist


,      products    p
       *
ERROR at line 8:
ORA-00942: table or view does not exist


,      products    p
       *
ERROR at line 8:
ORA-00942: table or view does not exist


FROM   product_information
       *
ERROR at line 7:
ORA-00942: table or view does not exist


FROM            customers c, countries cr
                             *
ERROR at line 7:
ORA-00980: synonym translation is no longer valid



Warning: Function created with compilation errors.

  customers c
  *
ERROR at line 30:
ORA-00942: table or view does not exist


FROM orders
     *
ERROR at line 11:
ORA-00942: table or view does not exist



Creating XML schema, XML folders, OC subschema and objects privileges for OE ...

TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:08

1 row selected.


specify password for OE as parameter 1:

PROMPT password for SYS as parameter 2:

Connected.

Grant succeeded.


Grant succeeded.


Grant succeeded.


Grant succeeded.

  1* GRANT alter session TO oe

Grant succeeded.


View created.


View created.


Grant succeeded.


Session altered.


Package created.


Warning: Package Body created with compilation errors.


View created.


Package altered.


View altered.


Grant succeeded.


Trigger created.


Synonym created.


Grant succeeded.


Call completed.


Session altered.


Session altered.


Function created.


no rows selected


Synonym created.


Grant succeeded.


Package created.


no rows selected


Synonym created.


Grant succeeded.


Package created.


no rows selected


Package body created.


no rows selected


Synonym created.


Grant succeeded.


Package created.


no rows selected


Package body created.


no rows selected


Grant succeeded.


Synonym created.


Package created.


no rows selected


Package body created.


no rows selected


Synonym created.


Grant succeeded.


PL/SQL procedure successfully completed.

Connected.
DROP DIRECTORY SS_OE_XMLDIR
*
ERROR at line 1:
ORA-04043: object SS_OE_XMLDIR does not exist



Directory created.


Commit complete.

Connected.

Revoke succeeded.

Connected.
Connected.

Session altered.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Call completed.


Call completed.


PL/SQL procedure successfully completed.

Connected.

Revoke succeeded.

Connected.
Connected.

Revoke succeeded.


Revoke succeeded.


Revoke succeeded.


Package dropped.


Package dropped.


Package dropped.


Package dropped.


Package dropped.


Trigger dropped.


View dropped.

Connected.

Session altered.

...creating subschema OC in OE

Type created.


Type created.


Type created.


Type created.


Type created.


Type created.


Type created.


Type created.


Type created.


Warning: Type created with compilation errors.


Type created.


Type created.


Type created.


Warning: Type created with compilation errors.


Type created.


Type body created.


Type created.


Type body created.


Type created.


Type body created.


Table created.

    FROM inventories i, warehouses w
                        *
ERROR at line 6:
ORA-00942: table or view does not exist


    FROM product_information p
         *
ERROR at line 10:
ORA-00942: table or view does not exist


     FROM customers c
          *
ERROR at line 20:
ORA-00942: table or view does not exist


     FROM customers c
          *
ERROR at line 20:
ORA-00942: table or view does not exist


     FROM customers c
          *
ERROR at line 20:
ORA-00942: table or view does not exist


    FROM orders o
         *
ERROR at line 9:
ORA-00942: table or view does not exist


 ON oc_orders FOR EACH ROW
    *
ERROR at line 2:
ORA-00942: table or view does not exist


 TABLE order_item_list OF oc_orders FOR EACH ROW
                          *
ERROR at line 2:
ORA-00942: table or view does not exist



Commit complete.

    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 5:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 5:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 5:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 5:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist


    FROM oc_product_information o
         *
ERROR at line 4:
ORA-00942: table or view does not exist



1 row created.


1 row created.


1 row created.


1 row created.


Type altered.


3 rows updated.


0 rows updated.


0 rows updated.


0 rows updated.


Commit complete.


Type body altered.


Type body altered.


Type body altered.

GRANT SELECT ON bombay_inventory        TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON customers               TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON inventories             TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON orders                  TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON order_items             TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON products                TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON product_descriptions    TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON product_information     TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON product_prices          TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON promotions              TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON sydney_inventory        TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON toronto_inventory       TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON warehouses              TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT REFERENCES, SELECT ON product_information TO pm
                            *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON order_items                     TO pm
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON orders                          TO pm
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON product_descriptions            TO pm
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON inventories                     TO pm
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON customers                       TO pm
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON warehouses                      TO pm
                *
ERROR at line 1:
ORA-00942: table or view does not exist



Creating dimensions, materialized views, external table and object privileges for SH ...

TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:14

1 row selected.

Connected.
CREATE DIMENSION customers_dim
*
ERROR at line 1:
ORA-00942: table or view does not exist



Commit complete.

BEGIN dbms_olap.validate_dimension('customers_dim','sh',false,true); END;

*
ERROR at line 1:
ORA-20000: cannot find the dimension
ORA-06512: at "SYS.DBMS_DIMENSION", line 413
ORA-06512: at "SYS.DBMS_DIMENSION", line 435
ORA-06512: at "SYS.DBMS_SUMMARY", line 54
ORA-06512: at line 1



no rows selected

CREATE DIMENSION products_dim
*
ERROR at line 1:
ORA-00942: table or view does not exist


BEGIN dbms_olap.validate_dimension('products_dim','sh',false,true); END;

*
ERROR at line 1:
ORA-20000: cannot find the dimension
ORA-06512: at "SYS.DBMS_DIMENSION", line 413
ORA-06512: at "SYS.DBMS_DIMENSION", line 435
ORA-06512: at "SYS.DBMS_SUMMARY", line 54
ORA-06512: at line 1



no rows selected

CREATE DIMENSION times_dim
*
ERROR at line 1:
ORA-00942: table or view does not exist


BEGIN dbms_olap.validate_dimension('times_dim','sh',false,true); END;

*
ERROR at line 1:
ORA-20000: cannot find the dimension
ORA-06512: at "SYS.DBMS_DIMENSION", line 413
ORA-06512: at "SYS.DBMS_DIMENSION", line 435
ORA-06512: at "SYS.DBMS_SUMMARY", line 54
ORA-06512: at line 1



no rows selected

CREATE DIMENSION channels_dim
*
ERROR at line 1:
ORA-00942: table or view does not exist


BEGIN dbms_olap.validate_dimension('channels_dim','sh',false,true); END;

*
ERROR at line 1:
ORA-20000: cannot find the dimension
ORA-06512: at "SYS.DBMS_DIMENSION", line 413
ORA-06512: at "SYS.DBMS_DIMENSION", line 435
ORA-06512: at "SYS.DBMS_SUMMARY", line 54
ORA-06512: at line 1



no rows selected

CREATE DIMENSION promotions_dim
*
ERROR at line 1:
ORA-00942: table or view does not exist


BEGIN dbms_olap.validate_dimension('promotions_dim','sh',false,true); END;

*
ERROR at line 1:
ORA-20000: cannot find the dimension
ORA-06512: at "SYS.DBMS_DIMENSION", line 413
ORA-06512: at "SYS.DBMS_DIMENSION", line 435
ORA-06512: at "SYS.DBMS_SUMMARY", line 54
ORA-06512: at line 1



no rows selected


TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:14

1 row selected.

 FROM   costs c, sales s
                 *
ERROR at line 13:
ORA-00942: table or view does not exist


  ,        times t
           *
ERROR at line 8:
ORA-00942: table or view does not exist


  ,        products p
           *
ERROR at line 12:
ORA-00942: table or view does not exist



Table created.


Creating OLAP metadata ...
<<<<< CREATE CWMLite Metadata for the Sales History Schema >>>>>
-
<<<<< CREATE CATALOG sh_cat for Sales History >>>>>
        No catalog to drop
        CWM Collect Garbage
-
<<<<< CREATE the Sales CUBE >>>>>
        Sales amount, Sales quantity
        <TIMES CHANNELS PRODUCTS CUSTOMERS PROMOTIONS >
        Drop SALES_CUBE prior to recreation
        No cube to drop
        Add dimensions -
         to SALES_CUBE and map the foreign keys
ERROR::         dimension_not_found
Object Type:    DIMENSION
Object Owner:   SH
Object Name:    TIMES_DIM
Secondary Name:
Tertiary Name:
User-Defined Exception
ERROR: dimension_not_found
declare
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "OLAPSYS.CWM$OLAP$DIMENSION", line 242
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "OLAPSYS.CWM$UTIL", line 368
ORA-01403: no data found
ORA-06512: at line 1691



Commit complete.

GRANT SELECT ON channels                TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON countries               TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON times                   TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON costs                   TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON customers               TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON products                TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON promotions              TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON sales                   TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON times                   TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON cal_month_sales_mv      TO bi
                *
ERROR at line 1:
ORA-00942: table or view does not exist


GRANT SELECT ON sh.fweek_pscat_sales_mv TO bi
                   *
ERROR at line 1:
ORA-00942: table or view does not exist



Creating views, synonyms for BI ...

TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:15

1 row selected.


specify password for BI as parameter 1:

Connected.

Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Commit complete.

Connected.

PL/SQL procedure successfully completed.

Connected.
BEGIN dbms_aqadm_sys.validate_Queue('IX', 'AQ$_ORDERS_QUEUETABLE_E'); END;

*
ERROR at line 1:
ORA-24010: QUEUE IX.AQ$_ORDERS_QUEUETABLE_E does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383
ORA-06512: at line 1


BEGIN dbms_aqadm_sys.validate_Queue('IX', 'AQ$_STREAMS_QUEUE_TABLE_E'); END;

*
ERROR at line 1:
ORA-24010: QUEUE IX.AQ$_STREAMS_QUEUE_TABLE_E does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383
ORA-06512: at line 1


BEGIN dbms_aqadm_sys.validate_Queue('IX', 'ORDERS_QUEUE'); END;

*
ERROR at line 1:
ORA-24010: QUEUE IX.ORDERS_QUEUE does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383
ORA-06512: at line 1


BEGIN dbms_aqadm_sys.validate_Queue('IX', 'STREAMS_QUEUE'); END;

*
ERROR at line 1:
ORA-24010: QUEUE IX.STREAMS_QUEUE does not exist
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11383
ORA-06512: at line 1



Directory dropped.


Directory dropped.


mkplug.sql DONE

TO_CHAR(SYSTIMEST
-----------------
20190725 04:01:16

1 row selected.

SQL> 
上一篇:探访阿里云--无影云


下一篇:IoT能否上云