Clone Siebel UCM from Oracle VM

Goal:

1. Clone Siebel UCM Server -- source and target both are Oracle VM.

2. Clone Siebel DB -- source is in Oracle VM, target is in the stand alone DB, not in the Oracle VM.

 

Steps to Clone the Siebel DB:

1. Export data expdp siebel/siebel:

 

CREATE OR REPLACE DIRECTORY expdir AS '/home/oracle/orcl_exp';
GRANT READ,WRITE ON DIRECTORY expdir TO PUBLIC;

 

expdp system/oracle@orcl DUMPFILE=sia_sadmin.dmp DIRECTORY=expdir SCHEMAS=sia,sadmin 

 

2. Create orcl DB instance using dbca on target box.

 

3. Create Tablespaces in the new orcl instance.

CREATE TABLESPACE DATA DATAFILE
  '/u01/app/oracle/oradata/orcl/siebeldata.dbf' SIZE 1000M AUTOEXTEND ON NEXT 20M MAXSIZE UNLIMITED
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

CREATE TABLESPACE SIEBELINDEX DATAFILE
  '/u01/app/oracle/oradata/orcl/siebelindex.dbf' SIZE 1000M AUTOEXTEND ON NEXT 20M MAXSIZE 32767M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;   

 

4. Create roles:

DROP ROLE SSE_ROLE;

CREATE ROLE SSE_ROLE NOT IDENTIFIED;

DROP ROLE TBLO;

CREATE ROLE TBLO NOT IDENTIFIED;

GRANT ADVISOR TO TBLO;
GRANT CREATE TYPE TO TBLO;
GRANT CREATE VIEW TO TBLO;
GRANT CREATE TABLE TO TBLO;
GRANT ALTER SESSION TO TBLO;
GRANT QUERY REWRITE TO TBLO;
GRANT CREATE CLUSTER TO TBLO;
GRANT CREATE SESSION TO TBLO;
GRANT CREATE SYNONYM TO TBLO;
GRANT CREATE TRIGGER TO TBLO;
GRANT CREATE OPERATOR TO TBLO;
GRANT CREATE SEQUENCE TO TBLO;
GRANT CREATE DIMENSION TO TBLO;
GRANT CREATE INDEXTYPE TO TBLO;
GRANT CREATE PROCEDURE TO TBLO;
GRANT ON COMMIT REFRESH TO TBLO;
GRANT CREATE ANY SYNONYM TO TBLO;
GRANT CREATE DATABASE LINK TO TBLO;
GRANT CREATE MATERIALIZED VIEW TO TBLO;
GRANT SELECT_CATALOG_ROLE TO TBLO;
GRANT EXECUTE_CATALOG_ROLE TO TBLO;
GRANT TBLO TO SYS WITH ADMIN OPTION;

  

5. copy the exported data to target box under: /home/oracle/orcl_imp

scp user@source:/home/oracle/orcl_exp/*.* /home/oracle/orcl_imp

 

6. Import data impdp siebel/siebel 

CREATE OR REPLACE DIRECTORY expdir AS '/home/oracle/orcl_imp';
GRANT READ,WRITE ON DIRECTORY expdir TO PUBLIC;

  

impdp system/oracle@orcl DUMPFILE=sia_sadmin.dmp DIRECTORY=expdir SCHEMAS=sia,sadmin

 

Steps to Clone Siebel UCM Server:

Followed by the attachment:

http://dl.iteye.com/topics/download/a54d058f-5e94-38a6-b6cb-5b37a973cd53