Oracle 11g on ECS 测试实践--安装案例-阿里云开发者社区

开发者社区> 警长是只猫> 正文

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

简介: 参考文档:MOS Doc ID 472408.1基于 AMERICAN_AMERICA.US7ASCII 字符集 [oracle@orcl1 schema]$ cd /u01/app/oracle/product/11.
+关注继续查看

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

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
Linux下安装Oracle参数自动初始化脚本
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/zergskj/article/details/6303413 在linux下安装Oracle通常是一件很头疼的事情,   而如果我们只是为了部署CMS的话,也没有必要对Oracle的参数去做详细的了解。
800 0
PHPMailer安装及简单实例(PHP发送邮件不用Smtp类)
PHPMailer安装及简单实例 [ 2006-11-29 14:37:49 | Author: songzi ] Font Size: Large | Medium | Small PHPMailer是一个用PHP写的用于邮件发送的类,有点像Jmail,相信很多新手和我一样,开始很茫然,不知道怎么安装,查找了一下,发现这方面的资料真的少之又少,一个文章被转载千百次,一搜索全是同一个内容,真不知道说什么好,其实打开安装里的readme就一目了然了,闲话少说,安装其实很简单。
1307 0
阿里云服务器怎么设置密码?怎么停机?怎么重启服务器?
如果在创建实例时没有设置密码,或者密码丢失,您可以在控制台上重新设置实例的登录密码。本文仅描述如何在 ECS 管理控制台上修改实例登录密码。
10093 0
阿里云服务器如何登录?阿里云服务器的三种登录方法
购买阿里云ECS云服务器后如何登录?场景不同,大概有三种登录方式:
2963 0
在 Windows 7 Professional、Enterprise 或 Ultimate 上安装 IIS 7.5
原文 在 Windows 7 Professional、Enterprise 或 Ultimate 上安装 IIS 7.5 应用到: Windows Server 2008 R2 默认情况下,Windows(R) 7 Professional、Enterprise 或 Windows(R) 7 Ultimate 上不安装 IIS 7.5。
984 0
Ubuntu 系统实例 Apt-get 安装软件及问题处理
本文介绍主要介绍 Ubuntu 系统的实例 Apt-get 在线安装软件使用方法及常见问题处理。
972 0
阿里云服务器如何登录?阿里云服务器的三种登录方法
购买阿里云ECS云服务器后如何登录?场景不同,阿里云优惠总结大概有三种登录方式: 登录到ECS云服务器控制台 在ECS云服务器控制台用户可以更改密码、更换系.
13893 0
MySQL 多实例的安装
MySQL 多实例的安装Step 1 . 准备工作关闭防火墙; 安装 MySQL依赖于libaio 库;下载,解压,重命名 MySQL的执行文件;新建用户组和用户 等准备工作在此不再赘述。 可执行文件目录为 /data/mysql57 添加用户和组的指令 groupadd mysql useradd mysql -g mysql Step 2 . 添加环境变量在/etc/profile文件中,追加 PATH=${PATH}:/data/mysql57/bin/ 保存后,如需要立即生效,可执行 source /etc/profile 。
1348 0
+关注
警长是只猫
野生DBA
3
文章
0
问答
文章排行榜
最热
最新
相关电子书
更多
《2021云上架构与运维峰会演讲合集》
立即下载
《零基础CSS入门教程》
立即下载
《零基础HTML入门教程》
立即下载