updated

listener.ora

listener=(description=(address_list=(address=(protocol=tcp)(port=1521)(host=ocm.localdomain)))

listener1=(description=(address_list=(address=(protocol=tcp)(port=1421)(host=ocm.localdomain)))

sid_list_listener=(sid_list=(sid_desc=(global_dbname=ocm)(oracle_home=xxx)(sid_name=ocm)))

tnsnams.ora

listener1=(description=(address_list=(address=(protocol=tcp)(port=1421)(host=ocm.localdomain)))

ocm1=(description=(load_balance=on)
                                     (address_list=(address=(protocol=tcp)(port=1421)(host=ocm.localdomain))
                                     (connect_data=(service_name=ocm))
                                     (failover_mode=(type=session/select/none)(mode=preconnect/basic)(retries=10)(delay=10)))

 

alter system set local_listener='listener1' scope=spfile;

 

alter system set utl_file_dir='xxxx','xxxx' scope=spfile; just like the db_file_name_convert

alter tablespace undotbs retention noguarantee;

 

exec dbms_fga.add_policy(OBJECT_SCHEMA=>'ORACLE',OBJECT_NAME=>'AUDIT_T',POLICY_NAME=>'POL1',AUDIT_CONDITION=>'name is not null or depname is not null' ,AUDIT_COLUMN => 'name,depname',AUDIT_TRAIL=>dbms_fga.db+dbms_fga.extended);

 

 exec dbms_stats.gather_table_stats(OWNNAME=>'ORACLE',tabname=>'PART_T' ,method_opt=> 'FOR  COLUMNS SIZE skewonly owner');
http://space.itpub.net/15415488/viewspace-591765

 

  create index part_compress_index on part_t (object_name ,owner,object_id )global partition by hash(object_name ) partitions 4 store in (tools) compress 1;