Saturday, February 10, 2024

How to bounce the(restart) Apache server in Oracle EBS R12.2 ?

1. login to our EBS instance using the putty tool

2. login applmgr user

3. Set the Apps Environment file

applmgr 32497 1 0 Aug23 ? 00:00:00 /u01/applmgr/fs2/EBSapps/10.1.2/bin/tnslsnr APPS_VIS -inherit

[applmgr@visebsapp ~]$ cd /u01/applmgr

[applmgr@visebsapp applmgr]$ ls

03241000.log 04011141.log 04042229.log 04082046.log 08191303.log 08231914.log EBSapps.env fs1 fs2 fs_ne

[applmgr@visebsapp applmgr]$ . EBSapps.env

E-Business Suite Environment Information

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

RUN File System : /u01/applmgr/fs2/EBSapps/appl

PATCH File System : /u01/applmgr/fs1/EBSapps/appl

Non-Editioned File System : /u01/applmgr/fs_ne

DB Host: visebsdb.xyz.com Service/SID: VIS

E-Business Suite Environment Setting

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

- Enter [R/r] for sourcing Run File System Environment file, or

- Enter [P/p] for sourcing Patch File System Environment file, or

- Enter anything else to exit

Please choose the environment file you wish to source [R/P]:R

Sourcing the RUN File System ...

[applmgr@visebsapp applmgr]$

4. Go to $ADMIN_SCRIPTS_HOME

[applmgr@visebsapp applmgr]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@visebsapp scripts]$ ls

03292126.log adautocfg.sh adnodemgrctl.sh cz64bitengine.pl jtffmctl.sh shtiloglib.pl

05052013.log adcmctl.sh adopmnctl.sh EBSProvisioner.log msc

adadminsrvctl.sh adexecsql.pl adpreclone.pl gsmstart.sh mwactl.sh

adalnctl.sh adformsrvctl.sh adstpall.sh ieo mwactlwrpr.sh

adapcctl.sh admanagedsrvctl.sh adstrtal.sh java.sh pon64bitengine.pl

[applmgr@visebsapp scripts]$

5. To Stop the Apache server

adapcctl.sh stop

6. To Start the Apache server

adapcctl.sh start

7. check the status of the Apache Server

adapcctl.sh status

[applmgr@visebsapp scripts]$ adapcctl.sh status

You are running adapcctl.sh version 120.0.12020000.6

Checking status of OPMN managed Oracle HTTP Server (OHS) instance ...

Processes in Instance: EBS_web_OHS1

---------------------------------+--------------------+---------+---------

ias-component | process-type | pid | status

---------------------------------+--------------------+---------+---------

EBS_web | OHS | 32155 | Alive

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /u01/applmgr/fs2/inst/apps/VIS_visebsapp/logs/appl/admin/log/adapcctl.txt for more information ...

How executed adpreclone.pl in Database and Application oracle R12.2?

Database Side:

To check the database status

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

root 23 2 0 Jul16 ? 00:00:00 [netns]

oracle 25253 1 0 Aug08 ? 00:00:11 /visdb/oracle/12.1.0/bin/tnslsnr VIS -inherit

oracle 31468 31407 0 20:37 pts/0 00:00:00 grep --color=auto tns

To change the directory for ORACLE_HOME

[oracle@visebsdb ~]$ cd /visdb/oracle/12.1.0

[oracle@visebsdb 12.1.0]$ ls

addnode cv jlib ord sqldeveloper

admin dbs jpub oui sqlj

apex dc_ocm ldap owm sqlpatch

appsutil deinstall lib p32126886_121020_Linux-x86-64.zip.filepart sqlplus

appsutilbkp demo log perl srvm

appsutilbkp.zip VIS_visebsdb.env md plsql suptools

appsutil.zip diagnostics mgw plugins sysman

appsutil.zip_bkp23mar21 dmu network precomp temp

assistants dv nls QOpatch ucp

bin has oc4j R usm

ccr hs odbc racg utl

cdata install olap rdbms wwg

cfgtoollogs instantclient OPatch relnotes xdk

clone inventory OPatch25bkp rest

crs javavm opmn root.sh

css jdbc oracore scheduler

ctx jdk oraInst.loc slax

To source the environment file

[oracle@visebsdb 12.1.0]$ . VIS_visebsdb.env

To change the directory for adpreclone.pl

[oracle@visebsdb 12.1.0]$ cd appsutil

[oracle@visebsdb appsutil]$ ls

admin conf_VIS.txt driver install log outbound sql txkSetCfgCDB.cmd

bin VIS_visebsdb.xml etcc java media perl temp txkSetCfgCDB.env

clone VIS_visebsdb.xmlBKP16 html jre out scripts template

[oracle@visebsdb appsutil]$ cd clone/

[oracle@visebsdb clone]$ ls

bin context data dbts html jlib jre oui

[oracle@visebsdb clone]$ cd ..

[oracle@visebsdb appsutil]$ cd scripts/

[oracle@visebsdb scripts]$ ls

VIS_visebsdb

[oracle@visebsdb scripts]$ cd VIS_visebsdb/

[oracle@visebsdb VIS_visebsdb]$ ls

adautocfg.sh adchknls.pl addbctl.sh addlnctl.sh adexecsql.pl adlsnodes.sh adpreclone.pl adstopdb.sql adstrtdb.sql

To execute the adpreclone.pl

[oracle@visebsdb VIS_visebsdb]$ perl adpreclone.pl dbTier

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adpreclone Version 120.31.12020000.25

Enter the APPS User Password:

Verifying if Database Patch checker (ETCC) exists in /visdb/oracle/12.1.0/appsutil/etcc

Running:

perl /visdb/oracle/12.1.0/appsutil/bin/adclone.pl java=/visdb/oracle/12.1.0/appsutil/jre mode=stage stage=/visdb/oracle/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/visdb/oracle/12.1.0/appsutil/VIS_visebsdb.xml showProgress

Beginning database tier Stage - Sat Aug 14 20:37:52 2021

/visdb/oracle/12.1.0/appsutil/jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/visdb/oracle/12.1.0/oui -classpath /visdb/oracle/12.1.0/lib/xmlparserv2.jar:/visdb/oracle/12.1.0/jdbc/lib/ojdbc6.jar:/visdb/oracle/12.1.0/appsutil/java:/visdb/oracle/12.1.0/oui/jlib/OraInstaller.jar:/visdb/oracle/12.1.0/oui/jlib/ewt3.jar:/visdb/oracle/12.1.0/oui/jlib/share.jar:/visdb/oracle/12.1.0/oui/jlib/srvm.jar:/visdb/oracle/12.1.0/jlib/ojmisc.jar oracle.apps.ad.clone.StageDBTier -e /visdb/oracle/12.1.0/appsutil/VIS_visebsdb.xml -stage /visdb/oracle/12.1.0/appsutil/clone -tmp /tmp -method CUSTOM -showProgress

APPS Password :

Log file located at /visdb/oracle/12.1.0/appsutil/log/VIS_visebsdb/StageDBTier_08142037.log

/ 50% completed

Completed Stage...

Sat Aug 14 20:38:10 2021

[oracle@visebsdb VIS_visebsdb]$

Application Side:

To check the Application Status

[applmgr@visebsapp ~]$ ps -ef | grep tns

root 23 2 0 Jul16 ? 00:00:00 [netns]

applmgr 1816 1755 0 20:38 pts/0 00:00:00 grep --color=auto tns

applmgr 4210 1 0 Aug08 ? 00:00:00 /visapp/VIS/fs2/EBSapps/10.1.2/bin/tnslsnr APPS_VIS -inherit

[applmgr@visebsapp ~]$ cd /visapp/VIS

[applmgr@visebsapp applmgr]$ ls

03241000.log 04011141.log 04042229.log 04082046.log EBSapps.env fs1 fs2 fs_ne

To source the environment file

[applmgr@visebsapp applmgr]$ . EBSapps.env

E-Business Suite Environment Information

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

RUN File System : /visapp/VIS/fs2/EBSapps/appl

PATCH File System : /visapp/VIS/fs1/EBSapps/appl

Non-Editioned File System : /visapp/VIS/fs_ne

DB Host: visebsdb.xyz.com Service/SID: VIS

E-Business Suite Environment Setting

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

- Enter [R/r] for sourcing Run File System Environment file, or

- Enter [P/p] for sourcing Patch File System Environment file, or

- Enter anything else to exit

Please choose the environment file you wish to source [R/P]:R

Sourcing the RUN File System ...

To change the directory for ADMIN_SCRIPTS_HOME

[applmgr@visebsapp applmgr]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@visebsapp scripts]$ ls

03292126.log adautocfg.sh adnodemgrctl.sh cz64bitengine.pl jtffmctl.sh shtiloglib.pl

05052013.log adcmctl.sh adopmnctl.sh EBSProvisioner.log msc

adadminsrvctl.sh adexecsql.pl adpreclone.pl gsmstart.sh mwactl.sh

adalnctl.sh adformsrvctl.sh adstpall.sh ieo mwactlwrpr.sh

adapcctl.sh admanagedsrvctl.sh adstrtal.sh java.sh pon64bitengine.pl

To execute the adpreclone.pl

[applmgr@visebsapp scripts]$ perl adpreclone.pl appsTier

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adpreclone Version 120.31.12020000.25

Enter the APPS User Password:

Enter the Weblogic AdminServer password :

Checking the status of the Oracle WebLogic Administration Server....

Running perl /visapp/VIS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/visapp/VIS/fs2/inst/apps/VIS_visebsapp/appl/admin/VIS_visebsapp.xml -servername=AdminServer -promptmsg=hide

The Oracle WebLogic Administration Server is up.

wlsDomainName: EBS_domain

WLS Domain Name is VALID.

Running:

perl /visapp/VIS/fs2/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/visapp/VIS/fs2/EBSapps/comn/util/jdk64 mode=stage stage=/visapp/VIS/fs2/EBSapps/comn/clone component=appsTier method= appctx=/visapp/VIS/fs2/inst/apps/VIS_visebsapp/appl/admin/VIS_visebsapp.xml showProgress

Setting the wls environment

Beginning application tier Stage - Sat Aug 14 20:40:10 2021

/visapp/VIS/fs2/EBSapps/comn/util/jdk64/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /visapp/VIS/fs2/FMW_Home/webtier/lib/xmlparserv2.jar:/visapp/VIS/fs2/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/visapp/VIS/fs2/EBSapps/comn/java/classes:/visapp/VIS/fs2/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/visapp/VIS/fs2/FMW_Home/webtier/oui/jlib/ewt3.jar:/visapp/VIS/fs2/FMW_Home/webtier/oui/jlib/share.jar:/visapp/VIS/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/visapp/VIS/fs2/FMW_Home/webtier/jlib/ojmisc.jar:/visapp/VIS/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/visapp/VIS/fs2/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /visapp/VIS/fs2/inst/apps/VIS_visebsapp/appl/admin/VIS_visebsapp.xml -stage /visapp/VIS/fs2/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg

Log file located at /visapp/VIS/fs2/inst/apps/VIS_visebsapp/admin/log/clone/StageAppsTier_08142040.log

\ 20% completed

Completed Stage...

Sat Aug 14 20:44:50 2021

[applmgr@visebsapp scripts]$

Friday, February 9, 2024

Oracle EBS R12.2, Login Page doesn't not open

EBS_DOMAIN log where there was a stuck thread processing the AppsLocalLogin.jsp page

Error:

<Error> <WebLogicServer> <devebsapp.bescom.com> <oacore_server1> <[ACTIVE] ExecuteThread: '23' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0c3c553ba012d498:21ac6fdc:1789db30822:-8000-0000000000000756> <1617632797420> <BEA-000337> <[STUCK] ExecuteThread: '20' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "652" seconds working on the request "Workmanager: default, Version: 0, Scheduled=true, Started=true, Started time: 652083 ms

[

POST /OA_HTML/AppsLocalLogin.jsp? HTTP/1.1

Accept: */*

X-Service: AuthenticateUser

Content-type: application/x-www-form-urlencoded

Referer: http://devebsapp.bescom.com:8005/OA_HTML/AppsLocalLogin.jsp

Accept-Language: en-IN

Accept-Encoding: gzip, deflate

User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 10.0; WOW64; Trident/7.0; .NET4.0C; .NET4.0E; Zoom 3.6.0)

Content-Length: 72

Cache-Control: no-cache

Cookie: oracle.uix=0^I^GMT+5:30^p; treemenu1=0,1,34; JSESSIONID=QYGiYM_jdSFfrhsSPsxtse89sYdoTAfAHCcF7pLjOLpmakYnt436!1903357836; DEV=-1

ECID-Context: 1.005jndLPaYL9xWo6wVaeMG0000N0000041;kXjE

Connection: Keep-Alive

X-Forwarded-For: 10.212.134.200

Proxy-Client-IP: 10.212.134.200

X-WebLogic-KeepAliveSecs: 30

X-WebLogic-Force-JVMID: 1903357836

That was caused by the same issue described in the above note:

]", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:

java.net.SocketInputStream.socketRead0(Native Method)

java.net.SocketInputStream.read(SocketInputStream.java:152)

java.net.SocketInputStream.read(SocketInputStream.java:122)

oracle.net.nt.MetricsEnabledInputStream.read(TcpNTAdapter.java:730)

oracle.net.ns.Packet.receive(Packet.java:310)

oracle.net.ns.DataPacket.receive(DataPacket.java:108)

oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:325)

oracle.net.ns.NetInputStream.read(NetInputStream.java:269)

oracle.net.ns.NetInputStream.read(NetInputStream.java:191)

oracle.net.ns.NetInputStream.read(NetInputStream.java:108)

oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:126)

oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:82)

oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1178)

oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:314)

oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)

oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)

oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)

oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)

oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)

weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)

oracle.apps.fnd.common.DBPreferenceStore.save(DBPreferenceStore.java:485)

oracle.apps.fnd.login.lang.LanguageContext.recordLastSessionLanguage(LanguageContext.java:1047)

oracle.apps.fnd.sso.SessionMgr.createSession(SessionMgr.java:2479)

oracle.apps.fnd.sso.SessionMgr.createSession(SessionMgr.java:1107)

oracle.apps.fnd.sso.SessionMgr.createAppsSession(SessionMgr.java:3504)

oracle.apps.fnd.login.LoginHelper.doAuthenticate(LoginHelper.java:743)

oracle.apps.fnd.login.LoginHelper.callService(LoginHelper.java:1086)

oracle.apps.fnd.login.LoginHelper.service(LoginHelper.java:372)

_pages.__appslocallogin._jspService(__appslocallogin.java:194)

weblogic.servlet.jsp.JspBase.service(JspBase.java:34)

weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

Cause:

During execution test dependent on login at the same time hundreds or thousands of times with a similar client.
In case there are numerous users who have lapsed password and attempt to change the password simultaneously or then again assuming any client opens the terminated secret key screen and left without finishing, then, at that point, this conflict can happen.
The secret phrase stream is refreshing the inclination of LANGUAGE_CALC for Visitor client, because the real client can't associate until PW is reset,

Action Plan:

1. Please review Note 2578726.1 - High Number Of "enq: TX - Row Lock Contention" On FND_USER_PREFERENCES

2. Apply 30134567:R12.FND.C

3.adident Header $JAVA_TOP/oracle/apps/fnd/login/lang/LanguageContext.class

to verify the version is 120.0.12020000.15

4. Complete the following manual step to fix it

Add the following line to $INST_TOP/appl/admin/oacore_wls.properties and bounce

services:

oracle.fnd.language.rule.lastsession=disable

5. Retest the issue

Reference :

Note 2578726.1 - High Number Of "enq: TX - Row Lock Contention" On FND_USER_PREFERENCES

Oracle EBS R12.2 Cloning Using Cold Backup step by steps

Oracle EBS R12.2 Cloning

1.Source Database: DEV instance

/dev/backup/01AUG21/ORACLE_HOME_01AUG21.tar.gz

/dev/backup/01AUG21/DB_BACKUP_01AUG21.tar.gz

2.Backup move to Target database:

Backup move to Target database(TEST instance)

I.ORACLE_HOME Move to Test server

scp -P ORACLE_HOME.tar.gz 172.165.12.17:/testebsdb/TEST/db/tect_st/

II. Data Backup move to Target Instance (TEST)

scp -P DB_BACKUP_01AUG21.tar.gz 172.165.12.17:/testebsdb/TEST/db/apps_st/

3.Target Database: TEST Instance

1. untar the ORACLE_HOME Backup

cd /testebsdb/TEST/db/tect_st/

[oracle@ebs-db tech_st] tar -xvzf ORACLE_HOME.tar.gz

2. untar the DB backup

cd /testebsdb/TEST/db/apps_st/

[oracle@ebs-db apps_st] tar -xvzf DB_BACKUP_01AUG21.tar.gz

4.Export the PERL5LIB and PATH:

cd /testebsdb/TEST/db/tech_st/12.1.0/

export PERL5LIB=/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/5.14.1:/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/site_perl/5.14.1

export PATH=/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:$PATH

============================================================

racle@ebs-db appsutil]$ ls

admin clone DEV_devebsdb.xml etcc install jre media outbound scripts temp txkSetCfgCDB.cmd

bin conf_DEV.txt driver html java log out perl sql template txkSetCfgCDB.env

[oracle@ebs-db appsutil]$ cd clone/

[oracle@ebs-db clone]$ ls

bin context data dbts html jlib jre oui

[oracle@ebs-db clone]$ cd bin/

[oracle@ebs-db bin]$ pwd

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin

[oracle@ebs-db bin]$ ls

adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl

[oracle@ebs-db bin]$ export PERL5LIB=/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/5.14.1:/testebsdb/TEST/db/tech_st/12.1.0/perl/lib/site_perl/5.14.1

[oracle@ebs-db bin]$ export PATH=/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:/testebsdb/TEST/db/tech_st/12.1.0/perl/bin:$PATH

[oracle@ebs-db bin]$ ls

adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl

5.Database Cloning :

[oracle@ebs-db bin]$ perl adcfgclone.pl dbTier

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.65

Enter the APPS password :

Running: Context clone...

Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_0409114402.log

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

Target System Hostname (virtual or normal) [ebs-db] :

Target System Base Directory : /testebsdb/TEST

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

Target System Database SID : TEST

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

Target System utl_file_dir Directory List : /testebsdb/tmp

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

Target System DATA_TOP Directory 1 [/testebsdb/TEST/data] : /testebsdb/TEST/db/apps_st/data

Target System RDBMS ORACLE_HOME Directory [/testebsdb/TEST/12.1.0] : /testebsdb/TEST/db/tech_st/12.1.0

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

Target System Display [ebs-db:0.0] : ebs-db:1.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] : 10

Checking the port pool 10

done: Port Pool 10 is free

Report file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/temp/portpool.lst

The new database context file has been created :

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

Check Clone Context logfile /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_0409114402.log for details.

Running Rapid Clone with command:

Running:

perl /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/adclone.pl java=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml showProgress contextValidated=true

Beginning database tier Apply - Sun Aug 1 11:47:51 2021

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/testebsdb/TEST/db/tech_st/12.1.0/oui -classpath /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/xmlparserv2.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/java:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/ewt3.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/share.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml -stage /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone -showProgress

APPS Password : Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/ApplyDBTier_04091147.log

- 15% completed

Completed Apply...

Sun Aug 1 11:51:38 2021

Starting database listener for TEST:

Running:

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/scripts/TEST_ebs-db/addlnctl.sh start TEST

Logfile: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process TEST ...

Listener TEST has already been started.

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/addlnctl.txt for more information ...

Do you want to change the password for all EBS Schemas? (y/n) [n]) : n

Do you want to change the password for sysadmin user? (y/n) [n]) : n

Do you want to change the apps password? (y/n) [n]) : n

Do you want to change the sys and system passwords? (y/n) [n]) : n

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

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Database EBS Technology Codelevel Checker |

+===============================================================+

Validating context file: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

Using context file from command line argument:

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

Starting Database EBS Technology Codelevel Checker, Version 120.83

Sun Aug 1 11:52:47 IST 2021

Log file for this session : /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_26599.log

Identifying database release.

Database release set to 12.1.0.2.

Connecting to database.

Database connection successful.

Database TEST is in READ WRITE mode.

Identifying APPS and APPLSYS schema names.

- APPS schema : APPS

- APPLSYS schema : APPLSYS

Checking for DB-ETCC results table.

Table to store DB-ETCC results already exists in the database.

Checking if InMemory option is enabled.

InMemory option is not enabled in the database.

Bugfix file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.58

This file will be used for identifying missing bugfixes.

Mapping file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.33

This file will be used for mapping bugfixes to patches.

Identified RDBMS DST version 18.

Checking Bugfix XML file for 12.1.0.2_PSU

Obtained list of bugfixes to be applied and the list to be rolled back.

Now checking Database ORACLE_HOME.

The opatch utility is version 12.2.0.1.24.

DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2.210119

All the required one-off bugfixes are present in Database ORACLE_HOME.

Stored Technology Codelevel Checker results in the database TEST successfully.

Finished checking fixes for Oracle Database: Sun Aug 1 11:52:55 IST 2021

Log file for this session: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_26599.log

===============================================================================

Source the Database Environment file

[oracle@ebs-db 12.1.0]$ . TEST_ebs-db.env

[oracle@ebs-db 12.1.0]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 1 11:53:21 2021

Connected to:

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

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

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

TEST READ WRITE

SQL> show SGA;

Total System Global Area 2147483648 bytes

Fixed Size 2926472 bytes

Variable Size 469764216 bytes

Database Buffers 1660944384 bytes

Redo Buffers 13848576 bytes

SQL>

SQL> Exit

oracle@ebs-db 12.1.0]$ . TEST_ebs-db.env

[oracle@ebs-db 12.1.0]$ cd appsutil

[oracle@ebs-db appsutil]$ ls

admin clone etcc install jre media outbound scripts sql template txkSetCfgCDB.env

bin driver html java log out perl TEST_ebs-db.xml temp txkSetCfgCDB.cmd

[oracle@ebs-db appsutil]$ cd install/

[oracle@ebs-db install]$ ls

adlnkoh.sh TEST_ebs-db

[oracle@ebs-db install]$ cd TEST_ebs-db/

[oracle@ebs-db TEST_ebs-db]$ ls

adcctclean.sql adcrdbrdlg.sh addbperms.sh adsvdb.sh afdbprf.sql txkEBSWrapper.pl

adclobconv.sql adcrdb.sh addbprf.sh adsvdcnv.sh afmkinit.sh

adclobtmp.sql adcrobj.sh addbprf.sql adsvdlsn.sh txkConfigDbOcm.pl

adcmclean.sql adcrobj.sql addbupdgsm.sql adupdlib.sql txkcreateACL.sh

adcrdbclone.sql addbccnv.sql adlicnse.sql afdbprf.sh txkcreateACL.sql

6.[oracle@ebs-db TEST_ebs-db]$ sqlplus "/ as sysdba" @adupdlib.sql so

SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 1 13:10:33 2021

Connected to:

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

With the Partitioning, OLAP, Advanced Analytics, and Real Application Testing options

PL/SQL procedure successfully completed.

SQL> exit

cd [RDBMS ORACLE_HOME]/appsutil/clone/bin $ perl adcfgclone.pl dbconfig [Database target context file] Where Database target context file is: [RDBMS ORACLE_HOME]/appsutil/[Target CONTEXT_NAME].xml.

7.Context file Location :

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

perl adcfgclone.pl dbconfig /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.65

Enter the APPS password : <Dev Application Apps Password >

Running Rapid Clone with command:

Running:

perl /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/adclone.pl java=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml showProgress contextValidated=false

Beginning dbconfig Apply - Sun Aug 1 13:16:51 2021

adcfgclone Version 120.63.12020000.65

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/testebsdb/TEST/db/tech_st/12.1.0/oui -classpath /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/xmlparserv2.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/java:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/ewt3.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/share.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDatabase -e /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml -stage /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone -showProgress -noRmanRecovery yes -checkDBConnection

APPS Password : Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/ApplyDatabase_04091316.log

| 0% completed

Log file located at /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/ApplyDatabase_04091316.log

/ 30% completed

Completed Apply...

Sun Aug 1 13:17:51 2021

Starting database listener for TEST:

Running:

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/scripts/TEST_ebs-db/addlnctl.sh start TEST

Logfile: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process TEST ...

Listener TEST has already been started.

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /testebsdb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_ebs-db/addlnctl.txt for more information ...

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

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Database EBS Technology Codelevel Checker |

+===============================================================+

Validating context file: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

Using context file from command line argument:

/testebsdb/TEST/db/tech_st/12.1.0/appsutil/TEST_ebs-db.xml

Starting Database EBS Technology Codelevel Checker, Version 120.83

Fri Apr 9 13:17:51 IST 2021

Log file for this session : /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_4652.log

Identifying database release.

Database release set to 12.1.0.2.

Connecting to database.

Database connection successful.

Database TEST is in READ WRITE mode.

Identifying APPS and APPLSYS schema names.

- APPS schema : APPS

- APPLSYS schema : APPLSYS

Checking for DB-ETCC results table.

Table to store DB-ETCC results already exists in the database.

Checking if InMemory option is enabled.

InMemory option is not enabled in the database.

Bugfix file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.58

This file will be used for identifying missing bugfixes.

Mapping file /testebsdb/TEST/db/tech_st/12.1.0/appsutil/etcc/db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.33

This file will be used for mapping bugfixes to patches.

Identified RDBMS DST version 18.

Checking Bugfix XML file for 12.1.0.2_PSU

Obtained list of bugfixes to be applied and the list to be rolled back.

Now checking Database ORACLE_HOME.

The opatch utility is version 12.2.0.1.24.

DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2.210119

All the required one-off bugfixes are present in Database ORACLE_HOME.

Stored Technology Codelevel Checker results in the database TEST successfully.

Finished checking fixes for Oracle Database: Sun Aug 1 13:18:00 IST 2021

Log file for this session: /testebsdb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/log/checkDBpatch_4652.log

===============================================================================

[oracle@ebs-db bin]$

9.Application Cloning:

10.Source application: DEV Application

Backup of Location is /u01/applmgr/Backup/EBSAPPS_fs1_bkp01AUG21.tar.gz

Application Backup move to Target Server (TEST instance )

scp -P EBSAPPS_fs1_bkp01AUG21.tar.gz /testebsapp/TEST/fs1

untar the Application Backup file

tar -xvzf EBSAPPS_fs1_bkp01AUG21.tar.gz

cd /testebsapp/TEST/fs1/EBSapps/comn/clone/bin

applmgr@ebs-app bin]$ perl adcfgclone.pl appsTier dualfs

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.65

Enter the APPS password : <Dev Apps Password>

Enter the Weblogic AdminServer password :

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

Running: Context clone...

Log file located at /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_0409120727.log

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

Target System Hostname (virtual or normal) [ebs-app] :

Target System Database SID : TEST

Target System Database Server Node [ebs-app] : ebs-db

Target System Database Domain Name [xyz.com] :

Target System Base Directory : /testebsapp/TEST/

Target System Base Directory set to /testebsapp/TEST/

Target System Current File System Base set to /testebsapp/TEST/fs1

Target System Other File System Base set to /testebsapp/TEST//fs1

Target System Fusion Middleware Home set to /testebsapp/TEST/fs1/FMW_Home

Target System Other File System Fusion Middleware Home set to /testebsapp/TEST//fs1/FMW_Home

Target System Current File System Instance Top set to /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app

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

Target System Display [ebs-app:0.0] : ebs-app:1.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] : 10

Checking the port pool 10

done: Port Pool 10 is free

Report file located at /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/admin/out/portpool.lst

Target System proxy port [80] :

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp

2. /testebsdb/tmp

3. /testebsdb/TEST/db/tech_st/12.1.0/appsutil/outbound/TEST_ebs-db

4. /usr/tmp

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

The new APPL_TOP context file has been created :

/testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/appl/admin/TEST_ebs-app.xml

Check Clone Context logfile /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContext_0409120727.log for details.

Creating Patch file system context file.....

Log file located at /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0409122105.log

Target System Other File System Instance Top set to /testebsapp/TEST//fs1/inst/apps/TEST_ebs-app

Target System Port Pool [0-99] : 11

Checking the port pool 11

done: Port Pool 11 is free

Report file located at /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/admin/out/portpool.lst

The new APPL_TOP context file has been created :

/testebsapp/TEST//fs1/inst/apps/TEST_ebs-app/appl/admin/TEST_ebs-app.xml

Check Clone Context logfile /testebsapp/TEST/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0409122105.log for details.

FMW Pre-requisite check log file location : /testebsapp/TEST/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: FMW pre-req check...

Configuring: Run file system....

LogFile located at /testebsapp/TEST/fs1/inst/apps/TEST_ebs-app/admin/log/clone/run/RCloneApplyAppstier_08051221.log

Configuring: Patch file system....

LogFile located at /testebsapp/TEST/fs2/inst/apps/TEST_ebs-app/admin/log/clone/run/RCloneApplyAppstier_08051221.log

Other Topics:

Oracle EBS R12.2 Cloning using RMAN Backup Step by Steps

1.Execute the adpreclone.pl both application and database.

2.Move the RMAN Backup, database ORACLE HOME, and application backup to the target server.

Source Database: PROD

Target Database: TEST

Backup Details (PROD): /prod/rman_backup/15Jul2021_bkp

Database backup move to target Server (testdb) :

*****************************************************

Copy Command from Source (PROD) server to Target server(TEST)

scp -P 15Jul2021_bkp oracle@172.165.12.15:/test/rman_backup/

scp -P Oracle_Home_bkp15Jul2021.tar.gz oracle@172.165.12.15:/oracledb/TEST/db/tech_st/

The Backup location is /test/rman_backup/15Jul2021_bkp

Application Backup move to target Server:

**********************************************

Copy Command from Source(PROD) server to Target server(TEST)

scp -P EBSapps.tar.gz applmgr@172.165.12.16:/test/applmgr/

The backup Location is /test/applmgr/EBSapps.tar.gz

Untar the backup

tar -xvzf EBSapps.tar.gz

I ) Database Cloning :

Untar the Oracle_home backup file

cd /oracledb/TEST/db/tech_st/

Oracle_Home_bkp15Jul2021.tar.gz

tar -xvzf Oracle_Home_bkp15Jul2021.tar.gz

[oracle testdb tech_st] 12.1.0

[oracle testdb tech_st] cd 12.1.0

Export PERL5LIB and PATH

export PERL5LIB=/oracledb/TEST/db/tech_st/12.1.0/perl/lib/5.14.1:/oracledb/TEST/db/tech_st/12.1.0/perl/lib/site_perl/5.14.1

export PATH=/oracledb/TEST/db/tech_st/12.1.0/perl/bin:/oracledb/TEST/db/tech_st/12.1.0/bin:$PATH

cd /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin

[oracle@testdb bin]$ perl adcfgclone.pl dbTechStack

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password : <Source<PROD> Apps Password>

Running: Context clone...

Log file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_1004214819.log

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

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

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

Target System Database SID : TEST

Target System Base Directory : /oracledb/TEST

Target System utl_file_dir Directory List : /usr/tmp

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

Target System DATA_TOP Directory 1 : /oracledb/TEST/apps_st/data

Target System RDBMS ORACLE_HOME Directory [/oracledb/TEST/12.1.0] : /oracledb/TEST/db/tech_st/12.1.0

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

Target System Display [testdb:0.0] : testdb:1.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] : 15

Checking the port pool 15

done: Port Pool 15 is free

Report file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/temp/portpool.lst

The new database context file has been created :

/oracledb/TEST/db/tech_st/12.1.0/appsutil/TESR_testdb.xml

Check Clone Context logfile /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_1004214819.log for details.

..............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

cd /oracledb/TEST/db/tech_st/12.1.0/dbs=>TEST_testdb_ifile.ora

set value in TEST_testdb_ifile.ora

[oracle@testdb dbs]$ cat TEST_testdb_ifile.ora

db_file_name_convert=('/erpprod/prod/oracle/PROD/data/datafile','/oracledb/TEST/db/apps_st/data'

log_file_name_convert=('/erpprod/prod/oracle/PROD/data','/oracledb/TEST/db/apps_st/data')

Restore RMAN BACKUP :

[oracle@devebsdb 12.1.0]$ . TEST_TESTDB.env

sqlplus '/as sysdba'

SQL> startup nomount pfile='initTEST.ora';

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

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

TEST NOMOUNT

Create RMAN Script(duplicate.sql):

run

{

allocate auxiliary channel t1 type disk;

allocate auxiliary channel t2 type disk;

duplicate database to "TEST" BACKUP LOCATION '/test/rman_backup/27Jul2021bkp';

release channel t1;

release channel t2;

}

[oracle@testdb 12.1.0]$ . TEST_testdb.env

rman auxiliary / cmdfile=duplicate.sql log=rmanlog.log

Note : Rman restored took some times

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

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

TEST READ WRITE

Now check the Archive log mode:

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Enabled

Archive destination oracledb/TEST/db/apps_st/data

Oldest online log sequence 173

Current log sequence 174

TEST instance no need Archive log mode, So now we need to disable the Archive log mode

SQL> shut immediate;

SQL>startup mount;

SQL>alter database noarchivelog

SQL>alter database open;

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Enabled

Archive destination oracledb/TEST/db/apps_st/data

Oldest online log sequence 176

Current log sequence 177

Database in open mode
Run the library update script against the database
cd [RDBMS ORACLE_HOME]/appsutil/install/[CONTEXT NAME] $ sqlplus "/ as sysdba" @adupdlib.sql so
Where [libext] should be set to 'sl' for HP-UX, 'so' for any other UNIX platform, or 'dll' for Windows.
Configure the target database The database must be running and open before performing this step.
cd [RDBMS ORACLE_HOME]/appsutil/clone/bin $ perl adcfgclone.pl dbconfig [Database target context file] Where Database target context file is: [RDBMS ORACLE_HOME]/appsutil/[Target CONTEXT_NAME].xml.

[oracle@testdb bin]$ perl adcfgclone.pl dbconfig oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.xml

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password :

Running Rapid Clone with command:

Running:

perl /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/adclone.pl java=/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre mode=apply stage=/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.xml showProgress contextValidated=false

Beginning dbconfig Apply - Tue 27 10:58:57 2021

/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oracledb/TEST/db/tech_st/12.1.0/oui -classpath /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/xmlparserv2.jar://oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojdbc6.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/java:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/ewt3.jar://oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/share.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/oui/srvm.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDatabase -e /oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.xml -stage /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone -showProgress -noRmanRecovery yes -checkDBConnection

APPS Password : Log file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_testdbt/ApplyDatabase_10051058.log

| 0% completed

Log file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/logTEST_testdb/ApplyDatabase_10051058.log

- 30% completed

Completed Apply...

Tue Jul 5 11:00:09 2021

Starting database listener for TEST:

Running:

/oracledb/TEST/db/tech_st/12.1.0/appsutil/scripts/TEST_testdb/addlnctl.sh start TEST

Logfile: /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_testdb/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process TEST ...

Listener TEST has already been started.

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/TEST_testdb/addlnctl.txt for more information ...

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

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Database EBS Technology Codelevel Checker |

+===============================================================+

Executing the following Script:

sqlplus apps/Passw0rd

EXEC FND_CONC_CLONE.SETUP_CLEAN;

Run Autoconfiq in Database:

./adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/WLAUAT_wonderlauat/10051106/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /oracledb/TEST/db/tech_st/12.1.0

Classpath : :/oracledb/TEST/db/tech_st/12.1.0/jdbc/lib/ojdbc6.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/java/xmlparserv2.jar:/oracledb/TEST/db/tech_st/12.1.0/appsutil/java:/oracledb/TEST/db/tech_st/12.1.0/jlib/netcfg.jar:/oracledb/TEST/db/tech_st/12.1.0/jlib/ldapjclnt12.jar

Using Context file: /oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.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.

II ) APPS Cloning:

/test/applmgr/fs1/EBSapps/comn/clone/bin

[applmgrt@testapps bin]$ perl adcfgclone.pl appsTier dualfs

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password :

Enter the Weblogic AdminServer password :

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

Running: Context clone...

Log file located at /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContext_1005111910.log

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

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

Target System Database SID : TEST

Target System Database Server Node [testdb] : testdb

Target System Database Domain Name [xyz.com] : xyz.org

Target System Base Directory : /test/applmgr

Target System Base Directory set to /test/applmgr

Target System Current File System Base set to /test/applmgr/fs1

Target System Other File System Base set to /test/applmgr/fs2

Target System Fusion Middleware Home set to /test/applmgr/fs1/FMW_Home

Target System Other File System Fusion Middleware Home set to /test/applmgr/fs2/FMW_Home

Target System Web Oracle Home set to /test/applmgr/fs1/FMW_Home/webtier

Target System Other File System Web Oracle Home set to /test/applmgr/fs2/FMW_Home/webtier

Target System Appl TOP set to /test/applmgr/fs1/EBSapps/appl

Target System Other File System Appl TOP set to /test/applmgr/fs2/EBSapps/appl

Target System COMMON TOP set to /test/applmgr/fs1/EBSapps/comn

Target System Other File System COMMON TOP set to /test/applmgr/fs2/EBSapps/comn

Target System Instance Home Directory [/test/applmgr] :

Target System Current File System Instance Top set to /test/applmgr/fs1/inst/apps/TEST_testapps

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

Target System Display [testapps:0.0] : testapps:1.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] : 15

Checking the port pool 15

done: Port Pool 15 is free

Report file located at /test/applmgr/fs1/inst/apps/TEST_testapps/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp

2. /usr/tmp

3. /oracledb/TEST/db/tech_st/12.1.0/appsutil/outbound/TEST_testdb

4. /usr/tmp

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

The new APPL_TOP context file has been created :

/test/applmgr/fs1/inst/apps/TEST_testapps/appl/admin/TEST_testapps.xml

Check Clone Context logfile /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContext_1005111910.log for details.

Creating Patch file system context file.....

Log file located at /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1005112418.log

Target System Other File System Instance Top set to /test/applmgr/fs2/inst/apps/TEST_testapps

Target System Port Pool [0-99] : 16

Checking the port pool 16

done: Port Pool 16 is free

Report file located at /test/applmgr/fs2/inst/apps/TEST_testapps/admin/out/portpool.lst

The new APPL_TOP context file has been created :

/test/applmgr/fs2/inst/apps/TEST_testapps/appl/admin/TEST_testapps.xml

Check Clone Context logfile /test/applmgr/fs1/EBSapps/comn/clone/bin/CloneContextPatch_1005112418.log for details.

FMW Pre-requisite check log file location : /test/applmgr/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: FMW pre-req check...

Configuring: Run file system....

LogFile located at /test/applmgr/fs1/inst/apps/TEST_testapps/admin/log/clone/run/RCloneApplyAppstier_10051124.log

Configuring: Patch file system....

LogFile located at /test/applmgr/fs2/inst/apps/TEST_testapps/admin/log/clone/run/RCloneApplyAppstier_10061125.log

Post-Clone Steps:

1. System password changed in Database

SQL>alter user system identified by welcome123;

2. Apps Password changed

Syntax:

FNDCPASS apps/<old password> 0 y system/Password SYSTEM APPLSYS <apss new password>

FNDCPASS apps/PassW0rd 0 y system/welcome123 SYSTEM APPLSYS apps123

3.Sysadmin Password Changed

FNDCPASS apps/<apps new password> 0 y system/Password USER SYSADMIN <sysadmin Password>

FNDCPASS apps/apps123 0 y system/welcome123 USER SYSADMIN Welcome#123

4.Weblogic console to connect :

Note: Weblogic to connect need to start the Admin server

[applmgr@testapps scripts]$ adadminsrvctl.sh start

You are running adadminsrvctl.sh version 120.10.12020000.10

Enter the WebLogic Admin password:

Enter the APPS Schema password:

Starting WLS Admin Server...

Refer /test/applmgr/fs1/inst/apps/TEST_testapps/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /test/applmgr/fs1/FMW_Home/user_projects/domains/EBS_domain_TEST/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /test/applmgr/fs1/inst/apps/TEST_testapps/logs/appl/admin/log/adadminsrvctl.txt for more information ...

[applmgr@testapps scripts]$

To find out WebLogic console:

grep -i "wls_admin" $CONTEXT_FILE

[applmgr@testapps TEST]$ grep -i "wls_admin" $CONTEXT_FILE

<wls_admin_host oa_var="s_wls_admin_host">testdb</wls_admin_host>

<wls_admin_domain oa_var="s_wls_admin_domain">.xyz.org</wls_admin_domain>

<wls_admin_user oa_var="s_wls_admin_user">weblogic</wls_admin_user>

<wls_adminport oa_var="s_wls_adminport" oa_type="PORT" base="7001" step="1" range="-1" label="WLS Admin Server Port">7016</wls_adminport>

[appluat@testapps TEST]$ grep login $CONTEXT_FILE

<login_page oa_var="s_login_page">http://testdb.xyz.org:8015/OA_HTML/AppsLogin</login_page>

The WebLogic Console is: http://testdb.xyz.org:7016/console

+ services

+ Data sourecs

+ EBS Data sources

+ Connection Pool

Apps Username <apps>

Apps Password <apps123>

and Save it

Auto Config Run in Database and Application:

1.Database :

./adautocfg.sh

Enter the APPS user password:

The log file for this session is located at: /oracledb/TEST/db/tech_st/12.1.0/appsutil/log/WLAUAT_wonderlauat/10051106/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.

Using ORACLE_HOME location : /oracledb/TEST/db/tech_st/12.1.0

Using Context file: /oracledb/TEST/db/tech_st/12.1.0/appsutil/TEST_testdb.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.

2. Application Autoconfiq:

Enter the APPS user password:

The log file for this session is located at: /test/applmgr/fs1/inst/apps/TEST_testapps/admin/log/10051828/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.

Using CONFIG_HOME location : /test/applmgr/fs1/inst/apps/TEST_testapps

Classpath : /test/applmgr/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/test/applmgr/fs1/EBSapps/comn/java/classes

Using Context file: /test/applmgr/fs1/inst/apps/TEST_testapps/appl/admin/Test_testapps.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

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

Configuring templates from all of the product tops...

Configuring AD_TOP........COMPLETED

Configuring FND_TOP.......COMPLETED

Configuring ICX_TOP.......COMPLETED

Site Name Changed:

DECLARE

a BOOLEAN;

BEGIN

a :=

FND_PROFILE.SAVE ('SITENAME',

'Test instance Refreshed on:28-JUL-2021 Backup Date:15-JUL 2021',

'SITE');

END;

Color Changed:

DECLARE

a BOOLEAN;

BEGIN

a := FND_PROFILE.SAVE ('FND_COLOR_SCHEME', 'red', 'SITE');

END;

1.Execute the adpreclone.pl both application and database.

2.Move the RMAN Backup, database ORACLE HOME, and application backup to the target server.

Source Database: PROD

Target Database: TEST

Backup Details (PROD): /prod/rman_backup/15Jul2021_bkp

Database backup move to target Server (testdb) :

*****************************************************

Copy Command from Source (PROD) server to Target server(TEST)

scp -P 15Jul2021_bkp oracle@172.165.12.15:/test/rman_backup/

scp -P Oracle_Home_bkp15Jul2021.tar.gz oracle@172.165.12.15:/oracledb/TEST/db/tech_st/

The Backup location is /test/rman_backup/15Jul2021_bkp

Application Backup move to target Server:

**********************************************

Copy Command from Source(PROD) server to Target server(TEST)

scp -P EBSapps.tar.gz applmgr@172.165.12.16:/test/applmgr/

The backup Location is /test/applmgr/EBSapps.tar.gz

Untar the backup

tar -xvzf EBSapps.tar.gz

I ) Database Cloning :

Untar the Oracle_home backup file

cd /oracledb/TEST/db/tech_st/

Oracle_Home_bkp15Jul2021.tar.gz

tar -xvzf Oracle_Home_bkp15Jul2021.tar.gz

[oracle testdb tech_st] 12.1.0

[oracle testdb tech_st] cd 12.1.0

Export PERL5LIB and PATH

export PERL5LIB=/oracledb/TEST/db/tech_st/12.1.0/perl/lib/5.14.1:/oracledb/TEST/db/tech_st/12.1.0/perl/lib/site_perl/5.14.1

export PATH=/oracledb/TEST/db/tech_st/12.1.0/perl/bin:/oracledb/TEST/db/tech_st/12.1.0/bin:$PATH

cd /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin

[oracle@testdb bin]$ perl adcfgclone.pl dbTechStack

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.56

Enter the APPS password : <Source<PROD> Apps Password>

Running: Context clone...

Log file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_1004214819.log

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

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

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

Target System Database SID : TEST

Target System Base Directory : /oracledb/TEST

Target System utl_file_dir Directory List : /usr/tmp

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

Target System DATA_TOP Directory 1 : /oracledb/TEST/apps_st/data

Target System RDBMS ORACLE_HOME Directory [/oracledb/TEST/12.1.0] : /oracledb/TEST/db/tech_st/12.1.0

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

Target System Display [testdb:0.0] : testdb:1.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] : 15

Checking the port pool 15

done: Port Pool 15 is free

Report file located at /oracledb/TEST/db/tech_st/12.1.0/appsutil/temp/portpool.lst

The new database context file has been created :

/oracledb/TEST/db/tech_st/12.1.0/appsutil/TESR_testdb.xml

Check Clone Context logfile /oracledb/TEST/db/tech_st/12.1.0/appsutil/clone/bin/CloneContext_1004214819.log for details.

cd /oracledb/TEST/db/tech_st/12.1.0/dbs=>TEST_testdb_ifile.ora

set value in TEST_testdb_ifile.ora

[oracle@testdb dbs]$ cat TEST_testdb_ifile.ora

db_file_name_convert=('/erpprod/prod/oracle/PROD/data/datafile','/oracledb/TEST/db/apps_st/data'

log_file_name_convert=('/erpprod/prod/oracle/PROD/data','/oracledb/TEST/db/apps_st/data')

Restore RMAN BACKUP :

[oracle@devebsdb 12.1.0]$ . TEST_TESTDB.env

sqlplus '/as sysdba'

SQL> startup nomount pfile='initTEST.ora';

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

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

TEST NOMOUNT

Create RMAN Script(duplicate.sql):

run

{

allocate auxiliary channel t1 type disk;

allocate auxiliary channel t2 type disk;

duplicate database to "TEST" BACKUP LOCATION '/test/rman_backup/27Jul2021bkp';

release channel t1;

release channel t2;

}

[oracle@testdb 12.1.0]$ . TEST_testdb.env

rman auxiliary / cmdfile=duplicate.sql log=rmanlog.log

Note : Rman restored took some times

SQL> select name,open_mode from v$database;

NAME OPEN_MODE

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

TEST READ WRITE

Now check the Archive log mode:

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Enabled

Archive destination oracledb/TEST/db/apps_st/data

Oldest online log sequence 173

Current log sequence 174

TEST instance no need Archive log mode, So now we need to disable the Archive log mode

SQL> shut immediate;

SQL>startup mount;

SQL>alter database noarchivelog

SQL>alter database open;

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Enabled

Archive destination oracledb/TEST/db/apps_st/data

Oldest online log sequence 176

Current log sequence 177

Database in open mode
Run the library update script against the database
cd [RDBMS ORACLE_HOME]/appsutil/install/[CONTEXT NAME] $ sqlplus "/ as sysdba" @adupdlib.sql so
Where [libext] should be set to 'sl' for HP-UX, 'so' for any other UNIX platform, or 'dll' for Windows.
Configure the target database The database must be running and open before performing this step.
cd [RDBMS ORACLE_HOME]/appsutil/clone/bin $ perl adcfgclone.pl dbconfig [Database target context file] Where Database target context file is: [RDBMS ORACLE_HOME]/appsutil/[Target CONTEXT_NAME].xml.