Oracle 11g on ECS 测试实践--安装案例-低调大师

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

2019-07-24 763

参考文档：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>

微信关注我们

原文链接：https://yq.aliyun.com/articles/710791

转载内容版权归作者及来源网站所有！

低调大师中文资讯倾力打造互联网数据资讯、行业资源、电子商务、移动互联网、网络营销平台。持续更新报道IT业界、互联网、市场资讯、驱动更新,是最及时权威的产业资讯及硬件资讯报道平台。

阿里云函数计算命令行工具fcli怎么使用？

这里主要介绍如何通fcli命令行来做一个简单的例子，同时把使用过程中碰到的一些注意事项也一一讲解出来。首先，通过阿里云的官网获取到fcli的下载地址(https://github.com/aliyun/fcli/releases)，然后把这个压缩包进行解压，解压之后会生成一个命令行。第一次使用的时候我们来查看一下帮助。这里这个config是初始化和配置帐户信息；function大家可以看下帮助文档(https://help.aliyun.com/document_detail/52995.html)，我们用中间这个shell来进行应用交互。配置的时候，我们要设置accountId(参考获取账号 ID)、AccessKey及AccessSecret（参考创建AccessKey），配置完之后进入到下一个环节。通过命令行工具，我们来创建一个叫做demo的service。需要注意的是，后面建立的函数的操作都是基于service来创建。所以我们要进入到service的空间里，这个地方我们先退到根目录下，创建一个能够上传运行代码的目录。我们创建的是一个random.js函数。我直...

2019-07-25

863

1、使用docker-compose的方式 docker-compose.yml version: '3.1' services: gitlab-ce: image: registry.cn-hangzhou.aliyuncs.com/qfz9527/gitlab-ce-zh:11.1 container_name: gitlab-ce ports: - 80:80 - 443:443 - 222:22 volumes: - /root/gitlab-ce/home/data:/var/opt/gitlab - /root/gitlab-ce/home/logs:/var/log/gitlab - /root/gitlab-ce/home/config:/etc/gitlab restart: always cap_add: - ALL environment: GITLAB_OMNIBUS_CONFIG: | #配置此参数，可以解决在创建项目时，gitlab以容器ID为域名的问题 external_url 'http://192.168.31.109' gitlab_rails['g...

2019-07-25

795

资源下载

更多资源

Mario

马里奥是站在游戏界顶峰的超人气多面角色。马里奥靠吃蘑菇成长，特征是大鼻子、头戴帽子、身穿背带裤，还留着胡子。与他的双胞胎兄弟路易基一起，长年担任任天堂的招牌角色。

Eclipse

Eclipse 是一个开放源代码的、基于Java的可扩展开发平台。就其本身而言，它只是一个框架和一组服务，用于通过插件组件构建开发环境。幸运的是，Eclipse 附带了一个标准的插件集，包括Java开发工具（Java Development Kit，JDK）。

JDK

JDK是 Java 语言的软件开发工具包，主要用于移动设备、嵌入式设备上的java应用程序。JDK是整个java开发的核心，它包含了JAVA的运行环境（JVM+Java系统类库）和JAVA工具。

Sublime Text

Sublime Text具有漂亮的用户界面和强大的功能，例如代码缩略图，Python的插件，代码段等。还可自定义键绑定，菜单和工具栏。Sublime Text 的主要功能包括：拼写检查，书签，完整的 Python API ， Goto 功能，即时项目切换，多选择，多窗口等等。Sublime Text 是一个跨平台的编辑器，同时支持Windows、Linux、Mac OS X等操作系统。