11g OCM考试练习

一、考试准备
      1. 考试中有两个机器，Management Server（Even）和Database Server（Odd），大部分考试在database server上进行，management server上做rman catalog 和 dg的physical standby，口令考试        都有说明.
     2.注意执行root操作的需要sudo,监考老师一般拒绝告诉你用sudo,只说不知道.
      3.设置sqlplus缺省的编辑器
        vi  $ORACLE_HOME/sqlplus/admin/glogin.sql
            define_editor=vi
    4.考试的时候对prod1,prod2库sga设置大一点,memory_target,memory_max_size不要设，因为牵涉到系统共享内存问题
       MEMORY_TARGET not supported on this system

二、考试场景
    1.Database, RMAN, EM and Network Configuration  (90min)
    2.Data Guard (90min)
    3.Data and Data Warehouse Management (145min)
    4.Performance Management (145min)

三、考试内容
[] Configure server-side network
[] Configure client-side network
--- reference Database Net Services Reference

    1.机器名称解析
        sudo vi /etc/hosts  -- 加入目标机器名称解析

    2.vi  $ORACLE_HOME/network/admin/tnsnames.ora
emrep = (description =
        (address_list =
           (address = (host=odd.oracle.com)(port=1521)(protocol=tcp))
    (connect_data =
        (server=dedicated)(service_name=emrep.oracle.com)
     )
)  )
    3.vi $OR    ACLE_HOME/network/admin/listener.ora
sid_list_listener = (sid_list =
                       (sid_desc =
                          (global_dbname=prod1)
                          (oracle_home=/u01/app/oracle/product/11.2.0/db_1)
                          (sid_name=prod1)
                      ))
        
[] Create and Manage encrypted tablespace (ignore it since it's no tested)
-- reference Administrator's Guide

     vi $ORACLE_HOME/network/admin/sqlnet.ora

WALLET_LOCATION=
  (SOURCE=
    (METHOD=file)
    (METHOD_DATA=
       (DIRECTORY=/home/oracle/mywallet))

sqlplus / as sysdba
alter system set encryption key authenticated by "welcome1";
create tablespace securespace datafile '+DATA' size 10M encryption default storage(encrypt);

create table t1 (id varchar(20)) tablespace securespace;
insert into t1 values('wanggang');
commit;

select * from t1;
ID
--------------------
wanggang

alter system set wallet close identified by "welcome1";

select * from t1;
ERROR at line 1:
ORA-28365: wallet is not open