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!!!

WISH YOU A HAPPY NEW YEAR - 2019 With Small Idea...

WISHING YOU A VERY HAPPY NEW YEAR - 2019 TO YOU ALL AND YOURS FAMILY…

Enjoy like anything but don't disturb anyone…

 

I have a personal thinking and advice which I would like to share with you all here that make some plans to achieve this year. 

And I will give you a small trick which may useful here that plan the target of only for 6 months…

Don't plan for whole year otherwise you will complete or get it next year only,  no doubt… you can decide or think as per your previous plan and achievement…

Also, if we are thinking for any Good work then we should start ASAP, 

But for some of other work or bad habits or false commitments etc then wait for good time or date… better not to start or do it…

If you have any dream, you have to start and complete it,  don't be depended on others…

If you don't have any dreams then other people will use you to complete their dreams… 

So, please don't give any chance anyone/others to use you…

Always be Confident and follow true path...

Here, don’t want to take much time, Enjoy the New Year-2019 and achieve your goals, All the Best...

Cheerrrrrssssss...

See you guys soon with a very important with personal experiences which i have faced and experienced recently...

As people say na... Sawdhani hati, durgatna gati... hhehehh

Take care guys...

See you all in New Years day with full of joy and Energy...
Lets be hustle and humble... 
Lets do something special in Year - 2019,  
Guys be Ready, steady and Goooo....
Be Fast not first...

Thank you !!! 

How to recover database from rman command with example

Hi DBA-Mates,

We would like give a simple demo for how to recover database from rman backup with example.

It is very simple steps. As we all know these steps but for Quick check we can check it.

Please find the below details.

Backup details:

[oracle@localhost backup]$ ls -ltr

total 816752

-rwxrwxrwx 1 oracle oracle 794894336 Dec 12 05:09 ORCL_20181212_5_1_FULL

-rwxrwxrwx 1 oracle oracle   1114112 Dec 12 05:09 ORCL_20181212_6_1_FULL

-rwxrwxrwx 1 oracle oracle   9797632 Dec 12 05:31 ORCL_20181212_7_1_CONTROL

-rwxrwxrwx 1 oracle oracle  29705728 Dec 12 05:46 ORCL_20181212_8_1_ARCHIVE

 [oracle@localhost backup]$ rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Wed Dec 12 05:58:31 2018

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (not mounted)

1. RMAN> startup nomount;

database is already started

2. RMAN> restore controlfile from '/home/oracle/backup/ORCL_20181212_7_1_CONTROL';

Starting restore at 12-DEC-18

using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/home/oracle/app/oracle/oradata/orcl/control01.ctl

output file name=/home/oracle/app/oracle/flash_recovery_area/orcl/control02.ctl

Finished restore at 12-DEC-18

3. RMAN> alter database mount;

database mounted

released channel: ORA_DISK_1

4. RMAN> restore database;

Starting restore at 12-DEC-18

Starting implicit crosscheck backup at 12-DEC-18

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=20 device type=DISK

Crosschecked 3 objects

Finished implicit crosscheck backup at 12-DEC-18

Starting implicit crosscheck copy at 12-DEC-18

using channel ORA_DISK_1

Finished implicit crosscheck copy at 12-DEC-18

searching for all files in the recovery area

cataloging files...

cataloging done

List of Cataloged Files

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

File Name: /home/oracle/app/oracle/flash_recovery_area/ORCL/archivelog/2018_12_12/o1_mf_1_565_g1249wpd_.arc

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00001 to /home/oracle/app/oracle/oradata/orcl/system01.dbf

channel ORA_DISK_1: restoring datafile 00002 to /home/oracle/app/oracle/oradata/orcl/sysaux01.dbf

channel ORA_DISK_1: restoring datafile 00003 to /home/oracle/app/oracle/oradata/orcl/undotbs01.dbf

channel ORA_DISK_1: restoring datafile 00004 to /home/oracle/app/oracle/oradata/orcl/users01.dbf

channel ORA_DISK_1: restoring datafile 00005 to /home/oracle/app/oracle/oradata/orcl/example01.dbf

channel ORA_DISK_1: restoring datafile 00006 to /home/oracle/app/oracle/oradata/orcl/APEX_1930613455248703.dbf

channel ORA_DISK_1: reading from backup piece /home/oracle/backup/ORCL_20181212_5_1_FULL

channel ORA_DISK_1: piece handle=/home/oracle/backup/ORCL_20181212_5_1_FULL tag=DATABASE_BKP121218

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:03:37

Finished restore at 12-DEC-18

5. RMAN> recover database;

Starting recover at 12-DEC-18

using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 565 is already on disk as file /home/oracle/app/oracle/flash_recovery_area/ORCL/archivelog/2018_12_12/o1_mf_1_565_g1249wpd_.arc

archived log for thread 1 with sequence 566 is already on disk as file /home/oracle/app/oracle/oradata/orcl/redo02.log

archived log file name=/home/oracle/app/oracle/flash_recovery_area/ORCL/archivelog/2018_12_12/o1_mf_1_565_g1249wpd_.arc thread=1 sequence=565

archived log file name=/home/oracle/app/oracle/oradata/orcl/redo02.log thread=1 sequence=566

media recovery complete, elapsed time: 00:00:01

Finished recover at 12-DEC-18

6. RMAN> alter database open resetlogs;

database opened

RMAN>

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE

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

ORCL      READ WRITE

SQL>

Some more useful links:

Performance Issue and Solution

How to increase Java heap size in Hyperion

How to start MRP process on Dataguard -- standbydatabase

Difference between fnd_conc_clone.setup_clean and cmclean

Regards,