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 Comment to "How to create schemas for BI Publisher 11G without RCU"
Post a Comment