Contents
Prerequisite
Grant exempt access policy to user system in order to fix ORA 39181. ( VERY IMPORTANT!).
[oracle@PTUD-SingleSignOn dpdump]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Mon Dec 7 15:07:35 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> GRANT EXEMPT ACCESS POLICY to System;
Grant succeeded.
SQL> commit;
Commit complete.
Download file dump from my google drive:
List of tablespaces
Create all of tablespaces following:
| Name | SQL Create |
| RMS11G_BIPLATFORM | CREATE TABLESPACE "RMS11G_BIPLATFORM" EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO DATAFILE '/u01/app/oracle/oradata/RMS11G_biplatform.dbf' SIZE 64M AUTOEXTEND ON NEXT 16M MAXSIZE 1024M; |
| RMS11G_IAS_TEMP | CREATE TEMPORARY TABLESPACE "RMS11G_IAS_TEMP" EXTENT MANAGEMENT LOCAL TEMPFILE '/u01/app/oracle/oradata/RMS11G_iastemp.dbf' SIZE 100M; |
| RMS11G_IAS_IAU | CREATE TABLESPACE "RMS11G_IAS_IAU" EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO DATAFILE '/u01/app/oracle/oradata/RMS11G_ias_iau.dbf' SIZE 60M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED; |
| RMS11G_MDS | CREATE TABLESPACE "RMS11G_MDS" EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO DATAFILE '/u01/app/oracle/oradata/RMS11G_mds.dbf' SIZE 100M AUTOEXTEND ON NEXT 50M MAXSIZE 1000M; |
List of schemas
Create all of schemas following:
| Name | SQL Create |
| RMS11G_BIPLATFORM | create user "RMS11G_BIPLATFORM" identified by ******* profile "DEFAULT" account unlock default tablespace "RMS11G_BIPLATFORM" temporary tablespace "RMS11G_IAS_TEMP"; grant CREATE SEQUENCE to "RMS11G_BIPLATFORM"; grant UNLIMITED TABLESPACE to "RMS11G_BIPLATFORM"; grant "CONNECT" to "RMS11G_BIPLATFORM"; grant "RESOURCE" to "RMS11G_BIPLATFORM"; grant CREATE VIEW to "RMS11G_BIPLATFORM"; |
| RMS11G_IAU | create user "RMS11G_IAU" identified by ******* profile "DEFAULT" account unlock default tablespace "RMS11G_IAS_IAU" temporary tablespace "RMS11G_IAS_TEMP"; grant UNLIMITED TABLESPACE to "RMS11G_IAU"; grant "CONNECT" to "RMS11G_IAU"; grant "RESOURCE" to "RMS11G_IAU"; |
| RMS11G_IAU_APPEND | create user "RMS11G_IAU_APPEND" identified by ******* profile "DEFAULT" account unlock default tablespace "RMS11G_IAS_IAU" temporary tablespace "RMS11G_IAS_TEMP"; grant "CONNECT" to "RMS11G_IAU_APPEND"; |
| RMS11G_IAU_VIEWER | create user "RMS11G_IAU_VIEWER" identified by ******* profile "DEFAULT" account unlock default tablespace "RMS11G_IAS_IAU" temporary tablespace "RMS11G_IAS_TEMP"; grant "CONNECT" to "RMS11G_IAU_VIEWER"; |
| RMS11G_MDS | create user "RMS11G_MDS" identified by ******* profile "DEFAULT" account unlock default tablespace "RMS11G_MDS" temporary tablespace "RMS11G_IAS_TEMP"; grant CREATE TABLE to "RMS11G_MDS"; grant CREATE SEQUENCE to "RMS11G_MDS"; grant CREATE PROCEDURE to "RMS11G_MDS"; grant "CONNECT" to "RMS11G_MDS"; grant CREATE TYPE to "RMS11G_MDS"; |
List of dump Files
Import data use SQL dump.
| Name | SQL Dump |
| RMS11G_BIPLATFORM.dmp | expdp system/*********@ptud schemas=RMS11G_BIPLATFORM dumpfile=RMS11G_BIPLATFORM.dmp logfile=exRMS11G_BIPLATFORM.log version=11.2.0.4.0 |
| impdp system/******@service_name directory=your_directory dumpfile= RMS11G_BIPLATFORM.dmp logfile= RMS11G_BIPLATFORM.log | |
| RMS11G_IAU.dmp | expdp system/**********@ptud schemas=RMS11G_IAU dumpfile=RMS11G_IAU.dmp logfile=exRMS11G_IAU.log version=11.2.0.4.0 |
| impdp system/******@service_name directory=your_directory dumpfile= RMS11G_IAU.dmp logfile= RMS11G_IAU.log | |
| RMS11G_IAU_APPEND.dmp | expdp system/********@ptud schemas=RMS11G_IAU_APPEND dumpfile=RMS11G_IAU_APPEND.dmp logfile=exRMS11G_IAU_APPEND.log version=11.2.0.4.0 |
| impdp system/******@service_name directory=your_directory dumpfile= RMS11G_IAU_APPEND.dmp logfile= im RMS11G_IAU_APPEND.log | |
| RMS11G_IAU_VIEWER.dmp | expdp system/********@ptud schemas=RMS11G_IAU_VIEWER dumpfile=RMS11G_IAU_VIEWER.dmp logfile=exRMS11G_IAU_VIEWER.log version=11.2.0.4.0 |
| impdp system/******@service_name directory=your_directory dumpfile= RMS11G_IAU_VIEWER.dmp logfile= im RMS11G_IAU_VIEWER.log | |
| RMS11G_MDS.dmp | expdp system/**********@ptud schemas=RMS11G_MDS dumpfile=RMS11G_MDS.dmp logfile=exRMS11G_MDS.log version=11.2.0.4.0 |
| impdp system/******@service_name directory=your_directory dumpfile= RMS11G_MDS.dmp logfile= imRMS11G_MDS.log |
Unlock and set password for schemas:
| Name | SQL Dump |
| RMS11G_BIPLATFORM | Alter user RMS11G_BIPLATFORM account unlock identified by ********; |
| RMS11G_IAU | Alter user RMS11G_IAU account unlock identified by ********; |
| RMS11G_IAU_APPEND | Alter user RMS11G_IAU_APPEND account unlock identified by ********; |
| RMS11G_IAU_VIEWER | Alter user RMS11G_IAU_VIEWER account unlock identified by ********; |
| RMS11G_MDS | Alter user RMS11G_MDS account unlock identified by ********; |
Contact:
Any question feedback thonh15@gmail.com
0 komentar:
Post a Comment