Clone Obiee 12c

Follow these steps:

1) Restore database. 

2) Install OBIEE 12c on new environment.

3) Import a clean state or Empty BAR file.

4) Ensure that all the services are up and running.

5) Export BAR file from existing OBIEE 12c environment.

6) Import the BAR file (of the existing OBIEE 12c environment) into the new OBIEE 12c environment. 

Backup the source database instance -cold backup

Backup on-premise database and Oracle home 

 

-           SQL> show pdbs

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY NO

         3 ORCLPDB                        MOUNTED

         4 PDBOBIEE                       MOUNTED

         5 PDBOBIEE11G                    MOUNTED

         6 PDBOBIEEP12                    MOUNTED

-           SQL> alter pluggable database all close;

 

Pluggable database altered.

 

Transfer Datafiles and Oracle-home backup to Backup folder

[obiee@pan backup]$ ls

dbhome_1.tar.gz  oradata

[obiee@pan backup]$ ls -ltr

total 3549404

-rw-rw-r-- 1 obiee obiee 3634586360 May 12  2019 dbhome_1.tar.gz

drwxr-x--- 3 obiee obiee         18 May 12  2019 oradata

[obiee@pan backup]$

Transfer Datafiles and Oracle-home backup to Oracle OBIEE Cloud server

 

 

[obiee@pan backup]$scp -rp backup obiee@hostname:/DATA

Export BAR file from existing OBIEE 12c environment.

 

Export BI Application Archive file

[obiee@pan bin]$ pwd

/OBIEE/middleware/oracle/oracle_common/common/bin

 [obiee@pan bin]$ ./wlst.sh

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

 

wls:/offline> exportServiceInstance('/OBIEE/middleware/oracle/user_projects/domains/bi12','ssi','/DATA/data_backup12/workDir','/DATA/data_backup12/exportDir')

 

Output  BI Application Archive file

 

[obiee@pan 20190720_150429]$ pwd

/DATA/data_backup12/exportDir/20190720_150429

[obiee@pan 20190720_150429]$ ls

ssi.bar

[obiee@pan 20190720_150429]$

 

Transfer BAR files to Oracle OBIEE Cloud server

[obiee@pan backup]$scp -rp /DATA/data_backup12 obiee@hostname:/OBIEE

 Restore Oracle Home and database on Oracle OBIEE cloud

 Create Directories

 

mkdir -p /DATA/oradb/product/12.2.0

mkdir -p /DATA/oradb/oraInventory

mkdir -p /DATA/oradata/orcl

mkdir -p /DATA/orcl/datafile

vi  /etc/oraInst.loc

inventory_loc=/DATA/oradb/oraInventory

inst_group=dba

Copy Datafiles from backup to /DATA/oradata/orcl and /DATA/orcl/datafile

[obiee@pan backup]$tar -xvzf oradata.tar.gz /Data

[obiee@pan backup]$ tar -xvzf oracl.tar.gz /Data

 

Unzip Oracle Home

[obiee@pan 12.2.0]$ pwd

/DATA/oradb/product/12.2.0

[obiee@pan 12.2.0]$tar -xvzf dbhome_1.tar.gz

Startup database using PFILE

 

[obiee@pan dbs]$ sqlplus / as  sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Aug 2 12:40:03 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> !ls

hc_orcl.dat  init.ora  initorcl.ora  lkORCL  orapworcl  spfileorcl.ora

 

SQL> !pwd

/DATA/oradb/product/12.2.0/dbhome_1/dbs

SQL> startup pfile='/DATA/oradb/product/12.2.0/dbhome_1/dbs/initorcl.ora';

ORACLE instance started.

 

Total System Global Area 1.9663E+10 bytes

Fixed Size                  8802784 bytes

Variable Size            3154120224 bytes

Database Buffers         1.6442E+10 bytes

Redo Buffers               58302464 bytes

Database mounted.

Database opened.

SQL> alter pluggable database all open;

 

Pluggable database altered.

 

SQL> show pdbs

 

    CON_ID CON_NAME                       OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY NO

         3 ORCLPDB                        READ WRITE NO

         4 PDBOBIEE                       READ WRITE NO

         5 PDBOBIEE11G                    READ WRITE NO

         6 PDBOBIEEP12                    READ WRITE NO

SQL>

 

Reload listener

 lsnrctl status LISTENER

Oracle Business Intelligence 12c (12.2.1.3.0) Installation

 

Pre-Requisite

• Oracle Enterprise Edition Database installation
• JDK 8 Update 51 Installation
• Fusion Middleware 12.2.1 Installation
• Following are the series of steps covered in this section
• Download & Unzip OBIEE 12.2.1
• OBIEE 12.2.1 Installation
• Create BI Schemas using RCU utility
• Set Environment Variable for BI
• Create a BI Domain
• Verify Oracle Business Intelligence URL’s
• Start & Stop BI Server

 

 Import the BAR file into the new OBIEE 12c environment.

Import the BAR file (of the existing OBIEE 12c environment) into the new OBIEE 12c environment. 

 

[obiee@pan2 ~]$ . middleware.env

[obiee@pan2~]$ more middleware.env

export MW_HOME=/OBIEE/middleware/oracle

export WLS_HOME=$MW_HOME/wlserver

export WL_HOME=$WLS_HOME

export DOMAIN_HOME=$MW_HOME/user_projects/domains/bi12

# Set to the appropriate JAVA_HOME.

export JAVA_HOME=/OBIEE/JAVA/jdk1.8.0_221

export PATH=$JAVA_HOME/bin:$PATH

[obiee@pan2 ~]$ cd $MW_HOME

[obiee@pan2 oracle]$ cd oracle_common/common/bin

[obiee@pan2 bin]$ ls

[obiee@pan2 bin]$ ./wlst.sh

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

wls:/offline> importServiceInstance('/OBIEE/middleware/oracle/user_projects/domains/bi12','ssi','/OBIEE/importDir/ssi.bar')

 

 Dweblogic.security.allowCryptoJDefaultPRNG=true.>

 

Imported private key demokey.pem and certificate democert.pem

into a new keystore DemoIdentity.jks of type jks under alias demoidentity

[obiee@pan2 bin]

 

Stop OBIEE service and Start

• Obiee clone completed.