ADOP ( R12.2 Online Patching ) in Oracle EBS

I will explain how to patch Oracle EBS Online with ADOP tool ( Application DBA Online Patching ) in this article. Let’s review the ADOP ( R12.2 Online Patching ) in Oracle EBS

 

ADOP ( R12.2 Online Patching ) in Oracle EBS

 

Oracle E-Business Suite (EBS) patching has changed with 12.2 onwards. Because Oracle introduced 3 different file systems with 12.2. These are fs1, fs2 and fs_ne.

Usually fs1 is run edition and current used file system. fs2 is a file system which is a copy of fs1 but it is called patch edition. With Oracle 12.2, you can apply patch to fs2 and then switchover or cutover and change file systems. Thus, downtime will be minimum.

 

ADOP (Application DBA Online Patching)

With the ADOP (Application DBA Online Patching) tool that comes with 12.2, patching is now easier and with minimal downtime. The steps for patching with ADOP are as follows.

 

 

let’s start apply any EBS patch ( 23615130 ) step by step with ADOP tool.

 

 

Oracle EBS Patch via ADOP

EBS patch 23615130 is downloaded from Oracle support and upload to the $ PATCH_TOP directory.

 

Firstly run Prepare step like following.

 

[applmgr@ebstest 23615130]$ adop phase=prepare

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:


Validating credentials.

Initializing.
Run Edition context : /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
Patch edition context: /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
Patch file system free space: 61.93 GB

Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node dbmaattest:
19509982
27997875
28507324
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

Checking for existing adop sessions.
No pending session exists.
Starting new adop session.

===========================================================================
ADOP (C.Delta.8)
Session ID: 5
Node: ebstest
Phase: prepare
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/adop.log
===========================================================================

Validating configuration on node: [ebstest].
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/validate/ebstest
[WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.

Verifying data dictionary.

Validating system is ready to prepare.
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest

Detecting configuration changes.
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/adConfigChanges.log
The log file is /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/adConfigChanges.log

/u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/appl/admin/cutover directory not found, so configuration changes cannot be detected.
The directory may have been deleted intentionally or accidentally. Or, if this is the first adop cycle, the directory will only be created after cutover.

Without this directory, the configuration changes will be propagated to the patch file system forcefully.

Configuration change detected.
File system configuration changes were detected.

Checking for pending cleanup actions.
Full cleanup needed as abort phase was run in previous cycle
Running cleanup as it was not run in previous patching cycle.

Processing cleanup actions in parallel.
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/log/cleanup.log

Generating report of queued DDL actions.
Output: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/adzdallddls.out

Running cleanup in FULL mode.
Log: @ADZDSHOWLOG.sql "2019/02/07 11:21:22"

Validating database is ready to prepare.

Generating report for key tablespaces.
Output: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/adzdshowts.out

Starting Apps listener.

adalnctl.sh version 120.3.12020000.4

Checking for FNDFS executable.
Listener APPS_TEST has already been started.

adalnctl.sh: exiting with status 2


adalnctl.sh: check the logfile /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/logs/appl/admin/log/adalnctl.txt for more information ...


Submitting ADZDPATCH concurrent program.
Waiting for conflicting requests to complete.
adzdpatch concurrent program now running.

Saving database logs from previous session.
Output: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/adzdshowlog_cleanup.out

Creating database patch edition.
Log: @ADZDSHOWLOG.sql "2019/02/07 11:23:56"

Synchronizng patch filesystem with run filesystem.
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest

Running steps for CONFIG_CLONE.
Performing CONFIG_CLONE steps.
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest
The log file is /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/TXK_SYNC_migrate/getCtxFileStatus.log
Configuration change detected.

Beginning application tier FSCloneApply - cloneContext Thu Feb 7 11:26:44 2019

/u01/oracle/TEST/fs1/FMW_Home/webtier/jdk/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/TEST/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/oracle/TEST/fs1/EBSapps/comn/java/classes:/u01/oracle/TEST/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/oracle/TEST/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/obfuscatepassword.jar oracle.apps.ad.clone.FSCloneApplyAppsTier -e /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml -targ /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml -stage /u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest -tmp /tmp -nodbac -component cloneContext -nopromptmsg
Log file located at /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/admin/log/clone/FSCloneApplyAppsTier_02071026.log

Log file located at /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/admin/log/clone/FSCloneApplyAppsTier_02071026.log

Target System Fusion Middleware Home set to /u01/oracle/TEST/fs2/FMW_Home

Target System Web Oracle Home set to /u01/oracle/TEST/fs2/FMW_Home/webtier

Target System Appl TOP set to /u01/oracle/TEST/fs2/EBSapps/appl

Target System COMMON TOP set to /u01/oracle/TEST/fs2/EBSapps/comn

Target System Instance Top set to /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest
Report file located at /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/temp/portpool.lst
The new APPL_TOP context file has been created :
/u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
contextfile=/u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
Completed FSCloneApply...
Thu Feb 7 11:26:55 2019
The log file is /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/TXK_SYNC_migrate/getWLSStatus.log
Configuration change detected.

Beginning application tier FSCloneStage - wlsConfig Thu Feb 7 11:27:05 2019

/u01/oracle/TEST/fs1/EBSapps/comn/util/jdk32/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/TEST/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/oracle/TEST/fs1/EBSapps/comn/java/classes:/u01/oracle/TEST/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/oracle/TEST/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/TEST/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.FSCloneStageAppsTier -e /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml -targ /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml -stage /u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest -tmp /tmp -component wlsConfig -nopromptmsg
Log file located at /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/admin/log/clone/FSCloneStageAppsTier_02071027.log
Completed FSCloneStage...
Thu Feb 7 11:28:21 2019

Beginning application tier FSCloneApply - wlsConfig Thu Feb 7 11:28:23 2019

/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/FMW/t2pjdk/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/xmlparserv2.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/ojdbc6.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/java:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/oui/OraInstaller.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/oui/ewt3.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/oui/share.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/ojmisc.jar:/u01/oracle/TEST/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/obfuscatepassword.jar oracle.apps.ad.clone.FSCloneApplyAppsTier -e /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml -targ /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml -stage /u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest -tmp /tmp -nodbac -component wlsConfig -nopromptmsg
Log file located at /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/admin/log/clone/FSCloneApplyAppsTier_02071028.log


Completed FSCloneApply...
Thu Feb 7 11:44:34 2019
The log file is /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/TXK_SYNC_migrate/getHTTPStatus.log
Configuration change detected.

Beginning application tier FSCloneStage - ohsConfig Thu Feb 7 11:44:46 2019

/u01/oracle/TEST/fs1/EBSapps/comn/util/jdk32/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/TEST/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/oracle/TEST/fs1/EBSapps/comn/java/classes:/u01/oracle/TEST/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/oracle/TEST/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/TEST/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.FSCloneStageAppsTier -e /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml -targ /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml -stage /u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest -tmp /tmp -component ohsConfig -nopromptmsg
Log file located at /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/admin/log/clone/FSCloneStageAppsTier_02071044.log
Completed FSCloneStage...
Thu Feb 7 11:45:48 2019

Beginning application tier FSCloneApply - ohsConfig Thu Feb 7 11:45:50 2019

/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/FMW/t2pjdk/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/xmlparserv2.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/ojdbc6.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/java:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/oui/OraInstaller.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/oui/ewt3.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/oui/share.jar:/u01/oracle/TEST/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/ojmisc.jar:/u01/oracle/TEST/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest/jlib/obfuscatepassword.jar oracle.apps.ad.clone.FSCloneApplyAppsTier -e /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml -targ /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml -stage /u01/oracle/TEST/fs1/EBSapps/comn/adopclone_ebstest -tmp /tmp -nodbac -component ohsConfig -nopromptmsg
Log file located at /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/admin/log/clone/FSCloneApplyAppsTier_02071045.log
Completed FSCloneApply...
Thu Feb 7 11:47:34 2019

Running AutoConfig on patch edition file system.

The log file for this session is located at: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest
Classpath : /u01/oracle/TEST/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/oracle/TEST/fs2/EBSapps/comn/java/classes

Using Context file : /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.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
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring CZ_TOP........COMPLETED
Configuring SHT_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring GMF_TOP.......COMPLETED
Configuring PON_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest

Synchronizing snapshots.

Generating editions report.
Output: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/adzdshowed.out

Generating log report.
Output: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_111703/prepare/ebstest/adzdshowlog.out

Stopping services on patch file system.
Stopping admin server.

You are running adadminsrvctl.sh version 120.10.12020000.10

Stopping WLS Admin Server...
Refer /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/oracle/TEST/fs2/FMW_Home/user_projects/domains/EBS_domain_TEST/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for more information ...

Stopping node manager.

You are running adnodemgrctl.sh version 120.11.12020000.12


The Node Manager is already shutdown

NodeManager log is located at /u01/oracle/TEST/fs2/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1

adnodemgrctl.sh: exiting with status 2

adnodemgrctl.sh: check the logfile /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/logs/appl/admin/log/adnodemgrctl.txt for more information ...


The prepare phase completed successfully.


adop exiting with status = 0 (Success)
[applmgr@ebstest 23615130]$


 

 

 

 

If Prepare step is completed successfully, then you can apply patch like following.

 

 

[applmgr@ebstest 23615130]$ adop phase=apply patches=23615130

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:


Validating credentials.

Initializing.
Run Edition context : /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
Patch edition context: /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
Patch file system free space: 60.69 GB

Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node dbmaattest:
19509982
27997875
28507324
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

Checking for existing adop sessions.
Continuing with existing session [Session ID: 5].

===========================================================================
ADOP (C.Delta.8)
Session ID: 5
Node: ebstest
Phase: apply
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_115400/adop.log
===========================================================================

Applying patch 23615130.
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_115400/apply/ebstest/23615130/log/u23615130.log

Generating post apply reports.

Generating log report.
Output: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_115400/apply/ebstest/adzdshowlog.out

The apply phase completed successfully.


adop exiting with status = 0 (Success)
[applmgr@ebstest 23615130]$
[applmgr@ebstest 23615130]$


If Patch apply step is completed successfully, then you should run Finalize step like following.

 

[applmgr@ebstest 23615130]$
[applmgr@ebstest 23615130]$ adop phase=finalize

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:


Validating credentials.

Initializing.
Run Edition context : /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
Patch edition context: /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
Patch file system free space: 60.69 GB

Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node dbmaattest:
19509982
27997875
28507324
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

Checking for existing adop sessions.
Continuing with existing session [Session ID: 5].

===========================================================================
ADOP (C.Delta.8)
Session ID: 5
Node: ebstest
Phase: finalize
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_130549/adop.log
===========================================================================

Verifying data dictionary.

Running finalize phase database actions.
Log: @ADZDSHOWLOG.sql "2019/02/07 13:07:06"
Compiling invalid objects.

Generating log report.
Output: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_130549/finalize/ebstest/adzdshowlog.out

The finalize phase completed successfully.


adop exiting with status = 0 (Success)
[applmgr@ebstest 23615130]$
[applmgr@ebstest 23615130]$

 

 

 

 

If Finalize step is completed successfully, then you can execute Cutover step like following. When cutover step is completed, file systems will change between each other. And fs1 will be fs2, and fs2 will be fs1 in this case. fs2 will be run edition, fs1 will be patch edition Finally.

 

[applmgr@ebstest 23615130]$
[applmgr@ebstest 23615130]$ adop phase=cutover

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:


Validating credentials.

Initializing.
Run Edition context : /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
Patch edition context: /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
Patch file system free space: 60.69 GB

Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node dbmaattest:
19509982
27997875
28507324
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

Checking for existing adop sessions.
Continuing with existing session [Session ID: 5].

===========================================================================
ADOP (C.Delta.8)
Session ID: 5
Node: ebstest
Phase: cutover
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_131426/adop.log
===========================================================================

Validating configuration on node: [ebstest].
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_131426/cutover/validate/ebstest

Checking if finalize required.
Finalize phase is not required

Submitting request for Internal Concurrent Manager shutdown.

You are running adcmctl.sh version 120.19.12020000.7

Shutting down concurrent managers for TEST ...
ORACLE Password:
Submitted request 481586 for CONCURRENT FND SHUTDOWN


adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/logs/appl/admin/log/adcmctl.txt for more information ...

Cancelling ADZDPATCH concurrent request

Waiting for Internal Concurrent Manager to go down.

Stopping patch edition Admin Server.

You are running adadminsrvctl.sh version 120.10.12020000.10


The AdminServer is already shutdown

AdminServer logs are located at /u01/oracle/TEST/fs2/FMW_Home/user_projects/domains/EBS_domain_TEST/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 2

adadminsrvctl.sh: check the logfile /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for more information ...


Stopping patch edition Node Manager.

You are running adnodemgrctl.sh version 120.11.12020000.12


The Node Manager is already shutdown

NodeManager log is located at /u01/oracle/TEST/fs2/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1

adnodemgrctl.sh: exiting with status 2

adnodemgrctl.sh: check the logfile /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/logs/appl/admin/log/adnodemgrctl.txt for more information ...


Stopping the application tier services on current node.
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_131426/cutover/ebstest

Stopping run edition Admin Server.

You are running adadminsrvctl.sh version 120.10.12020000.10

Stopping WLS Admin Server...
Refer /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/oracle/TEST/fs1/FMW_Home/user_projects/domains/EBS_domain_TEST/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/logs/appl/admin/log/adadminsrvctl.txt for more information ...


Stopping run edition Node Manager.

You are running adnodemgrctl.sh version 120.11.12020000.12


NodeManager log is located at /u01/oracle/TEST/fs1/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1

adnodemgrctl.sh: exiting with status 0

adnodemgrctl.sh: check the logfile /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/logs/appl/admin/log/adnodemgrctl.txt for more information ...


Running stored cutover DDLs.
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_131426/cutover/ebstest/log/cutover.log

Loading JAR files into database.
No JAR files found to load

Performing database cutover.
Log: @ADZDSHOWLOG.sql "2019/02/07 13:23:28"

Flipping snapshots in run and patch editions.

Performing file system cutover.

Checking if file system cutover completed.


Broadcast message from applmgr@ebstest (Thu Feb 7 13:25:56 2019):

TEST environment has changed.
All users must re-source the environment.
Starting run edition Admin Server.

Starting application tier services.

Waiting for middle tier services to start on all available nodes.

Generating post-cutover reports.

Generating log report.
Output: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_131426/cutover/ebstest/adzdshowlog.out

Broadcast message from applmgr@ebstest (Thu Feb 7 13:32:40 2019):

TEST environment has changed.
All users must re-source the environment.

The cutover phase completed successfully.

[applmgr@ebstest ~]$






After the cutover phase is completed, run Cleanup phase.

 

[applmgr@ebstest ~]$ adop phase=cleanup

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:


Validating credentials.

Initializing.
Run Edition context : /u01/oracle/TEST/fs2/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
Patch edition context: /u01/oracle/TEST/fs1/inst/apps/TEST_ebstest/appl/admin/TEST_ebstest.xml
Patch file system free space: 60.25 GB

Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node dbmaattest:
19509982
27997875
28507324
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

Checking for existing adop sessions.

===========================================================================
ADOP (C.Delta.8)
Session ID: 5
Node: ebstest
Phase: cleanup
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_133438/adop.log
===========================================================================

Processing cleanup actions in parallel.
Log: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_133438/cleanup/ebstest/log/cleanup.log

Generating report of queued DDL actions.
Output: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_133438/cleanup/ebstest/adzdallddls.out

Running cleanup in STANDARD mode.
Log: @ADZDSHOWLOG.sql "2019/02/07 13:35:50"

Generating log report.
Output: /u01/oracle/TEST/fs_ne/EBSapps/log/adop/5/20190207_133438/cleanup/ebstest/adzdshowlog.out

The cleanup phase completed successfully.


adop exiting with status = 0 (Success)
[applmgr@ebstest ~]$

  


Do you want to learn Oracle E-Business Suite ( EBS ) for Junior Apps DBA, then Click This Link and read the articles.

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *