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>
