Why We are not Rich

Dear Friends,
I would like to share my personal experience which may be good and useful here.

We all want to do something in their life but we won’t able to do but it is not like that we can’t do it. If a person want to do anything in their life then can do it.

I will tell you one thing, why we are not able to do because we think as others but the difference is, they take actions towards their Aim or Thinking way, but we do only plan and thinking ideas.

Even I am also planning to open a company but the problem is I am only thinking… there is no action towards that aim… So, it is not possible at all…

One day just I was coming in cab from office and was thinking how I can make more money in my life… Then suddenly very simple thing strikes in my mind that “What I am doing for earning extra money?”

Then the answer was nothing… It means I can’t get any extra money. I am coming office and working so I can get that much only as regular my job money.

Result: If you want to make extra money or want to be rich like others you have to work extra and need to take steps towards to be rich…

Believe me being rich is not a big deal but the thing is you have to work towards that your ideas and thinking…
I know people may thinnking that why I am not rich because dude's I am also one of you guys only... "Mungary lal ke sapne" but believe me i have done manything which was impossible for me and have good life experiences...

It is correct if you are going to start any new things you will face a lots of challenges but once you cross that challenges you will be leader and an experienced hero...

Result: Be Ready for new challenges and try to solve it because believe me every issues have definitely Solutions 100% . . .

Hope this may useful and helpful in life.
Some more useful links:
How to Study and Prepare for Exams
How to Enable or Disable Archive log mode in oracle database 11g
ADOP Phasesin R12.2
fs_clonefailed :[UNEXPECTED] Error occurred running .pl files
Real Time Oracle Apps DBA Interview Questions 
Regards,

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