Cloning: Oracle EBS R12.2.7 with Oracle Database 19c when TDE encryption is enabled.

 


DB Node on Source:

[oraprod@prderpdb ~]$ cd /oraprod/oracle/db/19.3.0/

[oraprod@prderpdb 19.3.0]$ . PRODCDB_prderpdb.env

[oraprod@prderpdb 19.3.0]$ cd /oraprod/oracle/db/19.3.0/appsutil/etcc/

[oraprod@prderpdb etcc]$ ./checkDBpatch.sh

Open new terminal and perform below steps

[oraprod@prderpdb ~]$ cd /oraprod/oracle/db/19.3.0/

[oraprod@prderpdb 19.3.0]$ . PROD_prderpdb.env

[oraprod@prderpdb etcc]$ cd /oraprod/oracle/db/19.3.0/appsutil/scripts/PROD_prderpdb

[oraprod@prderpdb PROD_prderpdb]$ perl adpreclone.pl dbTier

[oraprod@prderpdb PROD_prderpdb]$ cd /oraprod/oracle/db

[oraprod@prderpdb db]$ tar cvf 19.3.0.tar 19.3.0

[oraprod@prderpdb db]$ scp 19.3.0.tar oraprod@172.16.2.203:/oraprod/oracle/db/

[oraprod@prderpdb PROD_prderpdb]$ cd /backup/rman/

[oraprod@prderpdb rman]$ scp -r full_14_04_2024_04_00_AM oraprod@172.16.2.203:/backup/rman

Configure Oracle Home on the target database node:

Note:Before running adcfgclone.pl to configure $Oracle_Home, clean up the oraInventory directory.

a)    Create pairsfile.txt File (I am not doing this)

b)   Create the DB context file:

[oraprod@deverpdb02 19.3.0]$ echo $ORACLE_HOME

[oraprod@deverpdb02 19.3.0]$ export ORACLE_HOME=/oraprod/oracle/db/19.3.0

[oraprod@deverpdb02 19.3.0]$ cd $ORACLE_HOME/appsutil/clone/bin

[oraprod@deverpdb02 bin]$ perl adclonectx.pl contextfile=/oraprod/oracle/db/19.3.0/appsutil/PROD_prderpdb.xml template=/oraprod/oracle/db/19.3.0/appsutil/template/adxdbctx.tmp

Configure the database technology stack or Oracle Home on target

Note: you have to Install pre-requisites RPM and check other pre-requisites as per below Doc ID:

1.       Refer Doc ID 2203053.1 and make sure all pre requisites are performed

2.       Install pre requisite rpms.

-       Login to any server upg1, upg2, upg3  then copy the rpm and install it.

-       you can copy the rpm( oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm )from UPG1 or upg2 or upg3 from the location ( /etc/yum.repos.d/new_repo_download ) and install it by using the below command

[root@deverpdb01 ~]# cd /etc/yum.repos.d/new_repo_download

[root@deverpdb01 ~]# scp –r new_repo_download root@172.16.2.134:/etc/yum.repos.d/

[root@deverpdb02 new_repo_download]# cd /etc/yum.repos.d/new_repo_download

[root@deverpdb02 new_repo_download]# rpm -ivh oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

[root@deverpdb02 new_repo_download]# rpm -q oracle-database-preinstall-19c

[oraprod@deverpdb02 ~]$ export ORACLE_HOME=/oraprod/oracle/db/19.3.0

[oraprod@deverpdb02 ~]$ export PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/bin:$PATH

[oraprod@deverpdb02 ~]$ cd /oraprod/oracle/db/19.3.0/appsutil/clone/bin/

$ perl adcfgclone.pl dbTechStack <Complete path to the target context file>   à Syntax

[oraprod@deverpdb02 bin]$ perl adcfgclone.pl dbTechStack /oraprod/oracle/db/19.3.0/appsutil/clone/bin/DEV_deverpdb02.xml

Create listener.ora and tnsnames.ora files:

-       Set below before running

 

[oraprod@upgdb03 19.3.0]$ export ORACLE_HOME=/oraprod/oracle/db/19.3.0

[oraprod@upgdb03 19.3.0]$ export PATH=$ORACLE_HOME/perl/bin:$ORACLE_HOME/bin:$PATH

[oraprod@upgdb03 19.3.0]$ export LD_LIBRARY_PATH=$ORACLE_HOME:$ORACLE_HOME/lib

[oraprod@upgdb03 19.3.0]$ export PERL5LIB=$ORACLE_HOME/perl/lib/5.28.1:$ORACLE_HOME/perl/site_perl/5.28.1:$ORACLE_HOME/appsutil/perl

[oraprod@upgdb03 19.3.0]$ export PATH=$ORACLE_HOME/perl:$ORACLE_HOME/perl/lib:$ORACLE_HOME/perl/bin:$PATH

[oraprod@upgdb03 19.3.0]$

[oraprod@upgdb03 appsutil]$ . txkSetCfgCDB.env -dboraclehome=/oraprod/oracle/db/19.3.0

[oraprod@upgdb03 appsutil]$ cd bin

[oraprod@upgdb03 bin]$ pwd

/oraprod/oracle/db/19.3.0/appsutil/bin

[oraprod@upgdb03 bin]$ perl txkGenCDBTnsAdmin.pl -dboraclehome=/oraprod/oracle/db/19.3.0 -cdbname=UPGCDB -cdbsid=UPGCDB -dbport=1521 -outdir=$ORACLE_HOME/appsutil/log israc=no

 

 Start the listener.

[oraprod@upgdb03 bin]$ cd /oraprod/oracle/db/19.3.0/appsutil/scripts/UPG_upgdb03/

-          Create the directory UPG_upgdb03 if it doesn’t exist.

[oraprod@upgdb03 UPG_upgdb03]$ ./addlnctl.sh start UPGCDB

[oraprod@upgdb03 UPG_upgdb03]$ ./adcdblnctl.sh start UPGCDB (after above line no need for this)

[oraprod@upgdb03 UPG_upgdb03]$ lsnrctl status UPGCDB

 

-          Now copy the source cdb pfile and use it for target

 

[oraprod@upgdb03 UPG_upgdb03]$ cd /oraprod/oracle/db/19.3.0/dbs/

[oraprod@upgdb03 dbs]$ cp initPRODCDB.ora initUPGCDB.ora

 

Edit initUPGCDB.ora:

 

-          Edit below values as

 

*.local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=upgdb03.sipa.local)(PORT=1521)))'


*.db_name='UPGCDB'

 

-          Replace prodcdb with upgcdb, and PRODCDB with UPGCDB

 

Create the needed directory to match the path of audit_file_dest parameter of initUPGCDB.ora

[oraprod@upgdb03 full_21_04_2024_04_00_AM]$ cd /oraprod/oracle/

[oraprod@upgdb03 oracle]$ mkdir -p admin

[oraprod@upgdb03 oracle]$ cd admin

[oraprod@upgdb03 admin]$ mkdir -p UPGCDB

[oraprod@upgdb03 admin]$ cd UPGCDB

[oraprod@upgdb03 UPGCDB]$ mkdir -p adump

[oraprod@upgdb03 UPGCDB]$ cd adump

[oraprod@upgdb03 adump]$ pwd

/oraprod/oracle/admin/UPGCDB/adump

 

Start the target database in a nomount state and run the following RMAN command to restore the database:

[oraprod@upgdb03 19.3.0]$ cd $ORACLE_HOME

[oraprod@upgdb03 19.3.0]$ . UPGCDB_upgdb03.env

[oraprod@upgdb03 19.3.0]$ cd /backup/rman/full_21_04_2024_04_00_AM/

[oraprod@upgdb03 full_21_04_2024_04_00_AM]$ sqlplus '/as sysdba'

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Apr 22 09:28:33 2024

Version 19.21.0.0.0

 

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

 

Connected to an idle instance.

SQL> startup nomount pfile='/oraprod/oracle/db/19.3.0/dbs/initUPGCDB.ora'

SQL> exit;

Note: if you face below errors then for solution check Issue 15 and Issue 16 in “Known Issues” document.

[oraprod@upgdb03 ~]$ cd /backup/rman/full_21_04_2024_04_00_AM/

[oraprod@upgdb03 full_21_04_2024_04_00_AM]$ rman auxiliary /

RMAN>

RMAN> exit

[oraprod@upgdb03 full_19_04_2024_04_00_AM]$ rman log=rman_dup.log

RMAN> connect auxiliary /

RMAN> run {

ALLOCATE AUXILIARY CHANNEL a1 DEVICE TYPE DISK;

ALLOCATE AUXILIARY CHANNEL a2 DEVICE TYPE DISK;

ALLOCATE AUXILIARY CHANNEL a3 DEVICE TYPE DISK;

ALLOCATE AUXILIARY CHANNEL a4 DEVICE TYPE DISK;

ALLOCATE AUXILIARY CHANNEL a5 DEVICE TYPE DISK;

ALLOCATE AUXILIARY CHANNEL a6 DEVICE TYPE DISK;

DUPLICATE DATABASE TO DEVCDB BACKUP LOCATION ’/backup/rman/full_01_09_2024_04_00_AM/’ NOFILENAMECHECK;

}

-          Start the new target CDB in open mode

 

[oraprod@upgdb03 full_21_04_2024_04_00_AM]$ sqlplus / as sysdba

SQL> select name,open_mode from v$database;

 

NAME      OPEN_MODE

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

UPGCDB    READ WRITE

 

SQL> show pdbs

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PROD                           READ WRITE NO

SQL>

 

Target PDB Steps:

[oraprod@upgdb03 full_21_04_2024_04_00_AM]$ export ORACLE_SID=UPGCDB

Create a folder “/opt/cakm” in target

-          Install CAKM using oraprod user from location /opt/cakm/

[root@deverpdb02 encryption_thalas]# mkdir /opt/cakm

[root@deverpdb02 encryption_thalas]# chown -R oraprod:dba /opt/cakm/

[root@deverpdb02 encryption_thalas]# chmod 755 /opt/cakm/

-          Copy CAKM_for_Oracle_TDE-8.13.0.002-Linux.tar from /home/oraprod/encryption/ to target /opt/cakm

-          [root@deverpdb02 cakm]# cd /home/oraprod/encryption/

-          [root@deverpdb02 encryption]# scp -r CAKM_for_Oracle_TDE-8.13.0.002-Linux.tar root@172.16.2.203:/opt/cakm/

-          [root@upgdb03 cakm]# chown -R orapro:dba /opt/cakm/CAKM_for_Oracle_TDE-8.13.0.002-Linux.tar

-          [root@upgdb03 cakm]# chown -R oraprod:dba CAKM_for_Oracle_TDE-8.13.0.002

-          [root@upgdb03 cakm]# ls -lrt

-          total 23272

-          -rwxr-xr-x 1 oracle  dba 23828480 Oct 27 14:45 CAKM_for_Oracle_TDE-8.13.0.002-Linux.tar

-          drwxr-xr-x 4 oraprod dba      119 Oct 27 15:21 CAKM_for_Oracle_TDE-8.13.0.002

-          [root@upgdb03 CAKM_for_Oracle_TDE-8.13.0.002]# su – oraprod

-          [oraprod@upgdb03 ~]$ cd /opt/cakm

-          [oraprod@upgdb03 cakm]$ cd CAKM_for_Oracle_TDE-8.13.0.002/

-          [oraprod@upgdb03 CAKM_for_Oracle_TDE-8.13.0.002]$ ./install.sh

-          [oraprod@upgdb03 cakm]$ cd CAKM_for_Oracle_TDE-8.13.0.002/

-          [oraprod@upgdb03 CAKM_for_Oracle_TDE-8.13.0.002]$ ./install.sh

Do you accept the terms of the End User License Agreement(Y/N)[N]? Y

Install CAKM for Oracle TDE to path [/home/oraprod]:

Key Management Server IP Address: 172.16.0.23

Key Management Server PORT [9000]:

Key Management Server Protocol (ssl/tcp)[ssl]:

Key Management Server username: oracletde

Key Management Server user password: 0r@c!eTd3#87Li&

Enter Passphrase to protect private key: 0r@c!eTd3#87Li&

Country code (2 letter code e.g., US): SA

State or Province name (e.g., California): Riyadh

Locality or city name (e.g., San Jose): Riyadh

Organization name (e.g., company): MODON

Organization Unit name (e.g., Section): IT

Common Name (eg, your name or your server's hostname): oracletde

Email Address (optional):

CAKM for Oracle TDE Installation is completed!

 

   You can edit the configuration files located at:

   /home/oraprod/CipherTrust/CAKM_for_Oracle_TDE/CADP_PKCS11.properties

[oraprod@upgdb03 CAKM_for_Oracle_TDE-8.13.0.002]$

Eidt the above file and change some parameter values in it as shown below:

[oraprod@upgdb03 CAKM_for_Oracle_TDE-8.13.0.002]$ vi /home/oraprod/CipherTrust/CAKM_for_Oracle_TDE/CADP_PKCS11.properties

[oraprod@upgdb03 CAKM_for_Oracle_TDE-8.13.0.002]$ cd

-cross check the path of NAE_properties_conf_filename parameter path in the .bash_profile

[oraprod@upgdb03 ~]$ . .bash_profile

[oraprod@upgdb03 extapi]$ su root

Password:

[root@upgdb03 extapi]# cd /opt

[root@upgdb03 opt]# mkdir -p /opt/oracle/extapi/64/hsm/CipherTrust/CAKM_for_Oracle_TDE

[root@upgdb03 opt]# chown -R oraprod:dba /opt/oracle/extapi/64/hsm/CipherTrust/CAKM_for_Oracle_TDE

[root@upgdb03 CAKM_for_Oracle_TDE]# ls -l

total 0

lrwxrwxrwx 1 oraprod dba 65 May 15 11:51 libcadp_pkcs11.so -> /opt/CipherTrust/CAKM_for_Oracle_TDE/libcadp_pkcs11.so-8.13.0.002

[root@upgdb03 CAKM_for_Oracle_TDE]# rm -rf libcadp_pkcs11.so

[root@upgdb03 CAKM_for_Oracle_TDE]# pwd

/opt/oracle/extapi/64/hsm/CipherTrust/CAKM_for_Oracle_TDE

[root@upgdb03 CAKM_for_Oracle_TDE]# ln -s /home/oraprod/CipherTrust/CAKM_for_Oracle_TDE/libcadp_pkcs11.so-8.13.0.002 libcadp_pkcs11.so

[root@upgdb03 CAKM_for_Oracle_TDE]# ls -l

total 0

lrwxrwxrwx 1 root root 74 Nov 12 13:52 libcadp_pkcs11.so -> /home/oraprod/CipherTrust/CAKM_for_Oracle_TDE/libcadp_pkcs11.so-8.13.0.002

[root@upgdb03 CAKM_for_Oracle_TDE]# chown -R oraprod:dba /opt/oracle/extapi/

 [root@upgdb03 CAKM_for_Oracle_TDE]# su - oraprod

[oraprod@upgdb03 CAKM_for_Oracle_TDE]$

[oraprod@upgdb03 opt]$ cd /oraprod/oracle/db/19.3.0/

[oraprod@upgdb03 19.3.0]$ . UPGCDB_upgdb03.env

[oraprod@upgdb03 19.3.0]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Oct 28 11:03:01 2024

Version 19.21.0.0.0

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

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.21.0.0.0

SQL>startup;

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PROD                           READ WRITE NO

SQL> show parameter tde_configuration

NAME                                 TYPE        VALUE

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

tde_configuration                    string      KEYSTORE_CONFIGURATION=FILE

SQL> ALTER SYSTEM SET TDE_CONFIGURATION="KEYSTORE_CONFIGURATION=HSM" scope=both;

System altered.

SQL> show parameter wallet_root

NAME                                 TYPE        VALUE

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

wallet_root                          string      /home/oraprod/wallet

SQL> shut immediate;

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PROD                           MOUNTED

SQL> alter pluggable database PROD open;

Pluggable database altered.

SQL> show parameter tde_configuration

NAME                                 TYPE        VALUE

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

tde_configuration                    string      KEYSTORE_CONFIGURATION=HSM

SQL> show parameter wallet_root

NAME                                 TYPE        VALUE

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

wallet_root                          string      /home/oraprod/wallet

SQL> COLUMN WRL_PARAMETER FORMAT A50;

SQL> SET LINES 200;

SQL> SELECT WRL_TYPE, WRL_PARAMETER, WALLET_TYPE, STATUS FROM V$ENCRYPTION_WALLET;

 

 

WRL_TYPE             WRL_PARAMETER                                      WALLET_TYPE          STATUS

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

HSM                                                                     UNKNOWN              CLOSED

HSM                                                                     UNKNOWN              CLOSED

HSM                                                                     UNKNOWN              CLOSED

 

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "oracletde:0r@c!eTd3#87Li&" container=all;

 

keystore altered.

SQL>

SQL> SELECT WRL_TYPE, WRL_PARAMETER, WALLET_TYPE, STATUS FROM V$ENCRYPTION_WALLET;

 

WRL_TYPE             WRL_PARAMETER                                      WALLET_TYPE          STATUS

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

HSM                                                                     HSM                  OPEN

HSM                                                                     HSM                  OPEN

HSM                                                                     HSM                  OPEN

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

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PROD                           READ WRITE NO

SQL> alter session set container=PROD;

SQL> exit;

[oraprod@upgdb03 19.3.0]$ sqlplus / as sysdba

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PROD                           READ WRITE NO

SQL> show parameter tde_conf

NAME                                 TYPE        VALUE

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

tde_configuration                    string      KEYSTORE_CONFIGURATION=HSM

SQL> ALTER SYSTEM SET TDE_CONFIGURATION="KEYSTORE_CONFIGURATION=FILE" scope=both;

SQL> shut immediate;

SQL> startup;

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PROD                           READ WRITE NO

SQL>

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PROD                           MOUNTED

SQL> alter pluggable database PROD open;

Pluggable database altered.

SQL> show parameter tde_configuration

NAME                                 TYPE        VALUE

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

tde_configuration                    string      KEYSTORE_CONFIGURATION=FILE

SQL> SELECT WRL_TYPE, WRL_PARAMETER, WALLET_TYPE, STATUS FROM V$ENCRYPTION_WALLET;

WRL_TYPE

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

WRL_PARAMETER

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

WALLET_TYPE          STATUS

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

FILE

/home/oraprod/wallet/tde/

UNKNOWN              NOT_AVAILABLE

 

HSM

 

UNKNOWN              CLOSED

 

WRL_TYPE

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

WRL_PARAMETER

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

WALLET_TYPE          STATUS

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

 

FILE

 

UNKNOWN              NOT_AVAILABLE

 

FILE

 

 

WRL_TYPE

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

WRL_PARAMETER

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

WALLET_TYPE          STATUS

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

UNKNOWN              NOT_AVAILABLE

 

HSM

 

UNKNOWN              CLOSED

SQL> exit;

 [oraprod@upgdb03 19.3.0]$ cp /home/oraprod/wallet/tde/YouCanDelThisFilesAfterEnc/ewallet.p12 /home/oraprod/wallet/tde

[oraprod@upgdb03 19.3.0]$ sqlplus / as sysdba

SQL> column WRL_PARAMETER FORMAT A50;

SQL> SET LINES 200;

SQL> SELECT WRL_TYPE,WRL_PARAMETER,WALLET_TYPE,STATUS FROM V$ENCRYPTION_WALLET;

 

WRL_TYPE             WRL_PARAMETER                                      WALLET_TYPE          STATUS

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

FILE                 /home/oraprod/wallet/tde/                          UNKNOWN              CLOSED

HSM                                                                     UNKNOWN              CLOSED

FILE                                                                    UNKNOWN              CLOSED

FILE                                                                    UNKNOWN              CLOSED

HSM                                                                     UNKNOWN              CLOSED

 

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "0r@c!eTd3#87Li&" container=all;

keystore altered.

SQL> SELECT WRL_TYPE,WRL_PARAMETER,WALLET_TYPE,STATUS FROM V$ENCRYPTION_WALLET;

WRL_TYPE             WRL_PARAMETER                                      WALLET_TYPE          STATUS

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

FILE                 /home/oraprod/wallet/tde/                          PASSWORD             OPEN

HSM                                                                     HSM                  OPEN

FILE                                                                    PASSWORD             OPEN

FILE                                                                    PASSWORD             OPEN

HSM                                                                     HSM                  OPEN

 

SQL>

SQL> alter session set container=PROD;

SQL> ADMINISTER KEY MANAGEMENT EXPORT ENCRYPTION KEYS WITH SECRET "0r@c!eTd3#87Li&" TO '/home/oraprod/wallet/export_prodpdb27nov_cakm.exp' IDENTIFIED BY "0r@c!eTd3#87Li&";

SQL> exit;

[oraprod@upgdb03 19.3.0]$ sqlplus / as sysdba

SQL> show pdbs

 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PROD                           READ WRITE NO

SQL> alter pluggable database PROD close;

Pluggable database altered.

SQL> alter pluggable database "PROD" unplug into '/oraprod/oracle/db/19.3.0/dbs/PROD.xml';

SQL> drop pluggable database "PROD";

SQL> create pluggable database "DEV" using '/oraprod/oracle/db/19.3.0/dbs/PROD.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_PROD','ebs_DEV','PROD_ebs_patch','DEV_ebs_patch');

SQL> alter pluggable database "DEV" open read write;

Warning: PDB altered with errors.

SQL>

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         4 DEV                            READ WRITE YES

SQL> col name for a20

SQL> col cause for a20

SQL> col type for a15

SQL> col message for a60

SQL> col status for a15

SQL> set lines 500

SQL> select name, cause, type, message, status from pdb_plug_in_violations where type = 'ERROR' and status != 'RESOLVED' order by name, time;

 

NAME                 CAUSE                TYPE            MESSAGE                                                      STATUS

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

DEV                  Wallet Key Needed    ERROR           PDB needs to import keys from source.                        PENDING

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                                 READ ONLY    NO

         4 DEV                                            READ WRITE  YES

SQL> column WRL_PARAMETER FORMAT A50;

SQL> set lines 200;

SQL> SELECT WRL_TYPE,WRL_PARAMETER,WALLET_TYPE,STATUS FROM V$ENCRYPTION_WALLET;

WRL_TYPE             WRL_PARAMETER                                      WALLET_TYPE          STATUS

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

FILE                 /home/oraprod/wallet/tde/                          PASSWORD                 OPEN

HSM                                                                                               HSM                             OPEN

FILE                                                                                                 PASSWORD                OPEN

FILE                                                                                                 UNKNOWN                 CLOSED

HSM                                                                                             UNKNOWN                 CLOSED

 

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "0r@c!eTd3#87Li&" container=all;

keystore altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                                 READ ONLY    NO

         4 DEV                                            READ WRITE  YES

SQL> alter session set container=DEV;

Session altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         4 DEV                                             READ WRITE  YES

SQL> ADMINISTER KEY MANAGEMENT IMPORT KEYS WITH SECRET "0r@c!eTd3#87Li&" FROM '/home/oraprod/wallet/export_prodpdb27nov_cakm.exp' IDENTIFIED BY "0r@c!eTd3#87Li&" WITH BACKUP;

keystore altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         4 DEV                                             READ WRITE  YES

-          Bounce the DB to reflect the changes.

SQL> shut immediate;

Pluggable Database closed.

SQL> startup;

Pluggable Database opened.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         4 DEV                                             READ WRITE  NO

SQL> exit;

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.21.0.0.0

[oraprod@upgdb03 19.3.0]$ sqlplus / as sysdba

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         4 DEV                            READ WRITE NO

[oraprod@deverpdb02 19.3.0]$ . DEVCDB_deverpdb02.env

[oraprod@deverpdb02 19.3.0]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 15 02:37:44 2024

Version 19.21.0.0.0

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

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.21.0.0.0

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         4 DEV                            READ WRITE NO

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> alter pluggable database all save state instances=all;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         4 DEV                            READ WRITE NO

SQL>

 [oraprod@upgdb03 19.3.0]$ . UPG_upgdb03.env

[oraprod@upgdb03 19.3.0]$ cd appsutil/clone/bin/

[oraprod@upgdb03 bin]$ perl adcfgclone.pl dbconfig /oraprod/oracle/db/19.3.0/appsutil/UPG_upgdb03.xml

 

Configure Target Application Node

App Node on Target

 [applprod@prderpapp oracle]$ cd $ADMIN_SCRIPTS_HOME

[applprod@prderpapp scripts]$ perl adcfgclone.pl appsTier dualfs

 

Enter the APPS password :

 

Enter the Weblogic AdminServer password :

 

Do you want to add a node (yes/no) [no] :

 

 

Running: Context clone...

 

Log file located at /applprod/oracle/fs1/EBSapps/comn/clone/bin/CloneContext_0119102158.log

 

Provide the values required for creation of the new APPL_TOP Context file.

 

Target System Hostname (virtual or normal) [upgapp03] :

 

Target System Database SID : UPG

 

Target System Database Server Node [upgapp03] : upgdb03

 

Target System Database Domain Name [sipa.local] :

 

Target System Base Directory : /applprod/oracle

 

Target System Base Directory set to /applprod/oracle

 

Target System Current File System Base set to /applprod/oracle/fs1

 

Target System Other File System Base set to /applprod/oracle/fs2

 

Target System Fusion Middleware Home set to /applprod/oracle/fs1/FMW_Home

Target System Other File System Fusion Middleware Home set to /applprod/oracle/fs2/FMW_Home

 

Target System Web Oracle Home set to /applprod/oracle/fs1/FMW_Home/webtier

Target System Other File System Web Oracle Home set to /applprod/oracle/fs2/FMW_Home/webtier

 

Target System Appl TOP set to /applprod/oracle/fs1/EBSapps/appl

Target System Other File System Appl TOP set to /applprod/oracle/fs2/EBSapps/appl

 

Target System COMMON TOP set to /applprod/oracle/fs1/EBSapps/comn

Target System Other File System COMMON TOP set to /applprod/oracle/fs2/EBSapps/comn

 

Target System Instance Home Directory [/applprod/oracle] :

 

Target System Current File System Instance Top set to /applprod/oracle/fs1/inst/apps/UPG_upgapp03

 

Do you want to preserve the Display [prderpapp:0.0] (y/n)  : n

 

Target System Display [upgapp03:0.0] :

 

Target System Root Service [enabled] :

 

Target System Web Entry Point Services [enabled] :

 

Target System Web Application Services [enabled] :

 

Target System Batch Processing Services [enabled] :

 

Target System Other Services [disabled] :

 

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

 

Target System Port Pool [0-99] : 0

 

Checking the port pool 0

done: Port Pool 0 is free

Report file located at /applprod/oracle/fs1/inst/apps/UPG_upgapp03/admin/out/portpool.lst

 

Target System proxy port [80] :

 

EBS_APPLPTMP consists of below directory.

1. /oraprod/oracle/db/temp/UPG

Choose a value which will be set as APPLPTMP on the target node [1] :

The new APPL_TOP context file has been created :

  /applprod/oracle/fs1/inst/apps/UPG_upgapp03/appl/admin/UPG_upgapp03.xml

Check Clone Context logfile /applprod/oracle/fs1/EBSapps/comn/clone/bin/CloneContext_0119102158.log for details.

 

Creating Patch file system context file.....

 

Log file located at /applprod/oracle/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0119102318.log

 

Target System Other File System Instance Top set to /applprod/oracle/fs2/inst/apps/UPG_upgapp03

 

Target System Port Pool [0-99] : 1


Comments

Post a Comment

Popular posts from this blog

adop phase=prepare failed with error "data dictionary corrupted"

  After fresh clone when I run adop phase=prepare then prepare phase failed with the error "data dictionary corrupted". Solution: Follow the instructions in the "Fix data dictionary corruption" section of My Oracle Support Knowledge Document 1531121.1 . *  Fix Data Dictionary Corruption ( Conditional ) Copy the script $AD_TOP/patch/115/sql/adzddmpfix.sql to the database tier. On the database tier, connect to the database as SYSDBA. Run the $AD_TOP/patch/115/sql/adzddmpfix.sql script. [oraprod@deverpdb01 12.1.0]$ sqlplus / as sysdba SQL> @adzddmpfix.sql On the application tier, run the $AD_TOP/sql/ADZDDBCC.sql script again to identify whether data dictionary corruption is still present. [applprod@deverpapp01 sql]$ cd $AD_TOP/sql [applprod@deverpapp01 sql]$ sqlplus apps @ADZDDBCC.sql a.     If no corruption is found, proceed with the upgrade or patching cycle. b.   ...
Read more

upgrade the AD/TXK Delta Patch to 14 in Oracle EBS R12.2.7

Image
  Environment: - Multi-node Applications (1 Internal Node & 1 External Node)    - Single Database Node - Version: Oracle EBS R12.2.7 and Database 19c ----------------------------------------------------------------------------------------------------------- We have to upgrade the AD/TXK level to 14. Follow the read me of AD patch 33600809 and perform all the steps as per read me and apply the patch using ADOP - Usually there will be only 2 patches to be applied to upgrade to AD/TXK. i.e. one patch for AD and another patch for TXK. But, in our environment we have Arabic Language enabled so I have to apply the AD/TXK patches for Arabic also. But, if no additional language is installed then you have to apply only English language patches which is the default. Below are the 4 patches which I have downloaded for English and Arabic If you have only English language in your setup then you have to download and install the below 2 patches only. 33600809:u33600809.drv  ...
Read more

Apply Latest CPU Patch of April 2024 on Oracle EBS R12.2.7 Application and Database 19c

Image
  Ref: Oracle E-Business Suite Release 12.2 Critical Patch Update Availability Document (April 2024) (Doc ID 3007752.1) As mentioned in the above document, before applying the Latest CPU patch we need to run ECPUC tool to identify any missing patches at Application node. To run ECPUC, download  Patch 35583866  and follow the instructions in the patch  Readme.txt  file. 3.2.1 EBS CPU Patches and Security Fixes  [applprod@upgapp03 oracle]$ . EBSapps.env run [applprod@upgapp03 scripts]$ cd $PATCH_TOP [applprod@upgapp03 patch]$ pwd /applprod/oracle/fs_ne/EBSapps/patch [applprod@upgapp03 patch]$ cd ECPUC/ [applprod@upgapp03 ECPUC]$ unzip p35583866_R12_GENERIC.zip [applprod@upgapp03 ECPUC]$ sqlplus apps/apps@UPG SQL> @ECPUC.sql SECTION-2 Oracle E-Business Suite (EBS): Instance Information ======================================================================== ***************************************************************************...
Read more