Oracle E-Business Suite 12.2.6 ADOP Online Patch

Merhaba Arkadaşlar,

Bu yazımda sizlere Oracle E-Business Suite de 12.2 den önce olmayan ve 12.2 ile gelen Online patch geçmeyi anlatıyor olacağım.

Oracle E-Business Suite ( EBS ) 12.2 versiyonuna kadar geçilen patchler ile 12.2 den itibaren geçilme şekli değişti. Çünkü Oracle 12.2 ile beraber 3 farklı file system getirdi. Bunlar fs1, fs2 ve fs_ne şeklindedir.

Genellikle fs1 bizim run edition dediğimiz çalışan o anki kullanılan file sistemdir. fs2 ise fs1 in kopyası olan fakat patch edition dediğimiz bir file sistemdir. Oracle 12.2 ile beraber artık patchlerinizi fs2 ye geçin ve ondan sonra switchover yada cutover yapıp değiştirin file sistemleri diyor. Böylece kesinti minimum olmaktadır.

12.2 ile beraber gelen ADOP ( Application DBA Online Patching )toolu ile artık patch atma daha kolay ve minimum kesinti ile olmaktadır. ADOP ile patch atma adımları aşağıdaki görselde belirtildiği gibidir.

 

Şimdi adım adım bunları aşağıdaki gibi yapıyoruz.

23615130 nolu EBS patchini Oracle support dan indirip $PATCH_TOP altına atılıp unzip edilir. Ardından aşağıdaki gibi prepare çalıştırılır.

 

[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]$

 

Prepare aşaması 1 saat kadar sürmektedir bunu sabırla bekledikten sonra Prepare aşaması yukardaki gibi başarılı bir şekilde tamamlandıktan sonra patch i apply ediyoruz.

 

[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]$

Patch başarılı bir şekilde apply olduktan sonra aşağıdaki gibi finalize ediyoruz.

[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]$

 

 

Finalize adımıda başarılı bir şekilde tamamlandıktan sonra cutover yapıyoruz ve artık file systemler değişiyor yani fs1 fs2 oluyor, fs2 fs1 oluyor.

 

[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 ~]$

 

Cutover aşamasıda tamamlandıktan sonra cleanup yapıp tamamlıyoruz.

[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 ~]$

  

Böylece bu yazınında sonuna gelmiş bulunmaktayım bir sonraki yazıda görüşmek dileğiyle esen kalın…

 

 

Oracle Exadata SQL Server Goldengate Weblogic EBS ve Linux konusunda aşağıdaki konularda 7×24 Uzman Danışmanlara yada Eğitimlere mi İhtiyacınız var mehmet.deveci@gridgroup.com.tr adresine mail atarak Bizimle iletişime geçebilirsiniz.

– Oracle Veritabanı Danışmanlığı
– Oracle Veritabanı Bakım ve Destek
– Exadata Danışmanlığı
– Exadata Bakım ve Destek
– SQL Server Veritabanı Danışmanlığı
– SQL Server Veritabanı Bakım ve Destek
– Goldengate Danışmanlığı
– Goldengate Bakım ve Destek
– Linux Danışmanlığı
– Linux Bakım ve Destek
– Oracle EBS Danışmanlığı
– Oracle EBS Bakım ve Destek
– Weblogic Danışmanlığı
– Weblogic Bakım ve Destek
– Oracle Veritabanı Eğitimleri
– Oracle VM Server Danışmanlığı
– Oracle VM Server Bakım ve Destek
– Oracle EPPM Danışmanlığı
– Oracle EPPM Bakım ve Destek
– Oracle Primavera Danışmanlığı
– Oracle Primavera Bakım ve Destek
– Oracle Eğitimleri
– SQL Server Eğitimleri
– Goldengate Eğitimleri
– Exadata Eğitimleri
– Linux Eğitimleri
– Oracle EBS Eğitimleri
– Oracle VM Server Eğitimleri
– Weblogic Eğitimleri
– Oracle EPPM Eğitimleri
– Oracle Primavera Eğitimleri

Mehmet Salih Deveci

I am Founder of 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 mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

3 thoughts on “Oracle E-Business Suite 12.2.6 ADOP Online Patch

Leave a Reply

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