R12.2 Adop Phases in Oracle EBS

Dear DBA-Mates,

Hope you all are doing well !!! Topic - (R12.2 ADOP Phases in Oracle EBS)

We are back with (ADOP Phases in R12.2 in Oracle EBS) a new update which is very important and useful. We have collected these details as per our real time scenario based on log files details.

These may little bit long points but we tried to cover all the important points which internally ADOP phases does in EBS R12.2. So, please look into these below phases points.

Due to lack of time, we are ready with 2 adop phases i.e

Prepare and Apply phase . We will update soon others Adop phases details...

Prepare Phase:

$ adop phase=prepare

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:

Validating credentials.

1. Verifying data dictionary

2. Validating system is ready to prepare.

3. Detecting configuration changes

4. Detecting ad/txk codelevel bumpup

5. Checking for pending cleanup actions

6. Validating database is ready to prepare.

7. Starting Apps listener -- will be already running

8. Submitting ADZDPATCH concurrent program

This request is waiting to be processed by the Conflict Resolution

Manager.  This request cannot yet begin execution because other requests

may conflict with it. The Conflict Resolution Manager will determine when

this request may begin execution. User SYSADMIN submitted this request on

09-FEB-2019

9. Creating database patch edition

10. Synchronizing patch filesystem with run filesystem.

[1] SINGLE PATCH (DRV=u27984039.drv):  27984039

SYNCHRONIZATION is in progress

11. Stopping services on patch file system

 - Stopping admin server -- already shutdown

 - Stopping node manager -- already shutdown

12. The prepare phase completed successfully.

Apply Phase:

$adop phase=apply patches=<patch number>

Enter the APPS password:

Enter the SYSTEM password:

Enter the WLSADMIN password:

Validating credentials.

1. It will check for Run Edition context file :

2. It will check for Patch edition context file:

3. It will check for Patch file system free space.

4. Shut down the application tier services

5. Run the following commands in the order shown

        $AD_TOP/patch/115/sql/ADFIXUSER.sql

        @ $AD_TOP/sql/adutlrcmp.sql

6. Checking for existing adop sessions.

    Continuing with existing session

7. Applying patch


Read more... Finaliza and Cutover Phase 

Some more useful links:

R12.2 ADOP Patching Phases Finalize and Cutover
 

How to RestoreDR database from RMAN

Performance Issue and Solution

How to deploy RPD in OBIEE 11g 
Hope this may useful and helpful.
Regards,

fs_clone failed :[UNEXPECTED]Error occurred running "perl /ora-data/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl

Dear DBA-Mates,

Hope you all are doing well!!!

Little busy with work, so can't get time to meet you guys here...

We have many things to update you guys which we will do it one by one and hope will be useful to you all.

So, let's move to topic...

Recently, we were applying patch and faced the below issue as fs_clone phase failed with error:

ERROR:

[EVENT]     Performing CLONE steps.

    [PROCEDURE] CLONE Patch File System from Run File System

    [PROCEDURE] Calling: /ora-data/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl

[EVENT]     Log: /ora-data/applmgr/fs_ne/EBSapps/log/adop/209/date_time/fs_clone/SKU

[UNEXPECTED]Error occurred running "perl /ora-data/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl

-contextfile=/ora-data/inst/fs1/inst/apps/ora-data_SKU/appl/admin/ora-data_SKU.xml

-patchcontextfile=/ora-data/inst/fs2/inst/apps/ora-data_SKU/appl/admin/ora-data_SKU.xml

-promptmsg=hide -console=off -mode=create -sync_mode=copy -sessionid=209 -timestamp=date_time

-outdir=/ora-data/applmgr/fs_ne/EBSapps/log/adop/209/date_time/fs_clone/SKU"

[UNEXPECTED]occurred during CLONE Patch File System from Run File System,

running command: "perl /ora-data/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl

-contextfile=/ora-data/inst/fs1/inst/apps/ora-data_SKU/appl/admin/ora-data_SKU.xml

-patchcontextfile=/ora-data/inst/fs2/inst/apps/ora-data_SKU/appl/admin/ora-data_SKU.xml -promptmsg=hide -console=off

-mode=create -sync_mode=copy -sessionid=209 -timestamp=date_time -outdir=/ora-data/applmgr/fs_ne/EBSapps/log/adop/209/date_time/fs_clone/SKU".

[EVENT]     Releasing managed server ports.

[PROCEDURE] Releasing ports

[STATEMENT] Calling task: "Releasing ports on SKU"; script: "/ora-data/inst/fs1/inst/apps/ora-data_SKU/admin/install/txkCloneAcquirePort.pl"; args: " -option=close -server=SKU.oracleoutsourcing.com -ports=5557,7002,17002,7602,7402,7202,7204,7802,6101,6201,10000 -log=/ora-data/applmgr/fs_ne/EBSapps/log/adop/209/date_time/fs_clone/SKU/txkCloneAcquirePort.log"

[PROCEDURE] Releasing ports on SKU

[PROCEDURE] Calling: /ora-data/inst/fs1/inst/apps/ora-data_SKU/admin/install/txkCloneAcquirePort.pl

[EVENT]     Log: /ora-data/applmgr/fs_ne/EBSapps/log/adop/209/date_time/fs_clone/SKU/txkCloneAcquirePort.log

[PROCEDURE] Releasing ports on SKU

[PROCEDURE] Releasing ports

[PROCEDURE] Updating status of patches

[STATEMENT] SQL statement : "  update ad_adop_session_patches

 set status='F' where applied_file_system_base = '/ora-data/applmgr/fs1' and patch_file_system_base = '/ora-data/applmgr/fs2' and bug_number='CLONE' and status <> 'Y' and appltop_id=197 and node_name='SKU'"

[PROCEDURE] Updating status of patches

[EVENT]     Stopping services on patch file system.

[EVENT]     Stopping admin server.

[PROCEDURE] Check and stop patch Admin Server

[PROCEDURE] Check and Stop patch FS Admin Server

[UNEXPECTED]Error occurred running "sh /ora-data/inst/fs2/inst/apps/ora-data_SKU/admin/scripts/adadminsrvctl.sh  stop -nopromptmsg"

[UNEXPECTED]Error running adadminsrvctl command

[PROCEDURE] Unlocking sessions table

[STATEMENT] Unlocking ad_adop_sessions table for SKU with wait interval of 60 seconds and number of tries 2

[PROCEDURE] Unlocking sessions table

Then as usual like every DBA, we searched and found that adxmlctx temp file in custom folder which we need to remove it and run fs_clone phase again as option force=yes as shown below:

Action:

As per Doc id for ref.: FSClone fails while running txkADOPPreparePhaseSynchronize.pl (Doc ID 2094689.1)

[ora-data@SKU <RUN> ]$ ls -ltr $AD_TOP/admin/template/custom/adxmlctx.tmp

-rw-r--r-- 1 ora-data ora-data 174898 Jan 26 12:16 /dpea9i/applmgr/fs2/EBSapps/appl/ad/12.0.0/admin/template/custom/adxmlctx.tmp

[ora-data@SKU <RUN> ]$ mv $AD_TOP/admin/template/custom/adxmlctx.tmp $AD_TOP/admin/template/custom/adxmlctx.tmp_bkp10feb2019

 [ora-data@SKU <RUN> ]$

 Then we need to run again fs_clone phase as:

 $adop phase=fs_clone force=yes

 Some important useful links:

How to take backup Apps Tier using gtar command in R12

How to Restore DR database from RMAN

Performance Issue and Solution

How to recover database from RMAN command with example

Regards,

Every employee must know it before joining any company

Dear All,

Hope you all are doing well...

We would like to share one of most important real time experience here which every employee must know it.

We have seen these challenges in our real life and felt very bad as how people do mistakes.

As we all know that we are working for any either small or MNC companies.

Suppose, if we are working for any small companies, we will get more close or emotional with the company's members like Director, Managers, HR etc...

But friends, always remember never ever love your company, always love your job / work.

We will tell you, what you do mistake here... When you become close to your Director, Managers, HR etc...in small companies, you will get emotional and you will believe them. But they will always be same and they will look for their business and money.

Real time Faced Experiences:

I got selected in a company and I asked my boss to release me.

He told OK sure, Congrats... Which company you got offers. And I told him company name because of excitement and happiness.

Friends, from next day I didn't get any updates from that new company...

I kept following them but they kept Quit, no response at all... Then I realize there is something wrong.

Finally, I left the hope and move forward.

After 2 months, again I got another opportunity.

I went to that fellow (Manager/HR) and told him I want to leave. I sent him resignation letter. He called me and again he asked company Name.

I told him some other big company name. Then he asked me to show Offer Letter, I told him it's Confidential which I should not share.

Then he starts to negotiate with me. But I was remembering the old story and I told him give me double which I am getting because I knew he will not be ready.

Finally, over all fighting I left company. Friends, till last date he was trying to get the company's name and offer letter because if he came to know, he may get chance to play game again, who knows...

So, Friends from the above experiences we should learn the below points:

1. We should never ever share the COMPANY NAME while leaving any company or organizations.

2. We should not get closed to anyone who is involved in handling the Organizations.

3. We should not get afraid in professionalism if you are not wrong. Some people will use you if you afraid from them.

4. As they think only about their company same way we should think about our Career growth.

5. Don’t hesitate to ask anything, without asking you will not get it.

6. If you don’t like anything, ask for reason, don’t just listen and do the stuff.

7. Don’t be always available. Like don’t go whenever he calls you.

Note: I am writing this because, same thing happened with mine 4-5 Friends then I felt to share here with you all.

Hope this may useful. Live the life, don’t give anyone change to live you…

Please let us know for any help, we will try if we can…

Thanks you all!!!