my-orcl@Areef DBA, my-orcl@Arif DBA: EBS R12.2.9 Cloning for Pluggable EBS Database

Hi, in this topic we learn how to create Full Clone of EBS Pluggable Database & Application release EBS R12.2.9 on OCI.

List of Topics (Linux, Database, RAC, EBS)

################################################################################################################

################################################################################################################

Cloning Oracle E-Business Suite Release 12.2 with Multitenant Database using Rapid Clone (Doc ID 2552208.1)

Screen:

[root@ebscloudprodapp3 ~]# screen -ls

There is a screen on:

29206.pts-0.ebscloudprodapp3 (Attached)

1 Socket in /var/run/screen/S-root.

[root@ebscloudprodapp3 ~]# screen -d -r 29206.pts-0.ebscloudprodapp3

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

Enable tmux:

https://my-orcl.blogspot.com/2018/04/linux-basics-commands.html

[root@rac1 ~]# yum -y install tmux

[root@rac1 ~]# rpm -qa tmux

tmux-1.8-4.el7.x86_64

[root@rac1 ~]#

[root@rac1 ~]# tmux -f ~/.tmux.conf (force load all customizing in tmux session)

[root@rac1 ~]# tmux ls

0: 1 windows (created Tue Dec 14 06:27:17 2021) [200x57] (attached)

[root@rac1 ~]# tmux at -t 0

[root@rac1 ~]#

Copy command from OCI -> On-premise Servers

[root@prod1-oci ~]# scp root@192.0.100.44:/home/oracle/expdp/AJ_LIVE_01022022.dmp.tar.gz .

Copy command from On-premise -> OCI Servers

[root@rac1-onprem ~]# scp -i /home/applmgr/ssh-key-20.key opc@172.168.53.10:/u02/2022-02-15-dev-fs1.tar.gz .

Mount command for /u02 in OCI Server

[root@clouduatdb ~]# sudo mkdir -p /u02

[root@clouduatdb ~]# sudo mount 172.168.10.49:/ebsfss01 /u02

[root@clouduatdb ~]# cat /etc/fstab

##NFS Share for u02

172.168.10.49:/ebsfss01 /u02 nfs defaults,nofail 0 0

################################################################################################################

Specially for OCI Database: DBCLI Commands in DATABASE Install

To check list of RDBMS homes(only) on servers from root:

OCI db home CPU patches methods Parts Need to check and verify

Use the cliadm update-dbcli command to update the database CLI with the latest new and updated commands.

OCI DB Patching a DB System in OCI Using dbcli

Oracle Database CLI Reference

[root@prod1 ~]# dbcli describe-system -d

[root@prod1 ~]# dbcli describe-latestpatch

[root@prod1 ~]# dbcli describe-component

System Version

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

21.4.2.0.0

Component Installed Version Available Version

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

GI 19.10.0.0.0 19.13.0.0

DB 12.1.0.2.210119 12.1.0.2.211019

[root@prod1 ~]#

Run Adpreclone Scripts on db and Apps Tier

[applmgr@ebscloudprodapp3 ~]$

[applmgr@ebscloudprodapp3 ~]$ adpreclone.pl appsTier (approx. >30Mins)

[root@ebscloudprodapp3 fs2]# tar -cvzf /u02/CLONE_FILES/EBSapps_fs2_`date +%d-%m-%y`.tar.gz EBSapps

[root@ebscloudprodapp3 fs2]#

[opc@prod1 ~]$ sudo su - oracle

Last login: Tue Dec 14 08:46:12 +03 2021

$ORACLE_SID=PRODCDB1

. $ORACLE_HOME/PRODPDB_prod1.env

[oracle@prod1 ~]$ free -hw

total used free shared buffers cache available

Mem: 58G 38G 10G 3.8G 368M 9.3G 13G

Swap: 15G 157M 15G

[oracle@prod1 ~]$

[oracle@prod1 ~]$ . $ORACLE_HOME/PRODPDB_prod1.env

[oracle@prod1 ~]$ echo $ORACLE_SID

PRODPDB

[oracle@prod1 ~]$ cd $ORACLE_HOME/appsutil/scripts/PRODPDB_prod1

[oracle@prod1 PRODPDB_prod1]$ adpreclone.pl dbTier

[root@prod1 12.1.0.2]#

[root@prod1 12.1.0.2]# pwd

/u01/app/oracle/product/12.1.0.2

[root@prod1 12.1.0.2]#

[root@prod1 12.1.0.2]# tar -cvzf 12cdb1_cloud_`date +%d-%m-%y`.tar.gz dbhome_1

[root@prod1 12.1.0.2]#

Prepare RMAN Backup for Container DB:

[opc@prod1 ~]$ sudo su - oracle

Last login: Tue Aug 3 11:25:26 +03 2021

$ORACLE_SID=PRODCDB1

. $ORACLE_HOME/PRODPDB_prod1.env

[oracle@prod1 ~]$

[oracle@prod1 ~]$ echo $ORACLE_SID

PRODCDB1

[oracle@prod1 ~]$

[oracle@prd1 ~]$ cat $ORACLE_HOME/dbs/initPRODCDB1.ora

SPFILE='+DATA/PRODCDB/spfilePRODCDB.ora'

[oracle@prd1 ~]$ sqlplus / as sysdba

SQL> show parameter spfile;

NAME TYPE VALUE

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

spfile string +DATA/PRODCDB_JED164/PARAMETER

FILE/spfile.268.1069690857

SQL>

[oracle@prod1 ~]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Tue Jun 29 08:15:30 2021

connected to target database: PRODCDB (DBID=3723779434)

RMAN>

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name PRODCDB_JED164 are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF;

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u02/rman/clone/%F';

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET PARALLELISM 1;

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO COMPRESSED BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' FORMAT '%d_%I_%U_%T_%t' PARMS 'SBT_LIBRARY=/opt/oracle/dcs/commonstore/oss/PRODCDB_jed164/libopc.so ENV=(OPC_PFILE=/opt/oracle/dcs/commonstore/oss/PRODCDB_jed164/d9499162-c087-419f-80c9-289b3b4f47e0/opc_PRODCDB_jed164.ora)';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE ON;

CONFIGURE ENCRYPTION ALGORITHM 'AES256';

CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+RECO/PRODCDB_JED164/controlfile/snapcf_PRODCDB_jed164.f';

RMAN>

RMAN BACKUP SCRIPT as per PROD Configuration (approx. time 17 mins)

#Test this updated script without changing exisitng RMAN Parameters

RUN {

#configure controlfile autobackup format for device type disk to '/u02/rman/clone/%F';

#configure controlfile autobackup on;

allocate channel t1 type disk; #channels in Run{ will be released by it self when run command complete given tasks by closing "}"

allocate channel t2 type disk;

allocate channel t3 type disk;

allocate channel t4 type disk;

allocate channel t5 type disk;

allocate channel t6 type disk;

sql 'alter system archive log current';

backup AS COMPRESSED BACKUPSET full filesperset 4 format "/u02/rman/clone/%d_FULL_%T_%s_%p.bak" database plus archivelog;

backup current controlfile format '/u02/rman/clone/control1_file_%d_%T_%s_%p.ctl';

BACKUP SPFILE format "/u02/rman/clone/SPFILE_%d_%T_%s_%p.bak";}

#Previously using Script

RUN {configure controlfile autobackup format for device type disk to '/u02/rman/clone/%F';

configure controlfile autobackup on;
allocate channel t1 type disk; #channels in Run{ will be released by it self when run command complete given tasks by closing "}"
allocate channel t2 type disk;
allocate channel t3 type disk;
allocate channel t4 type disk;
allocate channel t5 type disk;
allocate channel t6 type disk;
sql 'alter system archive log current';
backup AS COMPRESSED BACKUPSET full filesperset 4 format "/u02/rman/clone/%d_FULL_%T_%s_%p.bak" database plus archivelog;

BACKUP SPFILE format "/u02/rman/clone/SPFILE_%d_%T_%s_%p.bak";}

RMAN> report need backup;

RMAN> list backup summary;

RMAN> crosscheck backup;

Create directories as per backup script and change permission:

[root@clouduatdb 12.1.0.2]# mkdir -p /u02/rman/clone

[root@clouduatdb 12.1.0.2]# chown -R oracle:oinstall /u02/rman/clone

[root@clouduatdb ~]# ps -ef | grep UATCDB |wc -l

[root@clouduatdb ~]# ps -ef | grep oracle |wc -l

120

[root@clouduatdb ~]# Stop CDB with immediate

[opc@clouduatdb ~]$ sudo su - oracle

Last login: Tue Aug 3 11:43:06 UTC 2021 on pts/0

[oracle@clouduatdb ~]$ echo $ORACLE_SID

UATCDB

[oracle@clouduatdb ~]$ srvctl config database

[grid@clouduatdb ~]$ crsctl query crs releasepatch

Oracle Clusterware release patch level is [363229741] and the complete list of patches [29340594 32067171 32218454 32218663 32222571 32240590 ] have been applied on the local node. The release patch string is [19.10.0.0.0].

[grid@clouduatdb ~]$

[oracle@prod1 clone]$ srvctl config database

PRODCDB_jed164

[oracle@prod1 clone]$ srvctl config database -d PRODCDB_jed164

[oracle@prod1 clone]$

[oracle@prod1 clone]$ srvctl status database -d PRODCDB_jed164

Instance PRODCDB1 is running on node prod1

Instance PRODCDB2 is running on node prod2

[oracle@prod1 clone]$

[oracle@rac1 ~]$ srvctl config database

[oracle@rac1 ~]$ srvctl status database -d $ORACLE_UNQNAME

[oracle@rac1 ~]$ srvctl status instance -d $ORACLE_UNQNAME -i $ORACLE_SID

[oracle@rac1 ~]$ srvctl status instance -d $ORACLE_UNQNAME -n $HOSTNAME

[oracle@rac1 ~]$ srvctl remove database -db $ORACLE_UNQNAME

[oracle@rac1 ~]$ srvctl remove database -d $ORACLE_UNQNAME -f -y

[oracle@rac1 ~]$

[oracle@rac1 ~]$ srvctl status listener

[oracle@rac1 ~]$ srvctl config scan

[oracle@rac1 ~]$ srvctl status scan

[oracle@rac1 ~]$ srvctl status scan_listener

[oracle@clouduatdb ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Aug 3 11:47:26 2021

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

and Real Application Testing options

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

[oracle@clouduatdb ~]$ ps -ef | grep tns

root 64 2 0 May03 ? 00:00:00 [netns]

oracle 2030 540 0 12:59 pts/0 00:00:00 grep --color=auto tns

grid 89260 1 0 Jun24 ? 00:05:51 /u01/app/19.0.0.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit

grid 94840 1 0 Jun23 ? 00:19:26 /u01/app/19.0.0.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit

[oracle@clouduatdb ~]$

[oracle@clouduatdb ~]$ lsnrctl stop UATCDB

[oracle@clouduatdb ~]$ ps -ef | grep UATCDB |wc -l

[oracle@clouduatdb ~]$ ps -ef | grep oracle |wc -l

[oracle@clouduatdb ~]$ exit

[opc@clouduatdb ~]$ sudo su - grid

Last login: Tue Aug 3 11:49:20 UTC 2021

[grid@clouduatdb ~]$ asmcmd -p

ASMCMD [+] > lsdg

State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED EXTERN N 512 512 4096 4194304 2097152 1308276 0 1308276 0 Y DATA/

MOUNTED EXTERN N 512 512 4096 4194304 417792 384108 0 384108 0 N RECO/

ASMCMD [+] >

ASMCMD [+] > cd data

ASMCMD [+data] > ls

UATCDB/

AHCCDEV_JED1RX/

ASM/

dbSys4rutiopq/

orapwasm

orapwasm_backup

ASMCMD [+data] >

ASMCMD [+] > cd data/UATCDB*/data*

ASMCMD [+data/UATCDB] >

ASMCMD [+data/UATCDB] > ls

BFC7541A9666806AE0533C0AA8AC1270/

C22549CD17D50517E0533C0AA8AC365B/

CHANGETRACKING/

DATAFILE/

TEMPFILE/

ASMCMD [+data/UATCDB] > (Delete all files in UATCDB FOLDER in ASM)

ASMCMD [+] > lsdg

State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED EXTERN N 512 512 4096 4194304 2097152 2087344 0 2087344 0 Y DATA/

MOUNTED EXTERN N 512 512 4096 4194304 417792 384108 0 384108 0 N RECO/

ASMCMD [+] >

worked below drop db option instead physically deleting CRD files from ASM/OS

this deletes C-R-D files plus spfile

select NAME from v$controlfile;

select file_name from dba_data_files;

select name from V$TEMPFILE;

select member from v$logfile;

col DEST_NAME for a25;
col DESTINATION for a50;
set linesize 200;
select dest_name,status,destination from v$ARCHIVE_DEST;

SQL> shut immediate

SQL> startup mount exclusive restrict

SQL> drop database;

Tar -xcvzf oraclehome on prod db….copy to /u02/CLONE_FILES

[root@clouduatdb CLONE_FILES]# tar -xvzf 12cdb1_23062021.tar.gz -C /u01/app/oracle/product/12.1.0.2 ( untar with root only )

[oracle@clouduatdb ~]$ ls -ltr $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 oracle asmadmin 329282584 Apr 16 06:07 oracle

[root@clouduatdb 12.1.0.2]# chown -R oracle:oinstall dbhome_1

[root@clouduatdb 12.1.0.2]# ls -ltr $ORACLE_HOME/bin/oracle (change group,permission to asmadmin later)

-rwsr-s--x 1 oracle oinstall 329282848 Jun 28 10:53 oracle

[root@clouduatdb ~]# chgrp asmadmin /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle (with root user)

[root@clouduatdb ~]# chmod 6751 /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle (changes to red highlight with 6751 permission )

[root@clouduatdb 12.1.0.2]# su - oracle

Last login: Mon Jun 28 10:18:29 UTC 2021 on pts/2

[oracle@clouduatdb ~]$ cat ~/.bashrc

# .bashrc

# Source global definitions

if [ -f /etc/bashrc ]; then

. /etc/bashrc

# Uncomment the following line if you don't like systemctl's auto-paging feature:

# export SYSTEMD_PAGER=

# User specific aliases and functions

ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1; export ORACLE_HOME

PATH=$PATH:/u01/app/oracle/product/12.1.0.2/dbhome_1/bin; export PATH

LD_LIBRARY_PATH=/u01/app/oracle/product/12.1.0.2/dbhome_1/lib; export LD_LIBRARY_PATH

ORACLE_UNQNAME=UATCDB;export ORACLE_UNQNAME

ORACLE_SID=UATCDB; export ORACLE_SID

## WARNING!! Modifying this file can cause failures in API/CLI provided by Cloud Tooling!!

[oracle@clouduatdb ~]$

[oracle@clouduatdb ~]$ cd $ORACLE_HOME/

[oracle@clouduatdb dbhome_1]$ pwd

/u01/app/oracle/product/12.1.0.2/dbhome_1

[oracle@clouduatdb dbhome_1]$

4.1.3 Create Context File

4.1.3.1 Create the Context File for a Single-Node Database

[oracle@clouduatdb ~]$ ps -ef | grep -i tns

[oracle@clouduatdb ~]$ ps -ef | grep -i CDB,PDB,oracle-user

[oracle@clouduatdb ~]$ cd $ORACLE_HOME/appsutil/clone/bin

[oracle@clouduatdb bin]$

[oracle@clouduatdb bin]$ ls -ltrh $ORACLE_HOME/appsutil/*.xml*

[oracle@clouduatdb bin]$

perl adclonectx.pl contextfile=$ORACLE_HOME/appsutil/PRODPDB_prod1.xml template=$ORACLE_HOME/appsutil/template/adxdbctx.tmp

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adclonectx Version 120.30.12020000.22

Running:

/u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -classpath /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/clone/bin/../jlib/ojdbc6.jar:/u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/clone/bin/../jlib/xmlparserv2.jar:/u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/clone/bin/../jlib/java: oracle.apps.ad.context.CloneContext -e /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/PRODPDB_prod1.xml -tmpl /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/template/adxdbctx.tmp

Enter the APPS password : apps password

Log file located at /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/clone/bin/CloneContext_0627084219.log

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

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

It is recommended that your inputs are validated by the program.

However you might choose not to validate them under following circumstances:

-If cloning a context on source system for a remote system.

-If cloning a context on a machine where the ports are taken and

you do not want to shutdown the services at this point.

-If cloning a context but the database it needs to connect is not available.

Do you want the inputs to be validated (y/n) [n] ? :

Target System Base Directory : /u01/app/oracle

Target Instance is RAC (y/n) [y] : n

Target System CDB Name : UATCDB DEVCDB

Target System PDB Name : UATPDB DEVPDB

Oracle OS User [oracle] :

Oracle OS Group [oinstall] :

Role separation is supported y/n [n] ? : n

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [3] : 1

Target System DATA_TOP Directory 1 : +DATA

Target System RDBMS ORACLE_HOME Directory [/u01/app/oracle/12.1.0] : /u01/app/oracle/product/12.1.0.2/dbhome_1

Do you want to preserve the Display [localhost:10.0] (y/n) : n

Target System Display [clouduatdb:0.0] :

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

Report file located at /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/temp/portpool.lst

New context path and file name [/u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/UATPDB_clouduatdb.xml] :

The new database context file has been created :

/u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/UATPDB_clouduatdb.xml

contextfile=/u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/UATPDB_clouduatdb.xml

Check Clone Context logfile /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/clone/bin/CloneContext_0627084219.log for details.

Verify unique name of CDB

ls -ltrh $ORACLE_HOME/appsutil/*.xml*

ll $ORACLE_HOME/dbs/init*.ora* $ORACLE_HOME/*.env* Still .ora file will not be created at this point

grep unique $ORACLE_HOME/appsutil/UATPDB_clouduatdb.xml

<cdb_unique_name oa_var="s_cdb_unique_name">UATCDB</cdb_unique_name>

(Set Local/update Global) Inventory setup before run adscfgclone on dbTier:

Local Inventory Setup:

Local Inventory Setup:

[oracle@uatclouddb
bin]$ cat $ORACLE_HOME/oraInst.loc
#Oracle Installer
Location File Location
#Mon Apr 12 16:11:35
AST 2021
inst_group=oinstall
inventory_loc=/u01/app/oracle/product/12.1.0.2/dbhome_1/oraInventory
[oracle@uatclouddb
bin]$ 
[oracle@uatclouddb
bin]$ mkdir -p $ORACLE_HOME/oraInventory

Global Inventory Setup:

Rm oraInst.loc

Remove oracle home entry from inventory.xml in oraInventory at /u01/app/oraInventory to avoid error RC at adcfgclone run:

[oracle@clouduatdb ~]$ mv $ORACLE_HOME/oraInst.loc $ORACLE_HOME/oraInst.loc_orig

[oracle@clouduatdb ~]$ cat /etc/oraInst.loc

inventory_loc=/u01/app/oraInventory

inst_group=oinstall

[oracle@clouduatdb ~]$ cd /u01/app/oraInventory/ContentsXML/

[oracle@clouduatdb ContentsXML]$ cp inventory.xml inventory.xml_bkp

[oracle@clouduatdb ~]$ vi /u01/app/oraInventory/ContentsXML/inventory.xml

Use attach detach home and try like here

4.1.4 Configure the Database Technology Stack

[oracle@clouduatdb ~]$ ls -ltr $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 oracle oinstall 329282848 Jun 28 10:53 oracle

In order to avoaid below error in adcfgclone.pl:

[oracle@uatclouddb bin]$

mkdir -p $ORACLE_HOME/oraInventory

vi $ORACLE_HOME/oraInst.loc

Goinventory_loc=/u01/app/oracle/product/12.1.0.2/dbhome_1/oraInventory

AutoConfig is exiting with status 1

WARNING: RC-50013: Fatal: Instantiate driver did not complete successfully.

[oracle@clouduatdb ~]$ cd $ORACLE_HOME/appsutil/clone/bin

[oracle@clouduatdb bin]$ ps -ef | grep -i UATCDB

NOTE: If intended to use grid port 1521 then Verify 1521 port is free (grid listener)

(if you got any error 1521 port already in use then check grid listener port and stop grid listener and retry dbTechStack)

[oracle@clouduatdb bin]$ lsnrctl status

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.138.9.13)(PORT=1521)))

[grid@clouduatdb bin]$ lsnrctl stop

[oracle@clouduatdb bin]$ ps -ef | grep -i tns

[oracle@clouduatdb bin]$ lsnrctl status

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) (need to reverify this line port 1521 status with grid & oracle user)

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

[oracle@clouduatdb bin]$

perl adcfgclone.pl dbTechStack $ORACLE_HOME/appsutil/UATPDB_clouduatdb.xml (worked. approx. time 3 mins)

. . . . .

Completed Apply...

Fri Mar 11 18:54:01 2022

Starting database listener for DEVPDB:

Running:

/u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/scripts/DEVPDB_ahcclouddevdb/addlnctl.sh start AHCCDEV

Logfile: /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/log/DEVPDB_ahcclouddevdb/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process AHCCDEV ...

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 11-MAR-2022 18:54:01

Starting /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production

System parameter file is /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/DEVPDB_ahcclouddevdb/listener.ora

Log messages written to /u01/app/oracle/product/12.1.0.2/dbhome_1/admin/DEVPDB_ahcclouddevdb/diag/tnslsnr/ahcclouddevdb/ahccdev/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ahcclouddevdb.developmentsn.ahccloudprdvcn1.oraclevcn.com)(PORT=1531)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ahcclouddevdb.developmentsn.ahccloudprdvcn1.oraclevcn.com)(PORT=1531)))

STATUS of the LISTENER

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

Alias AHCCDEV

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 11-MAR-2022 18:54:02

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/DEVPDB_ahcclouddevdb/listener.ora

Listener Log File /u01/app/oracle/product/12.1.0.2/dbhome_1/admin/DEVPDB_ahcclouddevdb/diag/tnslsnr/ahcclouddevdb/ahccdev/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ahcclouddevdb.developmentsn.ahccloudprdvcn1.oraclevcn.com)(PORT=1531)))

Services Summary...

Service "DEVPDB" has 1 instance(s).

Instance "DEVPDB", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/log/DEVPDB_ahcclouddevdb/addlnctl.txt for more information ...

Running ETCC to check status of DB technology patches...

. . . . .

[oracle@clouduatdb bin]$

.ora, env files get created and listener also started. also re-check at what stage listener status starts dectected by CDB SID

[oracle@clouduatdb bin]$ ps -ef | grep tns

[oracle@clouduatdb bin]$ ps -ef | grep $ORACLE_SID

oracle 39371 1 0 13:40 ? 00:00:00 /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/tnslsnr UATCDB -inherit

oracle 42585 9986 0 13:42 pts/0 00:00:00 grep --color=auto UATCDB

[oracle@clouduatdb ~]$ lsnrctl status (check where are the services of listener is loaded)

[oracle@clouduatdb bin]$

[oracle@clouduatdb ~]$ . $ORACLE_HOME/UATPDB_clouduatdb.enc

[oracle@clouduatdb ~]$ echo $ORACLE_SID

UATPDB

[oracle@clouduatdb ~]$ lsnrctl status ($ORACLE_SID,UATCDB,UATPDB need to re-verify )

[oracle@ahcclouddevdb ~]$ lsnrctl status $ORACLE_SID

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 11-MAR-2022 19:08:31

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ahcclouddevdb)(PORT=1531))(CONNECT_DATA=(SERVICE_NAME=DEVPDB)(INSTANCE_NAME=AHCCDEV)))

STATUS of the LISTENER

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

Alias AHCCDEV

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 11-MAR-2022 18:54:02

Uptime 0 days 0 hr. 14 min. 29 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/DEVPDB_ahcclouddevdb/listener.ora

Listener Log File /u01/app/oracle/product/12.1.0.2/dbhome_1/admin/DEVPDB_ahcclouddevdb/diag/tnslsnr/ahcclouddevdb/ahccdev/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ahcclouddevdb.developmentsn.ahccloudprdvcn1.oraclevcn.com)(PORT=1531)))

Services Summary...

Service "DEVPDB" has 1 instance(s).

Instance "DEVPDB", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@ahcclouddevdb ~]$

[oracle@clouduatdb ~]$

ls -ltrh $ORACLE_HOME/dbs/init*.ora* $ORACLE_HOME/*.env*

grep unique $ORACLE_HOME/dbs/init*.ora* $ORACLE_HOME/*.env*

[oracle@clouduatdb bin]$ cat /u01/app/oraInventory/ContentsXML/inventory.xml

[oracle@clouduatdb bin]$ cat $ORACLE_HOME/oraInventory/ContentsXML/inventory.xml

<?xml version="1.0" standalone="yes" ?>

<VERSION_INFO>

<SAVED_WITH>12.1.0.2.0</SAVED_WITH>

<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

</HOME_LIST>

<COMPOSITEHOME_LIST>

</COMPOSITEHOME_LIST>

</INVENTORY>

[oracle@clouduatdb bin]$

Instance Startup Fails With ORA-00205 After Applying Patch/Relinking (Doc ID 1166697.1)

change oracle binary permission after the above step:

[oracle@clouduatdb ~]$ ls -ltr $ORACLE_HOME/bin/oracle

-rwsr-s--x 1 oracle oinstall 329282848 Jun 28 10:53 oracle

Important now to change to ASMADMIN:

(now it is mandatory to set before txk scripts, set with root user only)

[root@clouduatdb bin]#

ls -ltrh /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle

chgrp asmadmin /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle

chmod 6751 /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle

ls -ltrh /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/oracle

4.1.5 Create the listener.ora and tnsnames.ora for the Target Database

Create the listener.ora and tnsnames.ora files for the target CDB by running the following commands:

1. Set the environment.

On Unix:

$ cd <ORACLE_HOME>/appsutil

$ source ./txkSetCfgCDB.env -dboraclehome=<ORACLE_HOME>

2. Generate the listener.ora and tnsnames.ora.

$ cd <ORACLE_HOME>/appsutil/bin

$ perl txkGenCDBTnsAdmin.pl -dboraclehome=<ORACLE_HOME> -cdbname=<Name of the target container database> \

-cdbsid=<SID of the target container database> -dbport=<Target DB port> -outdir=$ORACLE_HOME/appsutil/log \

-israc=<yes/no> [-virtualhostname=<virtual hostname>]

[oracle@clouduatdb ~]$ . $ORACLE_HOME/UATCDB_clouduatdb.env

[oracle@clouduatdb ~]$ echo $ORACLE_SID

UATCDB

[oracle@clouduatdb ~]$ lsnrctl status $ORACLE_SID (verified pdb listner is up with source pdb env)

TNS-01101: Could not find listener name or service name UATCDB

[oracle@clouduatdb ~]$ lsnrctl status

[oracle@clouduatdb ~]$ cd $ORACLE_HOME/appsutil

[oracle@clouduatdb appsutil]$

. txkSetCfgCDB.env -dboraclehome=/u01/app/oracle/product/12.1.0.2/dbhome_1

Oracle Home being passed: /u01/app/oracle/product/12.1.0.2/dbhome_1

[oracle@clouduatdb appsutil]$

[oracle@clouduatdb appsutil]$ srvctl status listener (verifed)

Listener LISTENER is enabled

Listener LISTENER is running on node(s): ahcclouddevdb

[oracle@clouduatdb appsutil]$ cd $ORACLE_HOME/appsutil/bin

[oracle@clouduatdb ~]$ echo $ORACLE_SID

UATCDB

[oracle@clouduatdb ~]$

[oracle@clouduatdb UATPDB_clouduatdb]$ lsnrctl status LISTENER

[oracle@clouduatdb UATPDB_clouduatdb]$ lsnrctl status $ORACLE_SID (need to re-verify )

[oracle@clouduatdb bin]$ (below command worked tested and verified)

perl txkGenCDBTnsAdmin.pl -dboraclehome=$ORACLE_HOME -cdbname=UATCDB -cdbsid=UATCDB -dbport=1521 -outdir=$ORACLE_HOME/appsutil/log -israc=no

1perl txkGenCDBTnsAdmin.pl -dboraclehome=/u01/app/oracle/product/12.1.0.2/dbhome_1 -cdbname=UATCDB -cdbsid=UATCDB -dbport=1521 -outdir=$ORACLE_HOME/appsutil/log -israc=no

. . . . . . .

Inside updateCDBSqlNetOra()…

Updating the IFILE entry…

Exiting from the script.

Ended: Mon Jun 28 11:02:54 UTC 2021

[oracle@clouduatdb bin]$

[oracle@clouduatdb UATPDB_clouduatdb]$ lsnrctl status LISTENER

From section 4.1.5 PDB listener will also be detected by CDB env (verifed)

[oracle@clouduatdb UATPDB_clouduatdb]$

[oracle@clouduatdb UATPDB_clouduatdb]$ echo $ORACLE_SID

UATCDB

[oracle@clouduatdb UATPDB_clouduatdb]$ lsnrctl status $ORACLE_SID (verifed)

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 11-MAR-2022 19:20:53

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ahcclouddevdb.developmentsn.ahccloudprdvcn1.oraclevcn.com)(PORT=1531)))

STATUS of the LISTENER

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

Alias AHCCDEV

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 11-MAR-2022 18:54:02

Uptime 0 days 0 hr. 26 min. 51 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/DEVPDB_ahcclouddevdb/listener.ora

Listener Log File /u01/app/oracle/product/12.1.0.2/dbhome_1/admin/DEVPDB_ahcclouddevdb/diag/tnslsnr/ahcclouddevdb/ahccdev/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ahcclouddevdb.developmentsn.ahccloudprdvcn1.oraclevcn.com)(PORT=1531)))

Services Summary...

Service "DEVPDB" has 1 instance(s).

Instance "DEVPDB", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@clouduatdb bin]$ cd $ORACLE_HOME/appsutil/scripts/UATPDB_clouduatdb

[oracle@clouduatdb UATPDB_clouduatdb]$ . adcdblnctl.sh start UATCDB

basename: invalid option -- 'b'

Try 'basename --help' for more information.

Logfile: /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/log/UATPDB_clouduatdb/adcdblnctl.txt

You are running version 120.0.12020000.3

Starting listener process UATCDB ...

Listener UATCDB has already been started.

Waiting for service UATPDB to be available...

-- 21 times retrys for about 5 Mins--

Waiting for service UATPDB to be available...

Listener service UATPDB not started.

: exiting with status 1

: check the logfile /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/log/UATPDB_clouduatdb/adcdblnctl.txt for more information ...

Here oracle user will get log out automatically

-Start the Grid Listner now (1521 port should not be seen in grid listener after started

[opc@clouduatdb ~]$ sudo su – grid

[grid@clouduatdb ~]$ lsnrctl status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused

[grid@clouduatdb ~]$

[grid@clouduatdb ~]$ lsnrctl start

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 21-MAR-2022 12:19:19

Starting /u01/app/19.0.0.0/grid/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production

System parameter file is /u01/app/19.0.0.0/grid/network/admin/listener.ora

Log messages written to /u01/app/grid/diag/tnslsnr/ahcclouddevdb/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 21-MAR-2022 12:19:19

Uptime 0 days 0 hr. 0 min. 0 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/19.0.0.0/grid/network/admin/listener.ora

Listener Log File /u01/app/grid/diag/tnslsnr/ahcclouddevdb/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))

The listener supports no services

The command completed successfully

[opc@clouduatdb ~]$ sudo su – oracle (if not login manual entry)

[oracle@clouduatdb ~]$ lsnrctl status $ORACLE_SID

[oracle@clouduatdb ~]$ lsnrctl status UATCDB

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 29-JUN-2021 09:10:31

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=clouduatdb.uatsn.cloudprdvcn1.oraclevcn.com)(PORT=1521)))

STATUS of the LISTENER

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

Alias UATCDB

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 29-JUN-2021 08:38:52

Uptime 0 days 0 hr. 31 min. 39 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/UATPDB_clouduatdb/listener.ora

Listener Log File /u01/app/oracle/product/12.1.0.2/dbhome_1/admin/UATPDB_clouduatdb/diag/tnslsnr/clouduatdb/uatcdb/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clouduatdb.uatsn.cloudprdvcn1.oraclevcn.com)(PORT=1521)))

Services Summary...

Service "UATPDB" has 1 instance(s).

Instance "UATPDB", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

[oracle@clouduatdb ~]$

As pdb not restored we will get error for pdb

Will correct the listener file later, as it is using lisnter inside of context:

[opc@clouduatdb ~]$ sudo su - oracle

Last login: Mon Jun 28 11:08:45 UTC 2021

[oracle@clouduatdb ~]$ cd $ORACLE_HOME/dbs

[oracle@clouduatdb dbs]$

[oracle@clouduatdb dbs]$ echo $ORACLE_SID

UATCDB

[oracle@clouduatdb dbs]$ cp initUATPDB.ora initUATCDB.ora

[oracle@clouduatdb dbs]$ cp initUATPDB.ora initUATCDB.ora

[oracle@clouduatdb dbs]$

[oracle@clouduatdb dbs]$ sqlplus / as sysdba

SQL> create spfile from pfile;

File created.

SQL> create pfile from spfile;

File created.

SQL> exit

Disconnected

[oracle@clouduatdb dbs]$ mv spfileUATCDB.ora spfileUATCDB.ora_bkp

[oracle@clouduatdb dbs]$ mv spfileUATCDB.ora spfileUATCDB.ora_bkp [oracle@clouduatdb dbs]$ ls -ltr

Generate initUATCDB.ora and edit the required parameter name and remove local_listener and modify control file

*.control_files='+DATA/cntrl01a.dbf' #directory should be created before for NON-ASM

#*.local_listener='UATCDB_LOCAL' # if got error in startup then delete local line

*.log_archive_dest_1='LOCATION=+DATA'

*.plsql_code_type='NATIVE'# Default 11i setting #(verified and checked RMAN updated as per source DB)

[oracle@clouduatdb dbs]$ sqlplus / as sysdba

SQL> startup nomount pfile='initUATCDB.ora' #(mandatory to start db with pfile only spfile will give error)

SQL> startup nomount pfile='initUATCDB.ora'

SQL>

SQL> show parameter spfile;

NAME TYPE VALUE

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

spfile string

SQL>

show parameter spfile;

SELECT INSTANCE_NAME, STATUS, DATABASE_STATUS FROM V$INSTANCE;

select * from v$pwfile_users;

SELECT value from v$diag_info where name='Diag Trace';

exit

grep diagnostic_dest $ORACLE_HOME/dbs/initCDBTEST.ora

find /u01/app/oracle/diag/rdbms/ -iname alert*.log

tailf /u01/app/oracle/diag/rdbms/ahccdev_jed1rx/AHCCDEV/trace/alert*.log

Inorder to fix below error in RMAN Restore update the wallet as the database is in OCI by default Transparent Data Encryption(TDE) is enabled:

(Make sure u bkp existing wallets of server, Required only once when created new DB servers in OCI, Once copied to new server then no need repeated in next clone)

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 06/27/2021 09:41:31

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

ORA-19870: error while restoring backup piece /u02/rman/clone/c-3723779434-20210627-1d

ORA-19913: unable to decrypt backup

ORA-28365: wallet is not open

[root@clouduatdb bin]# cd /opt/oracle/dcs/commonstore/wallets/tde/UATCDB_jed1gh/

[root@clouduatdb UATCDB_jed1gh]# ls -ltr

total 100

-rw------- 1 oracle asmadmin 2555 Jun 2 09:39 ewallet_2021060209390371_defaultTag.p12

-rw------- 1 oracle asmadmin 5819 Jun 2 09:39 ewallet.p12_uatdefault

-rw------- 1 oracle asmadmin 5864 Jun 2 09:39 cwallet.sso_uatdefault

-rw-r--r-- 1 oracle asmadmin 2612 Jun 27 13:38 masterkey.bkp

-rw-r--r-- 1 oracle asmadmin 9211 Jun 27 13:39 ewallet_2021062713391205.p12

-rw-r--r-- 1 oracle asmadmin 2612 Jun 28 13:15 masterkey_exp.bkp

-rw------- 1 oracle asmadmin 9211 Jun 28 13:16 ewallet_2021062813163988.p12

-rw------- 1 oracle asmadmin 9211 Jun 28 13:16 ewallet.p12

-rw------- 1 oracle asmadmin 9256 Jun 28 13:16 cwallet.sso

[root@clouduatdb UATCDB_jed1gh]#

need to test: Make backup of existing c&e wallets, once RMAN restore completes then revert it back and try PSU patching checks from console

The above cwallet and ewallet is copied from source server to target to over come error “ORA-19913: unable to decrypt backup”

Update the sqlnet.ora in $ORACLE_HOME/network/admin/sqlnet.ora

Update encrypt location of target by comparing source

#################################

# Definition for CDB sqlnet.ora

#################################

#ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/opt/oracle/dcs/commonstore/wallets/tde/UATCDB_jed1gh)))

#ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/opt/oracle/dcs/commonstore/wallets/tde/AHCCDEV_jed1rx)))

SQLNET.ENCRYPTION_SERVER=REQUIRED

SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED

SQLNET.ENCRYPTION_TYPES_SERVER=(rc4_40,AES256,AES192,AES128)#(Doc ID 2777856.1)

SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1)

#--- Client sqlnet.ora paramters

#SQLNET.ENCRYPTION_CLIENT=REQUIRED

#SQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED

#SQLNET.ENCRYPTION_TYPES_CLIENT=(rc4_40,AES256,AES192,AES128)

#SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)

NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)

SQLNET.EXPIRE_TIME=10

SQLNET.INBOUND_CONNECT_TIMEOUT=60

SQLNET.ALLOWED_LOGON_VERSION_SERVER=10

IFILE=/u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/sqlnet_ifile.ora

4.1.6 Restore and Start the Target Database

RMAN RESTORE SCRIPT: (approx. Time: 35 mins)

[oracle@clouduatdb ~]$

[oracle@clouduatdb ~]$ ls -ltr $ORACLE_HOME/bin/oracle (if not asmadmin then, restore of controlfile fails)

-rwsr-s--x 1 oracle asmadmin 329282584 Apr 16 06:07 oracle

[oracle@clouduatdb dbs]$ mkdir -p /u01/app/oracle/admin/UATCDB/adump

[oracle@clouduatdb dbs]$ mkdir -p /u01/app/oracle/admin/UATCDB/adump/

[oracle@clouduatdb dbs]$

[oracle@clouduatdb dbs]$ rman auxiliary /

Recovery Manager: Release 12.1.0.2.0 - Production on Mon Jun 28 11:33:19 2021

connected to auxiliary database: UATPDB (not mounted)

RMAN> show AUXILIARY CHANNEL;

RMAN> host 'lsnrctl status';

#-UPDATED-restore db script (set db_unique_name) parameter if RMAN fails remove the line and try again.

RMAN>

run {

ALLOCATE AUXILIARY CHANNEL aux1 DEVICE TYPE DISK; # channels in Run{ will be released by it self when run command complete given tasks by closing "}"

ALLOCATE AUXILIARY CHANNEL aux2 DEVICE TYPE DISK;

ALLOCATE AUXILIARY CHANNEL aux3 DEVICE TYPE DISK;

ALLOCATE AUXILIARY CHANNEL aux4 DEVICE TYPE DISK;

ALLOCATE AUXILIARY CHANNEL aux5 DEVICE TYPE DISK;

ALLOCATE AUXILIARY CHANNEL aux6 DEVICE TYPE DISK;

duplicate database to UATCDB spfile

set db_unique_name='UATCDB_jed1gh' # verifed & worked , check as per your OCI DB this line

set control_files '+DATA/cntrl01a.dbf' #directory should be created before for NON-ASM

set db_create_file_dest '+DATA/' 

SET CLUSTER_DATABASE='FALSE' 

set audit_file_dest='/u01/app/oracle/admin/UATCDB_jed1gh/adump' 

BACKUP LOCATION '/u02/rman/rman_dailybkp/' NOFILENAMECHECK;}

no need of providing Release channel if it allocated in Run{ once the duplicate command complete it automatically releases the channel and you wont get below error.

Lets make a try with out issuing any duplicate in RUN{

same will happen for normal channel and auxiliary channel.

RMAN> RUN {

allocate AUXILIARY channel t1 type disk;

allocate AUXILIARY channel t2 type disk;

allocate AUXILIARY channel t3 type disk;}

allocated channel: t1

channel t1: SID=4 device type=DISK

allocated channel: t2

channel t2: SID=2006 device type=DISK

allocated channel: t3

channel t3: SID=4013 device type=DISK

released channel: t1

released channel: t2

released channel: t3

RMAN>

. . . . .

Reenabling controlfile options for auxiliary database

Executing: alter database force logging

Executing: alter database enable block change tracking

contents of Memory Script:

{

Alter clone database open resetlogs;

}

executing Memory Script

database opened

contents of Memory Script:

{

sql clone "alter pluggable database all open";

}

executing Memory Script

sql statement: alter pluggable database all open

Finished Duplicate Db at 28-JUN-21

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of release command at 06/28/2021 12:37:28

RMAN-06012: channel: aux1 not allocated

RMAN> show AUXILIARY CHANNEL;

RMAN> exit

We can ignore the above error just channel got not released:

New alert log file will be started at

SELECT value from v$diag_info where name='Diag Trace';

tailf /u01/app/oracle/diag/rdbms/uatcdb_jed1gh/UATCDB/trace/alert*

tailf /u01/app/oracle/diag/rdbms/devcdb/DEVCDB/trace/alert*

grep diagnostic_dest $ORACLE_HOME/dbs/initCDBTEST.ora

tailf /data/admin/oracle/diag/rdbms/cdbtest/CDBTEST/trace/alert*.log

Make sure you backup a new pfile after completing RMAN

create pfile='/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/initAFTER_RMAN.ora' from spfile;

ls -ltrh $ORACLE_HOME/dbs/initAFTER_RMAN.ora

After restoring apply patch p22747454_121020_Generic.zip if got MGD mismatch:

[oracle@clouduatdb ~]$ $ORACLE_HOME/OPatch/opatch lsinventory | grep 22747454

Patch  22747454     : applied on Mon Mar 21 13:20:32 UTC 2022
     22747454
[oracle@ahcclouddevdb ~]$

[oracle@clouduatdb ~]$ $ORACLE_HOME/OPatch/datapatch -verbose

If patch is already applied i.e using same db home for db-refresh/cloning then just run datapatch without shutdown on db

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PRODPDB                        READ WRITE YES

SQL>

SQL> select COMP_ID from DBA_REGISTRY where STATUS='VALID'
order by 1;  --(CDB
& PDB Should have same number of 18 rows in total)

SQL> select TIME, MESSAGE,ACTION from
PDB_PLUG_IN_VIOLATIONS; -- check for error
message of violations

TIME

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

MESSAGE

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

ACTION

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

28-JUN-21 12.37.23.572364 PM

Database option MGD mismatch: PDB installed version 12.1.0.2.0. CDB installed ve

rsion NULL.

Fix the database option in the PDB or the CDB

SQL> alter session set container=cdb$root;

Session altered.

SQL> alter pluggable database PRODPDB (close , open read write) – can test the warning in opening

Warning: PDB altered with errors. 

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PRODPDB                        READ WRITE YES

SQL> 

SQL> shut immediate

drwxr-xr-x 4 oracle oinstall  4096 Jun 20 07:29 22747454

[oracle@clouduatdb ~]$ cd $ORACLE_HOME/appsutil/etcc/22747454

[oracle@clouduatdb 22747454]$

[oracle@clouduatdb 22747454]$ $ORACLE_HOME/OPatch/opatch lsinventory | grep 22747454

[oracle@clouduatdb 22747454]$

[oracle@clouduatdb 22747454]$ $ORACLE_HOME/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.21

Copyright (c) 2021, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0.2/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/12.1.0.2/dbhome_1/oraInst.loc

OPatch version    : 12.2.0.1.21

OUI version       : 12.1.0.2.0

Log file location : /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2021-06-27_12-19-47PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   22747454

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Backing up files...

Applying interim patch '22747454' to OH '/u01/app/oracle/product/12.1.0.2/dbhome_1'

Patching component oracle.rdbms.dbscripts, 12.1.0.2.0...

Patch 22747454 successfully applied.

Log file location: /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/opatch/opatch2021-06-27_12-19-47PM_1.log

OPatch succeeded.

[oracle@clouduatdb 22747454]$ cd $ORACLE_HOME/OPatch/

[oracle@clouduatdb 22747454]$ $ORACLE_HOME/OPatch/opatch lsinventory | grep 22747454

Patch  22747454     : applied on Tue Dec 14 14:54:32 UTC 2021

22747454

[oracle@clouduatdb 22747454]$ 

[oracle@clouduatdb OPatch]$

[oracle@clouduatdb OPatch]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 27 12:20:25 2021

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

Connected to an idle instance.

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 3.0602E+10 bytes

Fixed Size                  3728688 bytes

Variable Size            1.0670E+10 bytes

Database Buffers         1.9864E+10 bytes

Redo Buffers               63377408 bytes

Database mounted.

Database opened.

SQL>

alter session set container=PRODPDB;

set linesize 200;

col DESCRIPTION for a80;

col ACTION_TIME for a31;

select PATCH_ID,ACTION_TIME,DESCRIPTION from
dba_registry_sqlpatch;

exit

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

and Real Application Testing options

[oracle@clouduatdb ~]$ $ORACLE_HOME/OPatch/datapatch -verbose (worked fine) (approx. 15 Mins)

[oracle@clouduatdb OPatch]$ cd $ORACLE_HOME/OPatch/

[oracle@clouduatdb OPatch]$ ./datapatch -verbose    

SQL Patching tool version 12.1.0.2.0 Production on Sun Jun 27 12:21:11 2021

Copyright (c) 2012, 2017, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/sqlpatch/sqlpatch_90541_2021_06_27_12_21_11/sqlpatch_invocation.log

Connecting to database...OK

Note:  Datapatch will only apply or rollback SQL fixes for PDBs

       that are in an open state, no patches will be applied to closed PDBs.

       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation

       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done

Determining current state...done

Current state of SQL patches:

Patch 18793246 (BASE OBJECT LOOKUP DURING DATAPUMP EXPORT CAUSES FULL TABLE SCAN PER OBJECT):

  Installed in the binary registry and PRODPDB CDB$ROOT PDB$SEED

Patch 22731026 (XTTS12102: DRG-10602 AFTER MIGRATION FROM RDBMS 11.2.0 TO 12.1.0):

  Installed in the binary registry and PRODPDB CDB$ROOT PDB$SEED

Patch 22747454 ():

  Installed in the binary registry only

Patch 31629625 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.200714 FOR BUGS 31321438 31413047):

  Installed in the binary registry and PRODPDB CDB$ROOT PDB$SEED

Patch 31668915 (Database PSU 12.1.0.2.201020, Oracle JavaVM Component (OCT2020)):

  Installed in the binary registry and PRODPDB CDB$ROOT PDB$SEED

Patch 31838788 (MERGE REQUEST ON TOP OF DATABASE BP 12.1.0.2.201020 FOR BUGS 21117072 22611167):

  Not installed in the binary or the SQL registry

Bundle series DBBP:

  ID 201020 in the binary registry and ID 201020 in PDB CDB$ROOT, ID 201020 in PDB PDB$SEED, ID 201020 in PDB PRODPDB

Adding patches to installation queue and performing prereq checks...

Installation queue:

  For the following PDBs: CDB$ROOT PDB$SEED PRODPDB

    Nothing to roll back

    The following patches will be applied:

      22747454 ()

Installing patches...

Patch installation complete.  Total patches installed: 3

Validating logfiles...

Patch 22747454 apply (pdb CDB$ROOT): SUCCESS

  logfile: /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/sqlpatch/22747454/21999295/22747454_apply_UATCDB_CDBROOT_2021Jun27_12_21_50.log (no errors)

Patch 22747454 apply (pdb PDB$SEED): SUCCESS

  logfile: /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/sqlpatch/22747454/21999295/22747454_apply_UATCDB_PDBSEED_2021Jun27_12_24_01.log (no errors)

Patch 22747454 apply (pdb PRODPDB): SUCCESS

  logfile: /u01/app/oracle/product/12.1.0.2/dbhome_1/cfgtoollogs/sqlpatch/22747454/21999295/22747454_apply_UATCDB_PRODPDB_2021Jun27_12_24_01.log (no errors)

SQL Patching tool complete on Sun Jun 27 12:28:57 2021

[oracle@clouduatdb OPatch]$

[oracle@clouduatdb OPatch]$

Clear the Restricted mode on PDB:

[oracle@clouduatdb OPatch]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jun 27 12:30:53 2021

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics

and Real Application Testing options

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PRODPDB                        READ WRITE YES

SQL> alter pluggable database PRODPDB close;

Pluggable database altered.

SQL> alter pluggable database PRODPDB open read write;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 PRODPDB                        READ WRITE NO

SQL>

Now the Pluggable database is opened normally without warning, so we can use it.

SQL> alter pluggable database PRODPDB close;

Pluggable database altered.

SQL> !ls -ltrh $ORACLE_HOME/dbs/*.xml*

SQL> alter pluggable database "PRODPDB" unplug into '/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/PRODPDB.xml';

Pluggable database altered.

[oracle@clouduatdb ~]$ ls -ltr $ORACLE_HOME/dbs/*.xml

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 PRODPDB MOUNTED

SQL>

SQL> drop pluggable database PRODPDB;

Pluggable database dropped.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

SQL>

SQL> show parameter service

NAME TYPE VALUE

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

service_names string PRODPDB , PRODPDB_ebs_patch

SQL>

SQL> create pluggable database "UATPDB" using '/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/PRODPDB.xml' nocopy SERVICE_NAME_CONVERT=('ebs_PRODPDB','ebs_UATPDB');

SQL> create pluggable database "PDB" using '/u01/app/oracle/product/12.1.0.2/dbhome_1/dbs/PRODPDB.xml' nocopy SERVICE_NAME_CONVERT=('ebs_PRODPDB','ebs_UATPDB');

Pluggable database created.

SQL>

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 UATPDB MOUNTED

SQL>

SQL> alter session set container=cdb$root;

SQL>

SQL> alter pluggable database UATPDB open read write;

SQL> alter pluggable database UATPDB open read write;

Warning: PDB altered with errors.

SQL> show pdbs

SQL>

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

Pluggable database altered.

SQL>

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 UATPDB READ WRITE YES

SQL>

MGD Missmatch is corrected with the patch applied both CDB and PDB has 18 rows of record.

But still pluggable will in restricted mode…for wallet keys…..follow below procedure to fix…modify the below values for UAT …UATPDB and wallet location to /opt/oracle/dcs/commonstore/wallets/tde/UATCDB_jed1gh

/opt/oracle/dcs/commonstore/wallets/tde/AHCCDEV_jed1rx

Creating new Key and importing to PDB

SQL>

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

WRL_PARAMETER

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

STATUS WALLET_TYPE

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

/opt/oracle/dcs/commonstore/wallets/tde/UATCDB_jed1gh/

OPEN AUTOLOGIN

SQL>

SQL> alter session set container=cdb$root;

Session altered.

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

SQL>

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "TesT_1234#" container=Current;

ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "TesT_1234#" container=Current

ERROR at line 1:

ORA-28354: Encryption wallet, auto login wallet, or HSM is already open

SQL>

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE CONTAINER=ALL;

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE CLOSE identified by "TesT_1234#" CONTAINER=ALL;

keystore altered.

SQL>

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "TesT_1234#" container=Current;

keystore altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 UATPDB READ WRITE YES

SQL>

SQL> alter session set container= UATPDB;

Session altered.

SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "TesT_1234#" container=Current;

keystore altered.

SQL>

[oracle@clouduatdb ~]$ ls -ltr /opt/oracle/dcs/commonstore/wallets/tde/UATCDB_jed1gh

[oracle@clouduatdb UATCDB_jed1gh]$ ls -ltr

total 112

-rw------- 1 oracle asmadmin 2555 Jun 2 09:39 ewallet_2021060209390371_defaultTag.p12

-rw------- 1 oracle asmadmin 5819 Jun 2 09:39 ewallet.p12_uatdefault

-rw------- 1 oracle asmadmin 5864 Jun 2 09:39 cwallet.sso_uatdefault

-rw-r--r-- 1 oracle asmadmin 2612 Jun 27 13:38 masterkey.bkp

-rw-r--r-- 1 oracle asmadmin 9211 Jun 27 13:39 ewallet_2021062713391205.p12

-rw------- 1 oracle asmadmin 9211 Jun 28 13:16 ewallet_2021062813163988.p12

-rw-r--r-- 1 oracle asmadmin 2612 Jun 29 10:27 masterkey_exp.bkp

-rw------- 1 oracle asmadmin 9211 Jun 29 10:28 ewallet_2021062910281074.p12

-rw------- 1 oracle asmadmin 9211 Jun 29 10:28 ewallet.p12

-rw------- 1 oracle asmadmin 9256 Jun 29 10:28 cwallet.sso

[oracle@clouduatdb UATCDB_jed1gh]$

Worked red commands without giving UATCD_jed1gh or AHCCDEV_jed1rx folder

[oracle@clouduatdb tde]$ ls -ltr /opt/oracle/dcs/commonstore/wallets/tde

[oracle@clouduatdb tde]$ rm -rf /opt/oracle/dcs/commonstore/wallets/tde/masterkey*

SQL>

SQL> ADMINISTER KEY MANAGEMENT EXPORT ENCRYPTION KEYS WITH SECRET "TesT_1234#" to '/opt/oracle/dcs/commonstore/wallets/tde/masterkey5_exp.bkp' IDENTIFIED BY "TesT_1234#";

SQL> ADMINISTER KEY MANAGEMENT EXPORT ENCRYPTION KEYS WITH SECRET "TesT_1234#" to '/opt/oracle/dcs/commonstore/wallets/tde/UATCDB_jed1gh/masterkey_exp.bkp' IDENTIFIED BY "TesT_1234#";

keystore altered.

SQL> ADMINISTER KEY MANAGEMENT IMPORT KEYS WITH SECRET "TesT_1234#" from '/opt/oracle/dcs/commonstore/wallets/tde/masterkey5_exp.bkp' IDENTIFIED BY "TesT_1234#" with backup;

SQL> ADMINISTER KEY MANAGEMENT IMPORT KEYS WITH SECRET "TesT_1234#" from '/opt/oracle/dcs/commonstore/wallets/tde/UATCDB_jed1gh/masterkey_exp.bkp' IDENTIFIED BY "TesT_1234#" with backup;

keystore altered.

SQL>

SQL>show con_name

CON_NAME

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

UATPDB

SQL>

SQL> alter session set container=cdb$root;

Session altered.

SQL> alter pluggable database UATPDB close;

Pluggable database altered.

SQL> alter pluggable database UATPDB open read write;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 UATPDB READ WRITE NO

SQL>

Now Both mgd and wallet corrections done at CDB & PDB level.

PDB opened normally without restricted mode.

SQL>

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

WRL_PARAMETER

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

STATUS WALLET_TYPE

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

/opt/oracle/dcs/commonstore/wallets/tde/UATCDB_jed1gh/

OPEN PASSWORD

SQL>

SQL> alter session set container= UATPDB;

Session altered.

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

WRL_PARAMETER

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

STATUS WALLET_TYPE

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

/opt/oracle/dcs/commonstore/wallets/tde/UATCDB_jed1gh/

CLOSED UNKNOWN

SQL>

SQL> alter session set container=cdb$root;

Session altered.

SQL> ~~shutdown immediate~~

ORA-65011: ~~Pluggable database PRODPDB does not exist.~~

SQL> shut abort

SQL> startup

SQL> show pdbs (if it opened in restricted mode again close/open PDB)

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 UATPDB READ WRITE YES

SQL>

SQL> alter pluggable database UATPDB close;

Pluggable database altered.

SQL> alter pluggable database UATPDB open read write;

Pluggable database altered.

SQL> show pdbs (now it should not be in restricted mode)

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 UATPDB READ WRITE NO

SQL>

SQL> show parameter spfile;

NAME TYPE VALUE

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

spfile string /u01/app/oracle/product/12.1.0

.2/dbhome_1/dbs/spfileUATCDB.o

SQL>

SQL> show parameter service;

NAME TYPE VALUE

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

service_names string PRODPDB , PRODPDB_ebs_patch

SQL>

Do not add ebs_patch service now because when we run autoconifg at final it gives error.

Add only red color line. Any ways autoconfig will create service with ebspatch but it will not update in init file:

[oracle@clouduatdb ~]$ grep service_names $ORACLE_HOME/dbs/initUATCDB.ora

[oracle@clouduatdb ~]$

[oracle@clouduatdb ~]$ grep service_names $ORACLE_HOME/dbs/initUATCDB.ora

SQL> alter system set service_names='UATPDB' scope=both;

SQL> alter system set service_names='UATPDB' scope=both; (use this command only didn’t get error in autoconfig)

SQL>

SQL> alter system set service_names='UATPDB','UATPDB_ebs_patch' scope=both; (don’t use this ebs_patch command)

System altered.

SQL>

SQL> show parameter service;

NAME TYPE VALUE

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

service_names string UATPDB

SQL>

SQL> show parameter utl

NAME TYPE VALUE

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

create_stored_outlines string

utl_file_dir string /usr/tmp, /u01/OCI/fs1/inst/ap

ps/PRODPDB_ebscloudprodapp3/ap

pltmp, /u01/app/oracle/product

/12.1.0.2/dbhome_1/appsutil/ou

tbound/PRODPDB_prod1, /u02/OCI/

temp, /usr/tmp

SQL>

Update ult_file along with appltmp directory of Target APPS Server:

SQL> alter system set utl_file_dir='/usr/tmp','/u01/uat/fs1/inst/apps/UATPDB_uatcloudapp/appltmp','/usr/tmp' scope=spfile;

SQL> alter system set utl_file_dir='/usr/tmp','/u01/uat/fs1/inst/apps/UATPDB_uatcloudapp/appltmp','/usr/tmp' scope=spfile; (for dev appltmp location)

System altered.

SQL>

SQL> create pfile from spfile;

File created.

SQL>

[oracle@clouduatdb ~]$ grep service_names $ORACLE_HOME/dbs/initUATCDB.ora

*.service_names='UATPDB'

[oracle@clouduatdb ~]$ grep utl $ORACLE_HOME/dbs/initUATCDB.ora

*.utl_file_dir='/usr/tmp','/u01/uat/fs1/inst/apps/UATPDB_uatcloudapp/appltmp','/usr/tmp'

[oracle@clouduatdb ~]$

[oracle@clouduatdb ~]$ grep service_names $ORACLE_HOME/dbs/initUATCDB.ora

*.service_names='UATPDB'

[oracle@clouduatdb ~]$ grep utl $ORACLE_HOME/dbs/initUATCDB.ora

*.utl_file_dir='/usr/tmp','/u01/uat/fs1/inst/apps/UATPDB_uatcloudapp/appltmp','/usr/tmp'

[oracle@clouduatdb ~]$

SQL>

SQL> shut immediate;

ORACLE instance shut down.

SQL>

SQL> startup;

SQL> show parameter spfile;

NAME TYPE VALUE

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

spfile string /u01/app/oracle/product/12.1.0

.2/dbhome_1/dbs/spfileUATCDB.o

SQL>

SQL> show parameter utl

NAME TYPE VALUE

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

create_stored_outlines string

utl_file_dir string /usr/tmp, /u01/uat/fs1/inst/ap

ps/UATPDB_uatcloudapp/applt

mp, /usr/tmp

SQL> show parameter service;

NAME TYPE VALUE

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

service_names string UATPDB

SQL>

alter session set container=cdb$root;

show pdbs

alter pluggable database UATPDB close;

alter pluggable database UATPDB open read write;

show pdbs

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 UATPDB READ WRITE YES

SQL>

SQL> alter pluggable database UATPDB close; (verify by close and open if required)

Pluggable database altered.

SQL>

SQL> alter pluggable database UATPDB open read write;

Pluggable database altered.

SQL>

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 UATPDB READ WRITE NO

SQL>

check the listener status ebs_patch added to service, it should not as we removed.

[oracle@clouduatdb ~]$ echo $ORACLE_SID

UATCDB

[oracle@clouduatdb ~]$ lsnrctl status $ORACLE_SID

Service "UATPDB_ebs_patch" (Will not be there)

Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora (need to update)

Services Summary...

Service "AHCICDBXDB" has 1 instance(s).

Instance "UATCDB", status READY, has 2 handler(s) for this service...

Service "AJARDB" has 1 instance(s).

Instance "UATCDB", status READY, has 2 handler(s) for this service...

Service "UATCDB_jed1gh" has 1 instance(s).

Instance "UATCDB", status READY, has 2 handler(s) for this service...

Service "UATPDB" has 1 instance(s).

Instance "UATCDB", status READY, has 2 handler(s) for this service...

The command completed successfully

Most important Step to recreate listener and tns files for EBS: (approx. time 5 mins)

[oracle@clouduatdb ~]$ cd $ORACLE_HOME/appsutil/clone/bin

defining $ORACLE_HOME has worked

[oracle@clouduatdb bin]$ perl adcfgclone.pl dbconfig $ORACLE_HOME/appsutil/UATPDB_clouduatdb.xml

[oracle@clouduatdb bin]$ perl adcfgclone.pl dbconfig /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/UATPDB_clouduatdb.xml

[oracle@clouduatdb ~]$ lsnrctl status $ORACLE_SID

Service "UATPDB_ebs_patch" (Will be added)

Service

If got any error then add this below parameter and retry, all the listener services should point to this listener obly:

SQL> alter system set listener_networks='(( NAME=net1)(LOCAL_LISTENER=(ADDRESS=(PROTOCOL=TCP)(HOST=192.172.9.13)(PORT=1531))))' scope=spfile;

SQL> shut immediate

SQL> startup

show pdbs

alter pluggable database UATPDB close;

alter pluggable database UATPDB open read write;

show pdbs

[oracle@clouduatdb bin]$ perl adcfgclone.pl dbconfig $ORACLE_HOME/appsutil/UATPDB_clouduatdb.xml

Now Run Autoconfig on database Tier:

[oracle@clouduatdb ~]$ . $ORACLE_HOME/UATPDB_clouduatdb.env

[oracle@clouduatdb ~]$ sqlplus apps/appspasswd@UATPDB

[oracle@clouduatdb ~]$ sqlplus apps/appsr12_2_9@UATPDB

SQL> select NODE_NAME from fnd_nodes;

NODE_NAME

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

CLOUDUATDB

SQL> exec fnd_conc_clone.setup_clean;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL>

Before running autoconfig with check ebs_patch service added to litener or not

Need to check: If already there in service, high chance to get below error in autoconfig

[oracle@clouduatdb ~]$ echo $ORACLE_SID

UATPDB

[oracle@clouduatdb ~]$ lsnrctl status $ORACLE_SID

Service "UATPDB_ebs_patch" has 1 instance(s).

[oracle@clouduatdb ~]$ perl $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh

[oracle@clouduatdb UATPDB_clouduatdb]$ adautocfg.sh

AutoConfig completed successfully.

Now ebs_patch named serveice should be added to listener by autoconfig.

If required now create a pfile and check service in pfile ebs_patch added or not.?

If autconfig completed successfully, then database cloning is completed:

Perform the post duplication steps to remove the 2nd node log files and undo tablespace

SQL> show user

USER is "SYS"

SQL> 

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

         2 PDB$SEED                       READ ONLY  NO

         3 UATPDB                         READ WRITE NO

SQL> 

SQL> select THREAD#, STATUS, ENABLED from v$thread;

   THREAD# STATUS ENABLED

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

         1 OPEN   PUBLIC

         2 CLOSED PUBLIC

SQL> select group# from V$log where THREAD#=2;

    GROUP#

----------

3

4

SQL> alter session set container=cdb$root;

Session altered.

SQL>

SQL> select THREAD#, STATUS, ENABLED from v$thread;

select group# from V$log where THREAD#=2;

alter database disable thread 2;
alter database drop logfile group 3;
alter database drop logfile group 4;
select THREAD#, STATUS, ENABLED from v$thread;

   THREAD# STATUS ENABLED

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

         1 OPEN   PUBLIC

SQL> 

SQL> show parameter undo

Check system password status for apps patching and expdp:

SQL> select username,account_status,EXPIRY_DATE from dba_users where username like 'SYSTEM';

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

To fix adop ETCC Codelevel checker patch

It is necessary to run check db atleast 1 time on cloned instance, else adop prepare phase will fail

[oracle@clouduatdb etcc]$ ls -ltrh $ORACLE_HOME/appsutil/etcc/check*

[oracle@clouduatdb etcc]$ unzip p17537119_R12_GENERIC.zip

[oracle@clouduatdb etcc]$ . $ORACLE_HOME/UATPDB_clouduatdb.env

[oracle@clouduatdb etcc]$ echo $ORACLE_SID

UATPDB

[oracle@clouduatdb etcc]$ sh $ORACLE_HOME/appsutil/etcc/checkDBpatch.sh ß mandatory, if not adop will fail when ever used on instance

applahc@ahcsc1zioclient020302:~/ETCC$ ./checkMTpatch.sh

[oratest@ebstestdb: ~]

Run autconfig again

[oracle@clouduatdb ~]$ perl $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh
[oracle@clouduatdb u]$ adautocfg.sh
AutoConfig completed successfully.

################################################################################################################

################################################################################################################

Additional steps to reconfigure DB to Cluster

Update db uniqe name to rejoin cluster

SQL> create pfile='$ORACLE_HOME/dbs/initUATCDB_09022022.ora' from spfile;

SQL> alter system set db_unique_name='UATCDB_jed1gh' scope=spfile;

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 UATPDB READ WRITE YES

SQL> alter pluggable database UATPDB close;

Pluggable database altered.

SQL> alter pluggable database UATPDB open read write;

Pluggable database altered.

SQL> sho pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

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

2 PDB$SEED READ ONLY NO

3 UATPDB READ WRITE NO

SQL>

[oracle@clouduatdb ~]$ cat /etc/oratab

#UATCDB:/u01/app/oracle/product/12.1.0.2/dbhome_1:N

UATCDB_jed1gh:/u01/app/oracle/product/12.1.0.2/dbhome_1:N

[oracle@clouduatdb ~]$

[oracle@clouduatdb ~]$ srvctl add database -d UATCDB_jed1gh -n UATCDB -o /u01/app/oracle/product/12.1.0.2/dbhome_1

[oracle@clouduatdb ~]$

[oracle@clouduatdb ~]$ srvctl add instance -d UATCDB_jed1gh -i UATCDB -n clouduatdb

[oracle@clouduatdb ~]$ echo $ORACLE_UNQNAME

UATCDB_jed1gh

[oracle@clouduatdb ~]$ srvctl config database -d $ORACLE_UNQNAME

Database unique name: UATCDB_jed1gh

Database name:

Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_1

Oracle user: oracle

Spfile:

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups:

Mount point paths:

Services:

Type: RAC

Start concurrency:

Stop concurrency:

OSDBA group: oinstall

OSOPER group: oinstall

Database instances: UATCDB

Configured nodes: clouduatdb

Database is administrator managed

[oracle@clouduatdb ~]$

[oracle@clouduatdb ~]$ srvctl status database -d $ORACLE_UNQNAME

Instance UATCDB is not running on node clouduatdb

[oracle@clouduatdb ~]$ srvctl start database -d $ORACLE_UNQNAME

alter session set container=cdb$root;

show pdbs

alter pluggable database DEVPDB close;

alter pluggable database DEVPDB open read write;

show pdbs

[oracle@clouduatdb appsutil]$ grep unique $ORACLE_HOME/appsutil/UATPDB_clouduatdb.xml

<cdb_unique_name oa_var="s_cdb_unique_name">UATCDB_jed1gh</cdb_unique_name>

[oracle@clouduatdb appsutil]$

[oracle@clouduatdb ~]$ . $ORACLE_HOME/UATPDB_clouduatdb.env

[oracle@clouduatdb ~]$ perl $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh

[oracle@clouduatdb UATPDB_clouduatdb]$ ./adautocfg.sh

Update SPFILE to ASM

[oracle@clouduatdb ~]$ rman target /

RMAN> backup spfile;

RMAN> restore spfile to '+DATA';

RMAN>

ASMCMD [+data/uatcdb] > ls

BFC7541A9666806AE0533C0AA8AC1270/

C22549CD17D50517E0533C0AA8AC365B/

CHANGETRACKING/

CONTROLFILE/

DATAFILE/

TEMPFILE/

spflie

ASMCMD [+data/uatcdb] >

[oracle@clouduatdb ~]$ srvctl config database -d $ORACLE_UNQNAME

Spfile: +DATA/UATCDB_JED1GH/PARAMETERFILE/spfile.439.1098806737

[oracle@clouduatdb ~]$ srvctl stop database -d $ORACLE_UNQNAME

[oracle@clouduatdb ~]$ srvctl start database -d $ORACLE_UNQNAME

[oracle@clouduatdb ~]$ !sq

alter pluggable database DEVPDB close;

alter pluggable database DEVPDB open read write;

SQL> show parameter spfile;

NAME TYPE VALUE

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

spfile string +DATA/UATCDB_JED1GH/PARAMETERFILE/spfile.439.1098806737

SQL>

[oracle@clouduatdb ~]$ ls -ltrh $ORACLE_HOME/dbs/spfile*.ora* $ORACLE_HOME/dbs/initUATCDB.ora

[oracle@clouduatdb ~]$ cp $ORACLE_HOME/dbs/initUATCDB.ora $ORACLE_HOME/dbs/initUATCDB.ora_bkp4

[oracle@clouduatdb ~]$ echo +DATA/UATCDB_JED1GH/PARAMETERFILE/spfile.439.1098806737 > $ORACLE_HOME/dbs/initUATCDB.ora

[oracle@clouduatdb ~]$ cat $ORACLE_HOME/dbs/initUATCDB.ora

+DATA/UATCDB_JED1GH/PARAMETERFILE/spfile.439.1098806737

[oracle@clouduatdb ~]$

[oracle@clouduatdb ~]$ srvctl modify database -d orclcdb -spfile '+DATA/UATCDB/spfile'

Update password file to ASM is still required (same as prod)

Reverify all details of DB

[root@clouduatdb ~]# dbcli describe-component

[root@clouduatdb ~]# dbcli list-jobs|tail -5

[root@clouduatdb ~]# dbcli describe-job -i <failed job id for xxx> -l Verbose

[root@clouduatdb ~]# dbcli describe-latestpatch

[root@clouduatdb ~]# dbcli list-dbstorages

[root@clouduatdb ~]# dbcli list-dbhomes

[root@clouduatdb ~]# dbcli list-databases

[root@clouduatdb ~]# dbcli describe-database -in UATCDB

[root@clouduatdb ~]# 

[oracle@clouduatdb ~]# srvctl config database

[oracle@clouduatdb ~]# srvctl config database -d $ORACLE_UNQNAME

################################################################################################################

################################################################################################################

Check below of the file for APPS Cloning initial Steps:

Correct inventory before running adcfg on apps

[oracle@clouduatdb UATPDB_clouduatdb]$ lsnrctl status UATCDB

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 03-AUG-2021 22:43:26

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=clouduatdb.uatsn.cloudprdvcn1.oraclevcn.com)(PORT=1521)))

STATUS of the LISTENER

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

Alias UATCDB

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 03-AUG-2021 21:12:30

Uptime 0 days 1 hr. 30 min. 56 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/12.1.0.2/dbhome_1/log/diag/tnslsnr/clouduatdb/UATCDB/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clouduatdb.uatsn.cloudprdvcn1.oraclevcn.com)(PORT=1521)))

Services Summary...

Service "PRODCDBXDB" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Service "UATCDB" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Service "UATPDB_ebs_patch" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Service "UATPDB" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@clouduatdb UATPDB_clouduatdb]$

Check db alert log

[root@clouduatdb bin]# tailf /u01/app/oracle/diag/rdbms/UATCDB/UATCDB/trace/alert_UATCDB.log

There should no tns error and warnings like.

Fatal NI connect error 12170.

TNS-12535: TNS:operation timed out

If autoconfig is not completed successfully the follow below steps remove ebs_patch in spfile and retry

[oracle@clouduatdb bin]$

[oracle@clouduatdb bin]$ lsnrctl status uatcdb

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 29-JUN-2021 11:09:29

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=clouduatdb.uatsn.cloudprdvcn1.oraclevcn.com)(PORT=1521)))

STATUS of the LISTENER

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

Alias UATCDB

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 29-JUN-2021 08:38:52

Uptime 0 days 2 hr. 30 min. 37 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/UATPDB_clouduatdb/listener.ora

Listener Log File /u01/app/oracle/product/12.1.0.2/dbhome_1/admin/UATPDB_clouduatdb/diag/tnslsnr/clouduatdb/uatcdb/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clouduatdb.uatsn.cloudprdvcn1.oraclevcn.com)(PORT=1521)))

Services Summary...

Service "PRODCDBXDB" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Service "UATCDB" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Service "UATPDB" has 2 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Instance "UATPDB", status UNKNOWN, has 1 handler(s) for this service...

Service "UATPDB_ebs_patch" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@clouduatdb bin]$

Autoconfig ERROR Solution/Fix (start listener with CDB )

Here the CDB Listener is using PDB File to fix it follow below:

If listener is not using $ORACLE_HOME/network/admin/listener.ora then autoconfig fails with error

WARNING: [CVM Error Report]

The following report lists errors encountered during CVM Phase

/u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/bin/txkSetADOPPatchSrvName.sh 1

No. of scripts failed in CVM phase: 1

AutoConfig is exiting with status 1

[oracle@clouduatdb UATPDB_clouduatdb]$

[oracle@clouduatdb ~]$ echo $ORACLE_SID

UATCDB

[oracle@clouduatdb ~]$

[oracle@clouduatdb ~]$ . $ORACLE_HOME/UATPDB_clouduatdb.env

[oracle@clouduatdb ~]$

[oracle@clouduatdb ~]$ echo $ORACLE_SID

UATPDB

[oracle@clouduatdb ~]$ cd $ORACLE_HOME/appsutil/scripts/UATPDB_clouduatdb

[oracle@clouduatdb UATPDB_clouduatdb]$ addlnctl.sh stop UATCDB

[oracle@clouduatdb UATPDB_clouduatdb]$ . $ORACLE_HOME/UATCDB_clouduatdb.env

[oracle@clouduatdb UATPDB_clouduatdb]$ echo $ORACLE_SID

UATCDB

[oracle@clouduatdb UATPDB_clouduatdb]$ adcdblnctl.sh start UATCDB

[oracle@clouduatdb UATPDB_clouduatdb]$ lsnrctl status uatcdb

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 30-JUN-2021 09:00:14

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=clouduatdb.uatsn.cloudprdvcn1.oraclevcn.com)(PORT=1521)))

STATUS of the LISTENER

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

Alias uatcdb

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 30-JUN-2021 05:36:55

Uptime 0 days 3 hr. 23 min. 19 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/12.1.0.2/dbhome_1/log/diag/tnslsnr/clouduatdb/uatcdb/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clouduatdb.uatsn.cloudprdvcn1.oraclevcn.com)(PORT=1521)))

Services Summary...

Service "PRODCDBXDB" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Service "UATCDB" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Service "UATPDB" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Service "UATPDB_ebs_patch" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@clouduatdb UATPDB_clouduatdb]$

If any additional error in auto config due to Service names ebs_patch then stop and delete as below the autoconfig will create internally and will not shown in spfile/pfile:

ERROR DESCRIPTION:

(ORA-44303: service name exists

ORA-06512: at "SYS.DBMS_SERVICE_ERR", line 21

ORA-06512: at "SYS.DBMS_SERVICE", line 218

ORA-06512: at line 1 (DBD ERROR: OCIStmtExecute) at /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/bin/txkSetADOPPatchSrvName.pl line 511.

[oracle@clouduatdb ~]$ grep service_names $ORACLE_HOME/dbs/initUATCDB.ora

SQL> alter system set service_names='UATPDB' scope=both;

SQL> begin

DBMS_SERVICE.STOP_SERVICE(service_name =>'UATPDB_ebs_patch');

DBMS_SERVICE.DELETE_SERVICE(service_name =>'UATPDB_ebs_patch');

end;

SQL>

SQL> commit;

Commit complete.

SQL> create pfile from spfile;

File created.

SQL>

SQL> shut immediate

[oracle@clouduatdb ~]$ grep service_names $ORACLE_HOME/dbs/initUATCDB.ora

*.service_names='UATPDB'

[oracle@clouduatdb UATPDB_clouduatdb]$ echo $ORACLE_SID

UATCDB

[oracle@clouduatdb UATPDB_clouduatdb]$ lsnrctl status uatcdb (check whether ebs_patch service added or not)

[oracle@clouduatdb UATPDB_clouduatdb]$ . $ORACLE_HOME/UATPDB_clouduatdb.env

[oracle@clouduatdb UATPDB_clouduatdb]$

[oracle@clouduatdb UATPDB_clouduatdb]$ perl $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/log/UATPDB_clouduatdb/08031734/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /u01/app/oracle/product/12.1.0.2/dbhome_1

Value of s_dbcset is AR8MSWIN1256

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.

Value of s_dbcset is AR8MSWIN1256

Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.

Library orai18n.jar exists.

Classpath : :/u01/app/oracle/product/12.1.0.2/dbhome_1/jdbc/lib/ojdbc6.jar:/u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/java/xmlparserv2.jar:/u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/java:/u01/app/oracle/product/12.1.0.2/dbhome_1/jlib/netcfg.jar:/u01/app/oracle/product/12.1.0.2/dbhome_1/jlib/ldapjclnt12.jar:/u01/app/oracle/product/12.1.0.2/dbhome_1/jlib/orai18n.jar

Using Context file : /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/UATPDB_clouduatdb.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db121

Updating rdbms type in Context file to 64 bits

Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.

[oracle@clouduatdb UATPDB_clouduatdb]$

[oracle@clouduatdb UATPDB_clouduatdb]$ lsnrctl status UATCDB

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 03-AUG-2021 17:36:38

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=clouduatdb.uatsn.cloudprdvcn1.oraclevcn.com)(PORT=1521)))

STATUS of the LISTENER

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

Alias UATCDB

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 03-AUG-2021 17:29:06

Uptime 0 days 0 hr. 7 min. 31 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0.2/dbhome_1/network/admin/listener.ora

Listener Log File /u01/app/oracle/product/12.1.0.2/dbhome_1/log/diag/tnslsnr/clouduatdb/UATCDB/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clouduatdb.uatsn.cloudprdvcn1.oraclevcn.com)(PORT=1521)))

Services Summary...

Service "PRODCDBXDB" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Service "UATCDB" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Service "UATPDB" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

Service "UATPDB_ebs_patch" has 1 instance(s).

Instance "UATCDB", status READY, has 1 handler(s) for this service...

The command completed successfully

[oracle@clouduatdb UATPDB_clouduatdb]$

Check db alert log

SELECT value from v$diag_info where name='Diag Trace';

[root@clouduatdb bin]# tailf /u01/app/oracle/diag/rdbms/UATCDB/UATCDB/trace/alert_UATCDB.log

There should no tns error and warnings.

Fatal NI connect error 12170.

TNS-12535: TNS:operation timed out

Below this not required for DB Cloning:

After the pdb status is o run below:

Cd $ORACLE_HOME/appsutil/install/UATPDB_clouduatdb

sqlplus / as sysdba @adupdlib.sql so

Section 5: Clone and Configure the Application Tier
5.1 Copy the Application Tier File System from the Source Node to the Target Node
5.2 Configure the Target System Application Tier Nodes

and prepare apps tier for cloning. Setting up oraInventory before adcfg on apps:

Before mv oraInst.loc in 10.1.2 home and remove old entries from global inventory

This will be recreated if there is only one application running on server.

[applmgr@uatcloudapp ~]$ cd /u01/uat/fs1/EBSapps/10.1.2/

[applmgr@uatcloudapp 10.1.2]$ mv oraInst.loc oraInst.loc_03082021

[applmgr@uatcloudapp ~]$ find /u01/uat/fs1 -iname oraInst.loc*

/u01/uat/fs1/EBSapps/10.1.2/oraInst.loc_03082021

[applmgr@uatcloudapp ~]$ cat /etc/oraInst.loc

inventory_loc=/home/applmgr/oraInventory

inst_group=oinstall

[applmgr@uatcloudapp ~]$

[applmgr@uatcloudapp ~]$ cd /home/applmgr/oraInventory

[applmgr@uatcloudapp oraInventory]$ ls -ltr

total 32

drwxrwx---. 2 applmgr oinstall 22 Jun 24 07:42 oui

drwxrwx---. 7 applmgr oinstall 4096 Jun 24 08:56 backup

-rw-rw----. 1 applmgr oinstall 303 Jun 24 08:58 oraInstaller.properties

drwxrwx---. 2 applmgr oinstall 4096 Jun 24 09:00 Contents

-rw-rw----. 1 applmgr oinstall 37 Jun 24 09:00 install.platform

drwxrwx---. 2 applmgr oinstall 4096 Aug 3 17:38 ContentsXML

drwxrwx---. 2 applmgr oinstall 8192 Aug 3 17:53 logs

[applmgr@uatcloudapp oraInventory]$ rm -rf *

[applmgr@uatcloudapp oraInventory]$

[applmgr@uatcloudapp oraInventory]$ ls -ltr

total 0

[applmgr@uatcloudapp oraInventory]$

Finally run adcfgclone: <- update sslterminator immediately after dual fs

[root@uatcloudapp u01]#

[root@uatcloudapp u01]# chown -R applmgr:oinstall /u01/uat (approx. 20 mins)

[applmgr@uatcloudapp ~]$ mkdir -p /u01/uat/fs2

[applmgr@uatcloudapp ~]$ du -sh /u01/uat

65G /u01/uat

[applmgr@uatcloudapp ~]$ cd /u01/AHCTEST/fs2/EBSapps/comn/clone/bin

export TIMEDPROCESS_TIMEOUT=-1

export CONFIG_JVM_ARG="-Xms1024m -Xmx2048m"

export CONFIG_JVM_ARG="-Xms2048m -Xmx4096m"

echo $CONFIG_JVM_ARG

perl adcfgclone.pl appsTier dualfs

Enter PDB name for DB UATPDB

Remove https login from context file after completing dualfs in OCI

[applmgr@uatcloudapp ~]$ grep sslterminator $CONTEXT_FILE (update ssl setting before running autoconfig replace with below line / add yellow part)

Important Variable of Context file which need update after clone:

cp $CONTEXT_FILE ~

grep sslterminator $CONTEXT_FILE  ß update # to stop redirecting to https in login page

grep deny $EBS_DOMAIN_HOME/config/config.xml  ß deny
grep site_name $CONTEXT_FILE   (Site name update)
grep s_wfmail_agent $CONTEXT_FILE   (for WFM Profile)
grep networkRetries $ORA_CONFIG_HOME/10.1.2/forms/server/appsweb.cfg (value 30)
grep FORMS_CATCHTERM $ORA_CONFIG_HOME/10.1.2/forms/server/default.env (value 0)
grep s_forms_catchterm $CONTEXT_FILE  (Doc ID 745711.1) (Doc ID 744143.1)
grep s_forms_time $CONTEXT_FILE

For Workflow mailer Account update from itinfocloudp to itinfocloudt
grep s_javamailer_reply_to $CONTEXT_FILE
grep s_javamailer_imap_user $CONTEXT_FILE
grep s_javamailer_outbound_user $CONTEXT_FILE
 
grep s_javamailer_imaphost $CONTEXT_FILE
grep s_javamailer_imapdomainname $CONTEXT_FILE
grep s_smtphost $CONTEXT_FILE
grep s_smtpdomainname $CONTEXT_FILE

Workflow Mailer Profile (Doc ID 2493004.1)
Make Sure if you have load balancer configured for the application, then you have to provide site value as per your primary node and remove "s" if ssl is configured use below variable of context file and build value as shown in example:
grep s_wfmail_agent $CONTEXT_FILE   (for WFM Profile)
grep s_webhost $CONTEXT_FILE
grep s_domainname $CONTEXT_FILE
grep s_webport $CONTEXT_FILE
Ex: http://myhost.mydomain.com:8000
WF: Workflow Mailer Framework Web Agent
Site: URL without s in https: grep login $CONTEXT_FILE

You need to run autoconfig again if updated any further in xml file

After cloning before starting the services perform post clone steps to cancel schedule requests and wf mails change apps pswd reduce FNDLIBR.

Follow here to continue post clone steps in APPS:

EBS R12.2.9 Full Clone With RMAN Duplicate

Check whether given Application ports RFS/PFS including weblogic server ports are open or not in OCI:

[root@ebstestapp ~]# sudo firewall-cmd --list-all

public (active)

  target: default

  icmp-block-inversion: no

  interfaces: ens3

  sources:

  services: dhcpv6-client ssh

  ports: 8002/tcp 7003/tcp 7021/tcp

  protocols:

  masquerade: no

  forward-ports:

  source-ports:

  icmp-blocks:

  rich rules:

[root@ebstestapp ~]#

APPS Tier Cloning is Completed Successfully:

Steps need to be done after ceating new server in OCI:

RPM’s and Preinstall Steps:

# yum -y install oracle-ebs-server-R12-preinstall

# yum -y install openmotif21

# yum -y install xorg-x11-libs-compat

set oracle Central Inventory cat /etc/oraInst.loc

update /etc/hosts add database server entries

user applmgr user to untar the file or will take lot of time execute chow command

tar-xvzf 2021-06-21-fs1.tar.gz -C /u01/uat

Open port for Newly created Apps(Compute) in OCI: (only on new server installation or new/extra APPS Port)

firewall-cmd --list-all

systemctl status firewalld

sudo firewall-cmd --permanent --add-port=8001/tcp

sudo firewall-cmd --reload

now start the services…..

also open the weblogic console port….

sudo firewall-cmd --permanent --add-port=7002/tcp

sudo firewall-cmd –reload

Install CUPS for printing service on Newly created Apps(Compute) in OCI ….

[root@uatcloudapp ~]# yum -y install cups

[root@uatcloudapp ~]# rpm -qa cups

cups-1.6.3-51.el7.x86_64

[root@uatcloudapp ~]#

[root@uatcloudapp ~]# systemctl status cups

● cups.service - CUPS Printing Service

Loaded: loaded (/usr/lib/systemd/system/cups.service; enabled; vendor preset: enabled)

Active: inactive (dead)

[root@uatcloudapp ~]#

[root@uatcloudapp ~]# systemctl stop cups

[root@uatcloudapp ~]#

[root@uatcloudapp ~]# systemctl start cups

[root@uatcloudapp ~]#

● cups.service - CUPS Printing Service

Loaded: loaded (/usr/lib/systemd/system/cups.service; enabled; vendor preset: enabled)

Active: active (running) since Tue 2021-08-10 08:08:03 GMT; 2s ago

Main PID: 8186 (cupsd)

Memory: 1.5M

CGroup: /system.slice/cups.service

└─8186 /usr/sbin/cupsd -f

Aug 10 08:08:03 uatcloudapp systemd[1]: Started CUPS Printing Service.

[root@uatcloudapp ~]# lpadmin -p testprinter -E -v socket://192.168.140.20

APPS Tier Cloning is Completed Successfully:

root@ebsprodapp3:~#

Thanks for Reading

Regards,

Mohammed Areefuddin.

Suggested Topics :

Linux	DATABASE	RMAN	RAC	EBS
5.7 Install	DATABASE Install		11201 Install	R1226 Install
Open Filer Instl	Active DataGaurd	Rman DataGuard	12102 RAC INSTAL	R1229 M7 Clone
DNS in Linux 7	WIN-LINUX MIGRATE	RMAN DB CLONE	RAC DataGuard	Pluggable DB Clone
lpadmin cups	ASMCMD ASM Migrt	RMAN ASM Migrt	RAC DB Clone	appsutil for DB
	11204 M-Upgrade		RAC - RAC Clone	JDK JRE upgrade
	12102 M-Upgrade		12C-19C RAC UPGRADE	Add EBS Node
	Flashback DB			ADOP in R12.2.9
				12102 EBS UPGRADE
Linux Basics	DATABASE Basics	RMAN Basics	RAC Basic	EBS Basics

Sunday, December 19, 2021

EBS R12.2.9 Cloning for Pluggable EBS Database

No comments:

Post a Comment