>  Operating System
>  Installations - Apps11i
>  R12 Topics
>  Installations - Apps R12
>  Patching
>  Cloning
>  Oracle Apps Upgrades
>  System Administration - R11/R12
>  Advance Features - Oracle Apps R12
>  Want to Become an Apps DBA ?
>  Certification - Apps DBA
>  Apps Performance
>  Oracle Apps DBA Interview Questions
>  Apps Day to Day Queries




Remember Me

Installation Guide for PeopleSoft 8.4

User Maintenance

>  Application Integration Architecture

RMAN - Backup & Recovery
Convert DB Character Set
Oracle 11g Topics
Oracle 11g DBA course


No menu items for this menu.

Want to join our site !!

Posted by: akr14feb on 03/09/2016 07:19 PM
Please send a mail to appsdba@appsdba.info, we shall send userid and password


Log In


Remember Me

Account Signup

Email Address:

Forgot Your Password?

This is a humble initiative for providing self help to people who really want to enhance their skills in Oracle Apps DBA, with special emphasis to the Administration area. The main motive behind this initiative has been the difficulties which I had faced when I ventured out to try my hands at Oracle Apps DB Administration. Though there were lots of information available out there in the web, I didn't find most of them handy as they didn't give importance to the fact that many people will look for detailed step by step explanation of each activity. So, I had to go through many channels to finally get the hold on the subject and reach the level I am in today. This was a tough and tedious process, and especially due to this reason, I wanted to come up with a simple and straight forward set of articles which will serve as a kind of "do it yourself" guide for all those who want to venture out to the galaxy of Oracle Apps DB Administration..

Also, anybody wants to contribute any article on Oracle and follows the standards what I have followed, I shall publish the same and I shall mention the author name. I am man who goes by an example, any work done should be able to be used by any lay person that is the whole idea of this site.

Happy learning!!

This website is free for lifetime, and if you guys are happy with the articles and feel that it has given a value addition you can always donate to http://www.vedanta-edu.org without there encouragement I wouldn't have reached so peak.

This site is been hosted by znet India, I really appreciate them. The content management is done using PHP, MySQL and Apache, thanks to my manager at Cambridge Solutions who has helped me to learn web designing.


Oracle 10g DBA Certified
Oracle R12/11i Apps DBA Cerified
Oracle 10g RAC Certified
"There is no better moment than the present, Be Present."

Created on 02/04/2003 10:24 AM by admin
Updated on 09/15/2012 07:04 PM by akr14feb
 Printable Version

The comments are owned by the poster. We are not responsible for its content.
Excellent Idea
Posted on: 2008-04-10 07:16:51   By: Anonymous

Idea of starting the site for knowledge share was excellent. I hope this site will become popular and helpful to the oracle apps world.

I have gone through ur "My Seven days of experience in Virginia" and " Good Morning America – It works ". Good one. While reading these articles the first impression i got is you are the person who enjoys the work whatever u do whether it is oracle apps or cooking :-).. I must say u r the allrounder in all the areas of computeres - Hardare and S/W. I came to know by ur mail that you know almost every s/w and configuring hardware on ur own( I remember Which is our Guru Nekkanti's aspire) . Would like to write some articles in this site with your kind permission.

I hope this site will be helpful to ORACLE WORLD..

Phani Varma
email: a_p_varma@yahoo.co.in

    Re: Excellent Idea
    Posted on: 2008-04-10 20:54:44   By: Anonymous
    Hi Phani,

    It was great to read your mail, you yourself are great motivator for the world, at very young age you have grown to the peak of success.

    Sure, you can surely send articles, I shall publish on your name.


      Re: Excellent Idea
      Posted on: 2012-01-09 12:29:20   By: joshipodili
        Edited By: joshipodili
      On: 2012-01-09 12:29:43
      Kishore Sir
      iworkd as a sql n plsql developer due to some reason i am job less now iam did my dba and apps dba course please guide me to
      set my life ihave 5 yras of gap
      please guide me


        Re: Excellent Idea
        Posted on: 2012-02-23 16:34:35   By: akr14feb
        Honestly to get a job, prepare your resume with 3 to 4 years experience, have a system in you home, practise all the DBA/Apps DBA activities, Google is so cool, you get whatever you want.

        Practise all the regular Oracle DBA activities like Installation, Backup, Recovery, upgrades, Cloning, Patching etc, Prepare for OCP Certification, Dream about it, and one day you will succeed, if possible work as faculty

        Don't worry about experience certificates, there should be some company in world who may like your talent :)


          Re: Excellent Idea
          Posted on: 2015-06-22 11:55:39   By: chakravarthy
          Hi everyone any one please send me the oracle apps dba concepts to my mail chakravarthyd4@gmail.com

    Posted on: 2008-06-04 17:24:03   By: Anonymous
    Simply Its Excellent... Motivative

    upgradation of R12.0.4 to R12.1.3
    Posted on: 2010-11-17 13:12:54   By: nivas123
    If any one has any doc on upgrading R12.0.4 to R12.1.3 please do send me or the note id or the link where I can download the doc.

      Re: upgradation of R12.0.4 to R12.1.3
      Posted on: 2012-05-12 00:32:36   By: soumya
      please can you provide upgradation document to mymail..

    Posted on: 2011-02-01 00:47:16   By: bhojsree2
    HI KIshore,

    Re: Excellent Idea
    Posted on: 2011-02-14 07:49:28   By: rajkumar

    I agree with Phani, I want send you thank you note to you for your efforts sharing knowledge, please send your email id.


    upgrade from 11.5.9 to
    Posted on: 2011-11-04 21:59:59   By: zavi
    this is first time am posting on any forum I have gone through
    some of your docs they are really excellent and very verbose.
    i would really appreciate if can send a doc related to oracle application upgrade 11.5.9 to

    Re: Excellent Idea
    Posted on: 2011-12-01 15:19:12   By: debabrata
      Edited By: akr14feb
    On: 2012-01-22 23:14:33
    Good afternoon sir.I m now doing the core DBA course and i want to go for the back end.So can you please suggest me which will be better for me i.e ORACLE APPS TECHNICAL or ORACLE RAC DBA ???.
    Please suggest me .

    Debabrata padhi

      Re: Excellent Idea
      Posted on: 2012-01-22 23:14:45   By: akr14feb
      If you have done core DBA course, you have 2 choices to proceed, the first one is Oracle RAC or Oracle Apps DBA

      But first gain your confidence on Oracle DBA on Linux and Unix platform


    amazing Idea
    Posted on: 2012-02-23 10:46:19   By: rstiwari
    I think you are amazing . This is a best Idea to share our knowledge through online network. If it is possible to share knowledge with help of class room (workshop).
    I am from India and I think RAC and other oracle or other training is so costly. it is good idea for improving knowledge.

    Re: Excellent Idea
    Posted on: 2012-03-31 16:36:55   By: Shiva
    Hi Kishore,

    Thanks for sharing your experience and thoughts with us,this is really good site with great information. I was searching for orcale apps information , then i found this blog and its amazing.I have completed my masters in IT from Australian university and now i want to do specialization in any subject and start my career in IT.Through one of my friends suggestion i have started thinking of doing oracle apps but i really dont have an idea of what this is , how to start and where to start.can you please,guide me in a right direction and how to proceed further with this.

    I have read your article Seven days of exp in Virginia it is really great and got to now your talent, determination and passion for the work.I got motivated by reading your article and thought of asking your suggestion in shaping up my carrer in oracle apps.


    Hi Kishore sir
    Posted on: 2012-04-17 16:55:25   By: akkapalli
    im not able to open my login home page in r12
    i installed on apps r12 on vmvare and all services are started apps as well as db
    pinging each other with linux and windows
    im not able to open my login page with internet explorer
    please provide solution

    Posted on: 2013-08-22 17:39:06   By: sekarcse4017
    Hi Sir,

    As mentioned in subject line in that document you mentioned path E , please can you share the path E for upgrading EBS with Database 12.1.1

    Chandrasekar s

    Job Inquiry
    Posted on: 2014-01-20 10:12:22   By: amit
    Hello Sir,
    I am OCA.Have 2 years of experience in teaching as well as I am oracle trainer. Now I am planning to search job in industry,but I am confused by which profile I should apply and how

Great Mail - My Seven days of experience in Virginia
Posted on: 2008-04-15 21:08:35   By: Anonymous
Hi Kishore,
Gone through your 'My Seven days of experience in Virginia
Guys' mail completely.

Excellent. You are having a great narration talent. We could visuvalise the things from your mail.

Your mail conveys 'HARDWORK , THIRST TO LEARN', 'POSITIVE ATTITUDE' to reach the GOAL of success.

Your Mail is an Great Motiviation to us.

Wishes for every succees in your future endevours!!!
(I am also preparing for a driving test @UK :)


    Re: Great Mail - My Seven days of experience in Virginia
    Posted on: 2008-04-15 21:11:29   By: Anonymous
      Edited By: akr14feb
    On: 2008-05-04 11:26:24
    I am blessed to read such a mail, I never thought I did such great achievement. I thought I had a jolly ride.

    Long back, I read somewhere that a blog closes if there is no proper response by the people but seeing the responses I am thrilled and shall do the best.


Hello Boss
Posted on: 2008-04-22 04:50:15   By: Pavan
  Edited By: Pavan
On: 2008-04-22 04:51:05
Hi Kishore,
Its really fantastic to see you after a long time coming up with this suprising gift,I conisder you as my guruji in oracleapps coz i started learning oracleapps from you in chennai . Your knowledge in apps and intrest towards the subjects was amazing. The days I spent with you are golden days for me where I have learnt much with in the short span of time.

Article My Seven days of experience in Virginia’ was excellent.

"The difference between the impossible and the possible lies in a person's determination" You have proved this once agin.

Pavan Kumar

    Re: Hello Boss
    Posted on: 2008-04-26 15:44:37   By: akr14feb
    Thanks Pavan,

    Well, I think you are in the right track, just keep upgrading your skills on Oracle Apps then things should be positive

    Let me know for any help


No Subject
Posted on: 2008-04-28 10:03:50   By: Anonymous
Hi Kishore,

Well and hope the same.
Approximately I had taken one day to read your website.First , I Congrats for your New job .Kishore, As you are having a good/nice/motivated personal characters, you are doing all this things.So the credit goes to your parents.When I was working with you, I learned/watched/Observed your good characters.

If you have time to come to s'pore,please do come to my house..


    Posted on: 2008-04-29 05:56:29   By: Anonymous
    I feel such a wonderful moments of this we are chatting one another with our Collegue[The Great Mr.Kishore]'s website. Am I right Subu?

    Kishore, really we have to thank you for all your support and Guidance for Learning.


    Srivishnuhari S

Hi Kishore
Posted on: 2008-05-07 05:25:01   By: Ramesh
Ur profile is very nice, i like ur positive thinking n guts. u r great. Ur website is very to useful to guide for us


    Re: Hi Kishore
    Posted on: 2008-05-08 14:41:13   By: akr14feb
    Thanks Ramesh,

    You guys gave me opportunity to grow and same thing I am returning to you through my website.


      Upgradation doc
      Posted on: 2010-09-29 17:20:57   By: sandeep
      Hi All,

      Can you please send me the document for upgradation for to R12
      the operating sytem we have is
      Enterprise Linux Enterprise Linux AS release 4 (October Update 6)

        Re: Upgradation doc
        Posted on: 2011-02-04 18:41:54   By: akr14feb

No Subject
Posted on: 2008-05-08 17:52:55   By: Anonymous
I loved the 7 days of exp in VA. Now I actually know why they loved you so much !!!

lets connect and keep in touch...always!


No Subject
Posted on: 2008-05-15 12:08:33   By: Anonymous
Kishore! My Man!

Why didn't you buy that car when you were here in Virginia, we could
have taken rides together and enjoyed the beautiful scenery. Anyway,
great car for a great man like you Kishore, you and your family deserve
it. Enjoy the beauty, the comfort, and the performance of a German
engineering car (the best in the world).


No Subject
Posted on: 2008-05-15 12:09:38   By: Anonymous
Hello Annaya
Car COOOOL undhi....

very nice one....!!!!

indeed you are becoming younger day by day.... :)

thnx for the pictures


No Subject
Posted on: 2008-05-15 12:16:45   By: Anonymous
My Dear friend Kishore,

It was really nice working with you and getting to know you. We had a lots of fun in the past few weeks working together, I know it was tense but we had good times.
Congratulation on your new car “Volkswagen EOS”, I wish you are here in Virginia so we can take a ride together.
I wish you best of luck on your new assignment in SFO and don’t forget about us, you always have friends here. If you get an assignment here in Washington DC area, don’t forget to let us know. We can always get together and enjoy good times.

Good Luck to you and Best Regards,

No Subject
Posted on: 2008-05-15 12:19:06   By: Anonymous
Go get em Kishore!!!!!! J. We miss very much man J. Hope things alright with you in Cali. Please let us know if you need anything, ok?

Take care my friend,
Sam Solomon

Hats off !!!
Posted on: 2008-05-16 04:18:57   By: Anonymous
Hi Kishore,

Salutes to your effort.

    hi kishore sir
    Posted on: 2012-03-19 20:06:20   By: sreekanthdba72
    i complted my dba and apps dba course presently im job less im 2010 passed out can u advise how to move forward to get a job

No Subject
Posted on: 2008-05-27 17:59:05   By: Anonymous
Dear Kishore

Excellent work done man, may god bless you.

Best regards,

    Posted on: 2008-05-30 01:39:43   By: Anonymous
    Really very good site. I also would like to become APPS DBA

    - Presently working as an ORACLE DBA. Please Guide me


To make a comment
Posted on: 2008-06-06 18:08:34   By: akr14feb
Please do use "Comments - Make a comment" - Button, for making comments


No Subject
Posted on: 2008-06-11 04:07:18   By: Anonymous
Hello Kishore..

Hope you are doing very well.... I came across your artical,

when i was searching for some good job on oracle apps dba...I found your artical very interesting. Really, it needs initiative in our life from your eternal soul and any thing can be achieved..

Hitesh Mishra

    Posted on: 2008-06-11 04:13:27   By: Anonymous
    Hi Hitesh,

    Thanks for your comments, All the Best to you.

    Its really good career plan to move into Oracle Apps 11i DBA and my full support will be there. Let me know if you need any help from me. Its always better if you can clear your 11i or R12 certification which will boost your confidence. R12 is now in beta which costs just $50. I can surely guide you.


Oracle DBA & Oracle Apps DBA
Posted on: 2008-07-06 14:07:18   By: anoop
  Edited By: anoop
On: 2008-07-07 12:44:40
Hello all.
My name is Anup. I want to learn Oracle Apps DBA. Some of my friends are working as Ora App DBAs and they suggested me to go for it. When I asked about that course in some institutions they are suggesting me to first learn Oracle DBA and then do Apps. But my friends have a basic knowledge of Oracle and they said to directly learn Apps. Please give me some suggestion whether I have to learn DBA first & then Apps or directly Apps is OK.

    Re: Oracle DBA & Oracle Apps DBA
    Posted on: 2008-07-08 01:14:32   By: akr14feb

    That's right, first we need to work as Oracle DBA then you will be comfortable working in Oracle Apps DBA that also u need to work in Linux/Unix environment. Its long way to go but you need to plan your career path accordingly and you will succeed.


What is the difference between oracle DBA & oracle application?
Posted on: 2008-07-29 14:18:23   By: Anonymous
What is the difference between oracle DBA & oracle application?

    Re: What is the difference between oracle DBA & oracle application?
    Posted on: 2008-07-29 23:28:55   By: akr14feb
      Edited By: akr14feb
    On: 2008-07-29 23:30:56
    Oracle DBA is just maintaining the Oracle database alone, but Oracle Applications is step forward, you have to maintain the Oracle Applications and the Database. Most of the activities are same as Oracle DBA, like taking backups, But here as Oracle Apps DBA, you will be involved in cloning,patching, system adminstration etc. Also, the billing rates are much better then Oracle DBA.

    Please go through the below link, what you need to know as a Oracle Applications DBA.


    Please do revert for more queries.


Thank you..
Posted on: 2008-08-19 16:46:51   By: Anonymous
It's really motivating me...

Thank you Kishore...

You have done a great work through it...

God Bless You...

Apps DBA
Posted on: 2008-09-14 12:13:52   By: salimka
Dear Kishore
Thank you very much for this wonderful site.
I am Salim , an Oracle Certifed DBA , working in Dubai for the last 9 years. Now ( too late) , I want to learn Oracle Apps DBA. I am not fluent in Linux/Unix , since my all servers were running on Windows ( My bad luck).
Next month I am planning to take my training on Oracle Apps DBA in Chennai ( Ikon Infotceh).Mean time I want to study Unix too. Please put your valuable comments on my career path , so that it will be a good motivation for me.

Best regards

    Re: Apps DBA
    Posted on: 2008-09-18 08:51:21   By: Anonymous
      Edited By: akr14feb
    On: 2008-11-19 03:52:53
    Hi Kishore,

    Best of Luck for your career and family too..


      Re: Apps DBA
      Posted on: 2011-05-30 16:34:08   By: Farhan
      Dear Kishore,
      I really appreciate your contribution to Apps Dba community.
      I need help i have planned upgrade of R 12.1.1 to latest R 12.1.3 on solaris platform could you let me total no. of number of patches with their numbers required to upgrade from 12.1.1 to 12.1.3.
      And one more help require from you i need to upgrade database also with oracle apps currently i have database release to 11.2.0 kindly provide me the document.

      Thanks for your Support

        Re: Apps DBA
        Posted on: 2011-06-01 13:38:37   By: Farhan
        Dear Kishore i am waiting for your esteemed reply

          Re: Apps DBA
          Posted on: 2011-06-19 22:18:45   By: akr14feb
          Please follow the below notes


Hello Kishore
Posted on: 2008-10-11 00:10:09   By: Sadikb
  Edited By: Sadikb
On: 2008-10-11 00:11:04
Hello Kishore, I reached your site through a friend and I am quite impressed. I also have an Oracle Forum

God Bless and keep writing such wonderful stuff.

    Re: Hello Kishore
    Posted on: 2008-10-11 12:28:48   By: yogeshbhutda
    Dear Kishore
    Thank you very much for this greatefull site.

    Re: Hello Kishore
    Posted on: 2008-10-14 01:11:35   By: Anonymous
    Thanks dude

No Subject
Posted on: 2008-10-21 02:35:37   By: Anonymous
Dear Mr.Kishore,

First of all, I sincerely congratulate for maintaining a wonderful site with excellent updates about the e-business suite which provides a wealth of knowledge to the seekers.

I have been a regular visitor of your articles and also been working as an Apps dba in UK. I have a small request for you. I would like to write 11i Apps DBA exam so which one should i write? I am bit confused with the numbers. Is it IZO-233? Since i am a certified 10g OCP dba i think i can write oracle IZO-233 to become 11i ebusiness suite dba. Could you please let me know which exam should i appear for.

Thanks in advance

    Posted on: 2008-10-21 02:35:59   By: Anonymous
    Hi Rajasekhar,

    Thanks for your comments.

    You can take 1Z0_233 (11i Certification) or you can take 1Z1-238 (R12 Certification - Beta).
    Which ever you are comfortable.


not able to login ID
Posted on: 2009-02-06 15:10:36   By: Anonymous
Hi ,

IT's really good portal for oracle apps dba. good to see this. but i'm facing the issue related to the login.
I've tried to signup for new account. I have type my user name and email id. But still I coluldn't get any kind of mail bywhich i can login to this portal.
Will u please help me on this.


    Re: not able to login ID
    Posted on: 2010-06-03 07:16:21   By: akr14feb
    Let me know your login-id please


Strive for the Excellence, Success will chase you…
Posted on: 2010-05-28 12:42:36   By: reenab_sai
Hello Kishore Sir,
Actually i was googling for some materials on oracle when i came across this site of yours.
Its really worth reading.
Your's hard work gets reflected & it can be proven as a stepping stone for success for the one who are Oracle DBA's & Oracle Apps DBA's & striving in a quest for sunny days.
Appreciating you a lot!

Thnx & Rgds
Reena Balwant Sangode
OCP Certified.

    Re: Strive for the Excellence, Success will chase you…
    Posted on: 2010-06-03 07:20:02   By: akr14feb
    Thanks a lot.


      Re: Strive for the Excellence, Success will chase you…
      Posted on: 2010-06-13 19:58:34   By: neelam
      hai kishore sir,

      Really its very good for apps dba's
      Thanks for sharing all this stuff
      Thanks a lot sir

Upgrade 11.5.9. to
Posted on: 2010-07-06 07:57:35   By: raammadala
Hi Kishore,

I am new guy to apps dba.as per my knowledge this is good site for dba and apps dba's.please post the upgrade doc for me


    Re: Upgrade 11.5.9. to
    Posted on: 2010-07-11 14:18:52   By: akr14feb
    Thanks, here is the link for the upgrade


Posted on: 2010-08-04 09:24:41   By: simmisahay
Hi Kishore,
I was searching some oracle martial on Google and came across this site and seeing your photo I recognized you.
I am really appreciating your achievement.
Have you recognized me?
I got experience on oracle 10g development side. I want to go for oracle DBA. Please suggest which is good oracle appa DBA or Oracle10g DBA.

Simmi Sahay

    Re: Hi
    Posted on: 2010-09-01 16:12:57   By: akr14feb

    Its always better to know Oracle 10g DBA then only u need to get trained on Oracle Apps DBA,

    Revert for further queries.


kaleem pasha
Posted on: 2010-09-23 11:02:18   By: kaleempasha
can anyone help me in learning different configuration files for oracle apps r12

No Subject
Posted on: 2010-09-23 11:37:05   By: kumarsdba

Dear Kishore,

I hope you are doing fine, your sites seems to be very nice and useful for everyone

please try to send printer configuration (windows samba) details at the earliest

Nice document
Posted on: 2010-09-23 11:40:15   By: kumarsdba

I never read this type of documents very nice

you updating each and everything with screen shots also it's good

    Re: Nice document
    Posted on: 2012-10-05 09:53:54   By: akr14feb
    Thanks a lot


oracle HRMS
Posted on: 2010-10-13 00:27:31   By: shakir

Could plz tell me somethin about ORACLE HRMS..I'm new to this.

oracle application
Posted on: 2010-11-03 15:33:23   By: raghavendrachari
I am raghavendra , I just completed MS(IT) , i am interesting to learn Oracle Apps R12 Technical and looking my career in Oracle Stream. But some one suggest learn Oracle Apps DBA instead of R12 technical.which one is best for my career. Can u plz suggest.
thank you

    Re: oracle application
    Posted on: 2010-11-07 07:03:55   By: akr14feb

    Both are different fields, you need to decide, one is developer path and second one is DBA path, for DBA path its better to learn Oracle DBA, Oracle Apps DBA, Oracle RAC DBA, Streams etc..... For Developer path, Developer forms, Oracle Apps Technical, OAF, XML/BI Publisher, SOA etc....


      Re: oracle application
      Posted on: 2010-11-08 10:14:00   By: raghavendrachari
      can you suggest me which is having good career for freshers.In my masters program i did projects on Java, Web Technologies,MySQL, and Apache 2.X.

        Re: oracle application
        Posted on: 2010-11-10 07:05:38   By: akr14feb
        Both are good fields, whether to go development or adminstration our interest should match. I have seen MS students have selected either of the fields and are succesfull

        I have no idea about java technologies

        Revert for further queries.

      Re: oracle application
      Posted on: 2011-06-22 14:08:29   By: syed_apps_dba
      Hello kishor,
      My name is Syed, I am new to oracle DBA and oracle Apps.
      My total experience in IT is 7+ but I started working on oracle platform from past 3 months.
      I request you help me in getting more knowledge on Oracle Apps.
      I have registered in www.appsdba.info and my login name is syed_apps_dba

wanted cvs
Posted on: 2010-12-27 22:40:21   By: kasulananth
As i am working Oracle APPS, i want to add fusion middleware admin + 10g AS admin concepts in my cv, can u tell me /give me the roles & responsibilities of the above said roles i.e., FUSION MIDDLEWARE ADMIN + 10g AS ADMIN

Hi Welcome
Posted on: 2010-12-30 17:08:02   By: arief
  Edited By: arief
On: 2010-12-30 17:11:21

Hi I am Arief. In an oraganization i am going to start my career as apps dba (currently under training) and i am confused abt apps dba .I heard abt Kishore sir . if i need any help can i consult u and acees ur site for getting info .pls help me to be a good apps dba . tHIS NEW yEAR WITH LOTS OF HOPES AND JOY. I am entering into a n New world of apps dba ...loking for ur support...

HAPPY NEW YEAR Sir and to all my collegues

Thanks & Regards

    Re: Hi Welcome
    Posted on: 2011-01-12 13:21:33   By: akr14feb
    Sure, All the Best for your New Job.

    Please post your queries me @ akr14feb@gmail.com


printer tray selection with CUPS, PASTA, and postscript
Posted on: 2010-12-31 04:27:19   By: 351c
I am trying to get information on best practices for printer tray selection with a Linux, CUPS, PASTA, postscript, and R12 configuration. I have read some information about solutions with CUPS and possibly BIP. Can anyone suggest a solution for printer tray selection for this type of configuration? Thanks.

its an inspiration
Posted on: 2011-01-06 12:54:24   By: rajeshv
thanx a lot

career for Ora apps technical?
Posted on: 2011-02-02 04:05:24   By: raghavendrachari
Hi kishore,

How is the career in Oracle apps r12 technical?

I heard Oracle is developing a standard Applications with Java as front-end and so in future no career for Ora-apps technical. Is this information correct?

I am seeking my career in Oracle Apps developing.Could you please clarify my dought?


    Re: career for Ora apps technical?
    Posted on: 2011-02-02 08:31:00   By: akr14feb
    Career in Oracle Apps technical is good, focus on OAF, SOA, XML/BI Publisher, Jdeveloper etc

    Please revert for further queries


Required documents for adsplicing
Posted on: 2011-04-03 22:28:44   By: sreenathareddyg
Hi kishore,
Can u provide docs for adding a new product to oracle applications i.e adsplice.......

    Re: Required documents for adsplicing
    Posted on: 2011-04-06 19:17:39   By: akr14feb
    Here is the link - AD Splicer with example


Need Docs on Apps dba functional
Posted on: 2011-05-02 01:33:53   By: sri
Hi Kishore,
Your site is really informative.
I need some info on regular DBA activities on functional side. And also some docs to learn - Performenance tunning / Indexes / Views and Adhoc reporting. I really need them very badly...appreciate your help...many thx

    Re: Need Docs on Apps dba functional
    Posted on: 2011-05-16 23:14:26   By: sri
    Hi Kishore,

    Did you get a chance to look at the info I requested.
    If possible would you please send me your phone number to my mail (sri.narayana11@gmail.com) id - I can call you and explain my problem am facing at my client place....really urgent....Appreciate your efforts...many thx

      Re: Need Docs on Apps dba functional
      Posted on: 2011-06-02 07:11:52   By: akr14feb
      I have a send mail, please check

Splendid and Greatly enriching website
Posted on: 2011-05-12 13:14:48   By: satishmc
Great effort, thanks a Lot Kishore. Many folks out there like me will benifit a lot from your expertize shared.

ADS Sync with Oracle EBS r12
Posted on: 2011-05-31 18:00:13   By: krunal1986

Is there any document which provide details about synching microsoft ads server with ebs r12.

need ur help regarding it.


    Re: ADS Sync with Oracle EBS r12
    Posted on: 2011-06-02 07:12:28   By: akr14feb
    I have send a mail, please check

Is it good to start career in Oracle Apps DBA
Posted on: 2011-06-30 16:13:26   By: Satyabrata_Behera101
  Edited By: Satyabrata_Behera101
On: 2011-06-30 16:13:54
Hi Kishore,
Thank you for your all effort. I hope this site will help all the Apps DBAs.
Hey kishore I am fresher to the IT industry & now I am going to start my career with Oracle Apps DBA. Am I on my right path or not??? Can you give me some information as I am about to start my career in Oracle Apps DBA. Should I take this oppertunity or not???

Thanks & Regards,

    Re: Is it good to start career in Oracle Apps DBA
    Posted on: 2011-07-06 17:13:35   By: akr14feb
    Yes, you are on the right path, but the path has many obstacles, step by step you need to follow to get success

    > Oracle DBA
    > Linux/Unix Adminstration
    > Oracle Apps DBA

    Shoot a mail at akr14feb@gmail.com for more any queries.

    All the Best !!!


hi kishore
Posted on: 2011-07-08 09:44:27   By: srregatireddy
I am trying to install oracle apps R12(x32) on oracle EL 5 (X32).

After installation and during post installation checks "HTTP" failed

Here is the error message:

checking URL = http://home.srihome.com:8000
RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

Virtual Directory
RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

Login Page
RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

Help Page
checking URL = http://bronze.gateway.2wire.net:8003/OA_HTML/help
RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

checking URL = http://bronze.gateway.2wire.net:8003/OA_HTML/jtfTestCookie.jsp
RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the
Can you please help me how to rectify this?

    Re: hi kishore
    Posted on: 2011-07-08 14:46:00   By: akr14feb
    This is known error in RHEL 5 or OEL5

    connect as root -
    ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

    Now start the apache

      Re: hi kishore
      Posted on: 2011-07-10 11:46:02   By: srregatireddy
      Is that error related to RAM SIZE also?Because my friend told that RAM size is less..I am using 3GB RAM.

      Re: hi kishore
      Posted on: 2011-07-10 11:48:41   By: srregatireddy
      What is the minimum RAM size need to install oracle apss dba r12?

      Re: hi kishore
      Posted on: 2011-07-13 10:12:13   By: srregatireddy
      Same error is coming again!!!!!!!

        Re: hi kishore
        Posted on: 2011-07-16 07:25:36   By: akr14feb
        3 GB should be enough, send queries to akr14feb@gmail.com

        Will try to fix the issue.


Needed the steps involved in Demantra integration with EBS
Posted on: 2011-07-26 21:57:32   By: raghu
Please help me in this, I want a step by step explanation for the integration process between EBS R12 and Demantra. Please take an example item information. This data has to pass to Demantra.
Please explain me, that would helps me a lot.

Thanks in Advance

    Re: Needed the steps involved in Demantra integration with EBS
    Posted on: 2011-08-02 08:35:08   By: akr14feb
    I can help with the Integration of EBS with Demantra but the data population is normally done by the technical guys


Agile plm 6.0 installation.
Posted on: 2011-08-05 16:59:12   By: anandkumar99
Hi Sir
I am trying to install Agile plm 6.0 on windows server 2008.But I am getting some issues.could you please provide any documentation OR any screen shots.

    Re: Agile plm 6.0 installation.
    Posted on: 2011-08-11 15:59:14   By: akr14feb
    Try the below, hope it helps


oracle apps dba R12 installation
Posted on: 2011-08-23 08:37:24   By: rizwanappsdba
I need to install Oracle EBS R12.
I have many Oracle EBS R12 Stages on Shared Storage disk. From which file I can know whether a particular Oracle EBS R12 Stage is for Windows, Linux , Solaris or HP-UX.
I will be thankful for your if u could help me.

You are the MAN
Posted on: 2011-08-31 01:05:37   By: bnikhil08
Seriously you are great motivator.

You are the MAn for me.... and your website ROCKS...

can i have your contact number. i would LOve to speak to you.


windows server and linux client connection by ADS
Posted on: 2011-10-15 15:11:09   By: anoopkp
  Edited By: kanagamanian81
On: 2011-11-02 07:44:03
HI Kishore

we have plan to connected the linux client user to windows server 2008 ADS .

you have any idea Pls help ....

OPP Error
Posted on: 2011-11-12 02:22:44   By: deepakkumar
Hi All,

We are a mid range Oracle EBS client running on R12.0.4. We have a major issue with OPP process. Any PDF/Excel reports are failing with the following error.
Executing request completion options...

+------------- 1) PUBLISH -------------+
Beginning post-processing of request 15383132 on node ERLOPD1 at 09-NOV-2011 14:50:55.
Post-processing of request 15383132 failed at 09-NOV-2011 14:51:52 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.

Here are our details...
we are on R12.0.4 -- x86 / Redhat Linux 64 bit.
We tried increasing the memory at Conc Prg level.
Our developer parameters J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m.
Jave heap size is set to 2GB.

Any sugesstion will be greately appreciated.
Thank you

Oracle dba & apps dba
Posted on: 2011-11-23 12:34:43   By: ganeshdba
Hi I like this site and would like to join this forum.

adpreclone.pl error
Posted on: 2011-11-30 16:15:20   By: vnarasimharao11
  Edited By: vnarasimharao11
On: 2011-11-30 16:17:12
Hi All,

I got this below error when i run adprclone.pl on database tier.

Application version:12.0.6
Database :10.2.0

RC-50208: Exception in method gen_SQL_script
Raised by oracle.apps.ad.tools.AdCreateCtlFile
RC-50208: Exception in method gen_crctrf_sql
RC-50208: Exception in Constructor AdCreateCtlFile
Raised by oracle.apps.ad.tools.AdCreateCtlFile

java.lang.ArrayIndexOutOfBoundsException: 1 >= 1
at java.util.Vector.elementAt(Unknown Source)
at oracle.apps.ad.tools.AdCreateCtlFile.parse_file_list(AdCreateCtlFile.java:2006)
at oracle.apps.ad.tools.AdCreateCtlFile.gen_SQL_script(AdCreateCtlFile.java:1834)
at oracle.apps.ad.tools.AdCreateCtlFile.gen_crctrf_sql(AdCreateCtlFile.java:868)
at oracle.apps.ad.tools.AdCreateCtlFile.(AdCreateCtlFile.java:413)
at oracle.apps.ad.clone.StageDatabase.genRecreateScripts(StageDatabase.java:617)
at oracle.apps.ad.clone.StageDatabase.doStage(StageDatabase.java:332)
at oracle.apps.ad.clone.StageDatabase.(StageDatabase.java:292)
at oracle.apps.ad.clone.StageDBTier.(StageDBTier.java:153)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
at java.lang.Thread.run(Unknown Source)

RC-40001: Failed to create sql script adcrdbclone.sql for recreating control files at target
Raised by oracle.apps.ad.clone.StageDatabase

Pls help


    Re: adpreclone.pl error
    Posted on: 2011-12-04 22:16:58   By: akr14feb
    Is is cold cloning, if yes check whether the database was shutdown in normal mode

Contact information
Posted on: 2011-12-22 01:58:42   By: spavlovsky
Hi Kishore,

I was reading you post and I can tell you know a lot about Oracle. I'm a recruiter for a Steel company in the United States and we have many positions available that requires Oracle experience. I'm not an expert in this matter and I was wondering if you might be able to help me.

This is my email address sol.pavlovsky@myrecruitmentservices.com, if you have a couple of free minutes would you send me an email with your contact information so we can talk about it?

Thank you!


Upgrading EBS 11i to R12.1.1
Posted on: 2012-01-08 19:18:33   By: sameer_dba
Kishore sir

First of all i would like to congratulate you for providing the information to the people all over the world. You are doing a great job. sharing knowledge is not possible for everybody only great souls does.

Sir i am a fresh dba and i want to upgrade from EBS 11i to R12.1.1 and kindly can you send me the document with details and commands to operate the steps.
1. Pre-update steps (with commands)
2. update steps with commands
3. Post-update steps with commands
my email id: getsameer57@yahoo.com

basic info:
platform:oracle enterprise linux 4 update 4

Thanks with anticipation

    Re: Upgrading EBS 11i to R12.1.1
    Posted on: 2012-02-23 16:55:02   By: akr14feb
    Please go through this link


output post processor issue
Posted on: 2012-01-14 18:47:42   By: sameer_dba
Hello sir
After cloning on test server i found everything correct.
then i run autoconfig on database server and on application server both. after that i found
output post processor actual=0 target=5 in apps

Oracle Identity Mangement
Posted on: 2012-01-17 11:56:13   By: Farhan
Kishore i am very much excited by visiting your appsdbainfo blog's contribution for apps world.

I need information regarding Oracle identity management.
what contents it has,its benefits with oracle apps,its purpose for apps dba's

Your prompt reply will be highly appreciated.


Hi kishor
Posted on: 2012-01-21 19:20:42   By: amit_apps

Kishor I'm working as a Sr. Principal consultant with Oracle corp. I want moved on Oracle apps technical as soon possible, I already taken training of Oracle Apps technical for one of the Delhi Institute & also having a good knowledge of SQL, PL/SQL, oracle apps, D2K. and till the time not able to select which module would be good for more please help me out.

Amit Kumar

    Posted on: 2012-01-22 17:42:00   By: engalim

    I face a problem when i try to apply patch after clone the PROD, I got the following error when i try to enable mint. mood
    error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

    Best regards,

apply maintenance patch to
Posted on: 2012-01-28 08:51:38   By: summerkool07
  Edited By: summerkool07
On: 2012-01-29 10:13:41
Hi Kishore as said above i have searched many docs an d metalink for upgrading from 11.5.9 to i understood it but i can't implement, am still a learner so i dont know how to start please help... my email:summerkool07@gmail.com

Hi Kishore,
I usually visit this site and this is very informative and really appreciate for the Knowledge sharing...
Am looking for applying maintenance patch to to upgrade to please provide the solution for same
any help...

    Re: apply maintenance patch to
    Posted on: 2012-02-23 16:57:57   By: akr14feb
    Please shoot a mail to akr14feb@gmail.com


Oracle Identity Mangement
Posted on: 2012-01-30 14:29:17   By: Farhan
Kishore i need your help in oracle identity management .
Please share info about Oracle identity Management.

Your reply will be highly appreciated..


    Re: Oracle Identity Mangement
    Posted on: 2012-02-24 23:53:39   By: akr14feb
    Please shoot a mail, I shall guide you..

guide me
Posted on: 2012-02-12 22:15:26   By: sudheer
i am doing my btech 3rd year in ece.I want to do ms in cse i have learnt sql/plsql(can you tell me is this course useful in my way to become dba) and shortly going to undergo dba course.sir can you please guide me what courses i have to take after completing dba course and i am intended to get oca and ocp certifications so please guide me about this certifications and suggest me some tips to pave a path from a btech ece student to a dba.

    Re: guide me
    Posted on: 2012-02-22 18:36:47   By: bhargav
    i am very much interested to do certification on oracle apps dba.So, i want to know what exams i have to clear before making a attempt on oracle apps DBA. I have learnt linux5.5,sql,Oracle DBA and apps DBA.
    Hope You can help me...Thanks to this website developers

      Re: guide me
      Posted on: 2012-02-23 16:53:38   By: akr14feb
      Plese go through this link


    Re: guide me
    Posted on: 2012-02-23 16:56:54   By: akr14feb

    Start with Oracle DBA, linux etc once you are confident, go for certification, then you can try Oracle RAC or Oracle Apps DBA


Oracle Apps clarification
Posted on: 2012-02-28 16:27:18   By: srieros
  Edited By: srieros
On: 2012-02-28 16:27:46
Hello kishore,

I am working as a Oracle DBA i have 2 yrs of experience. I would like to build my career as a Oracle Apps DBA. Please let me know if i am making the right choice or not(by opting for Oracle Apps DBA)???

In my current organisation there is no Oracle Apps DBA vacany, so once i get myself trained in Oracle Apps i have to move out to another concern.So am i a bit nervous thinking if i could get a job in Oracle APPS DBA, as i have just 2 yrs of experience that too in Oracle DBA.
And finally please suggest a good training centre for Oracle Apps DBA in chennai.

Your website is really great, many thanks for your help.


    Re: Oracle Apps clarification
    Posted on: 2012-03-07 21:13:18   By: akr14feb
    Sure, it would great if you could update to Oracle Apps DBA, shoot a mail to akr14feb@gmail.com.


i need your help plz guide me:
Posted on: 2012-03-11 15:48:51   By: namrata
my name is namrata sharma and i got through mca in dec 2011 from ignou.
i want to make my career in oracle but i am confused that what should be my first step????
please help me

    Re: i need your help plz guide me:
    Posted on: 2012-03-14 21:08:34   By: akr14feb

    To start a career in Oracle Database Administration, here are the steps

    > start with Oracle sql/plsql
    > Oracle DBA
    > Gain knowledge on Linux/Unix

    Have a system at your place, install and practise these topics.

    Let me know for further help


Posted on: 2012-03-24 12:38:58   By: lsh
Hi kishore,
im new to this site,i complted my Oracle apps course, presently im job less now im trying on Oracle apps,i have 3yrs gap, now i want to change my field,so now i need Oracle apps projects and resume format also,can u advise me how to move forward

No Subject
Posted on: 2012-04-02 07:48:16   By: Shiva
Hi Kishore,

Thanks for sharing your knowledge and experience with us.this is a great site and very informative specially for starters who are looking for information about orcale apps.

I have found this blog when trying to get some information about orcale apps and its really good place to be here. I have done my Masters in IT from Australian university and how looking to do specialisation in any field and move on with it.through one of my friends suggestion i have started thinking of doing orcale apps ,but i have no idea where to start, how to start and how to prepare.

kishore can you please guide me through this and help me out in building my career.


    Posted on: 2012-04-07 10:03:13   By: akr14feb
    Welcome to the world of Oracle Apps

    Well to gain knowledge of Oracle Apps, here are steps

    > Oracle DBA
    > Linux/Unix Administration
    > Oracle Apps DBA

    All the Best !!!

    Revert for further queries

oracle dba
Posted on: 2012-04-05 11:59:49   By: ekta
hello sir,
i m doing the core dba course.pls tell me wat is oracle apps dba and pls give knowledge about oracle modules.i want to become an oracle dba but also wants to know little knowldge abt oracle apps modules.

    Re: oracle dba
    Posted on: 2012-04-07 10:08:45   By: akr14feb

    You are mixing Oracle DBA and Oracle Apps funcationals modules, a Oracle Apps DBA need not know about the Apps modules, there are different people working on Oracle Apps

    > Funcational Consultants / Apps Domains Analysts / business Analysts
    > Technical Consultants
    > Oracle Apps DBA / System Adminsitrators
    > Linux / Unix Adminstrators

    Each area is a ocean and you need to choose the right path, for a Oracle DBA, Oracle Apps DBA is related where he works on below activities

    > Installation
    > Patches
    > AD Administration
    > Cloning
    > System Adminstrations
    > Upgrades
    > Backups etc

    Revert for further queries

future guidance
Posted on: 2012-04-13 19:06:21   By: sunil_t
Hi sir,I am sunil,currently working in mahindra satyam as a network administrator.I have been looking your posts since a long time and they inspired me a lot.you are simply amazing.
I felt that this is the right place for my queries to be answered.
I am B.SC(comp. science) graduate.Do i have any opportunities to become a Oracle DB administrator with my degree.If so what how can i be?
here is my profile for your reference.
Educational qualification:B.SC.(Comp.science,2010 passedout)
occupation:network administrator in mahindra satyam since 2011.
awaiting your valuable response.
thank you.

sunil kumar

    Re: future guidance
    Posted on: 2012-08-14 21:44:19   By: akr14feb
    Sure Sunil, you can become of Database Administrator, most of my friends with Bsc/Bcom have entered have are good positions

    Send me a mail to akr14feb@gmail.com for further queries


please guide me
Posted on: 2012-04-17 17:00:25   By: akkapalli
  Edited By: akkapalli
On: 2012-04-17 17:02:54
hi kishore sir
im not able to my login home page from my windows internet explorer
i installed apps r12 on vmvare ans services are successfully started apps and database pinging each other linux and windows

    Re: please guide me
    Posted on: 2012-08-14 21:45:52   By: akr14feb
    Have u made entries in the hosts file in windows


    hosts files

oracle apps dba
Posted on: 2012-04-30 16:42:42   By: mallikarjunreddy
  Edited By: mallikarjunreddy
On: 2012-04-30 16:47:16
Hi Sir,
I am mallikarjunreddy working as a core oracle dba in small company.Here i don't have much work to do.I am not able to decide myself either to learn RAC DBA OR APPS DBA and iam having just 1.7 years of experence.kindly please give me advice wheather I should go for oracle dba rac course or apps dba.


    Re: oracle apps dba
    Posted on: 2012-05-10 10:36:41   By: akr14feb
    If you ask me, I would say go for Oracle Apps DBA, shoot me a mail @ akr14feb@gmail.com for more details


      Re: oracle apps dba
      Posted on: 2012-07-23 19:33:23   By: shahzad53

      curent i am working as a oracle core dba in saudi arabia, planning to become apps dba but some of my friends telling me that before appsdba course you should have minimum knowledge to oracle application server 10g after that you study appsdba course, Kindly guide me.

      shahzad Khan
      Saudi Arabia.

        Re: oracle apps dba
        Posted on: 2012-10-05 09:53:17   By: akr14feb
        I don't think so, for learning Oracle Apps DBA, u need Oracle DBA on linux or Unix platform with 1 to 2 experience


        Re: oracle apps dba
        Posted on: 2012-12-22 10:15:00   By: Arijit13
        Hi, hope u are doing good. Well came to know that you are interested to learn oracle apps.I want a opportunity to teach someone apps. If interested please contact me 8884855958. Don't think I am doing for money. It's just want to share my knowledge and test myself.

        Yes I am not the best. But you can expect 100 % from me.

    Re: oracle apps dba
    Posted on: 2012-08-31 20:01:24   By: murthy
      Edited By: murthy
    On: 2012-08-31 20:03:09
    for mailid addition

    HI, I am working in wipro infotech as a systemadmin/database admin from past 4 years. I have competed OCA and taken training on oacleappstechnical11i earlier.I completed M.B.A

    Here i don't have much work on oracle in this project. I am not able to decide myself either to learn oracleappsdba or SAP BASIS. my mail id is ramana.chaganti@yahoo.com
    Please suggest us to better career.

Posted on: 2012-06-18 12:58:02   By: kumar777
1) How will check Apache is working in Front-end and Back End?
2)Write down the methods to identify whether the application is in maintenance mode or not?
3)What happens when the result of unsetting APPLCSF?
4)What are the tables updated when you apply application patch?
5)How Application login works?
6)How to change the HTTP port in R12?

Recovery Issue
Posted on: 2012-07-18 21:37:45   By: oradbase
  Edited By: oradbase
On: 2012-07-18 21:39:55
Excellent job, Really I Appreciate you for sharing great Knowledge.

Currently I facing a problem in Recovery.

One Month back I perform Complete Cold Backup.

DB Server Crash , DB is in Archive Mode i have all Archive Logs & Current Control File.

I Prepare New Server with Same IP , HOSTNAME , USERs & Groups , & same path location for oracle home , I install Oracle Software.

Restore Last Month Cold Backup to appropriated path.

The Main Problem is one non-system datafile is corrupt in cold backup, while recover i am getting porblem.

1) i Have last Month Cold Backup but non-system DBF is Corrupt.

2)I have all Archive Log Files

3) I have Current Control File.

I try , start instance in mount by using current controlfile & offline corrupted dbf & Move corrupted dbf.
SQL> i create new datafile with same name
then try to recovery.

Still i am getting problem.

Can you please Send me Step by Step on this Scenario


Please provide 1Z0-238 study material.
Posted on: 2012-08-16 12:58:32   By: mbaliyan
Hi Kishore,

This is very usefull forum to learn. I want to go with oracle apps certification EBS R12: Install, Patch and Maintain Applications - 1Z0238.
Please provide softlink for study material or derictly mail this to my mail id : mkb.simi@gmail.com or baliyan.mkb@gmail.com

Problem with Apps os user while installing
Posted on: 2012-09-20 19:41:15   By: ashok
Dear Kishore,

I got same user for DB OS user and APPS OS user at the time of installation.Can you clear this problem.


    Re: Problem with Apps os user while installing
    Posted on: 2012-09-27 20:36:25   By: murthy

    I Completed MBA(Finance & marketing) and also completed OCA 9i.

    I Have 4+ years experience as a IT administration but don't have bachelor computer degree.

    I am interestin to learn oracledba & apps dba
    Please suggest us for can i choose my career path as ORACLE DBA or APPSDBA.

    Please suggest us.


Upgradation Doubts 11i to R12 from danesh khan
Posted on: 2012-10-03 17:42:39   By: akr14feb
  Edited By: akr14feb
On: 2012-10-03 17:49:40
Hi Kishore.

This is Danesh, new to world of APPS i had seen your blog its good & informative.

I started interviews in Apps. because in institutes they will not tell the proper up-gradation and real-time scenarios.

I am having some doubts in 11i to R12 upgrade pls check.

1. During upgradation why we have to drop MRC schema?

2. Why ADI patch is required?

3. Why ATG patches required?

4. why we have to create or increase the size of tablespaces & which tablespaces we have to create? during upgrade?

5. why we have to apply autoconfig patches? because autoconfig is already present?

6. Can i practice a basic upgrade in my laptop from 11i to R12? what i need?

7. why we have to apply patchset 19 for developer? for 11i what is the patch version for developer?

8. we have to increase the block size also during upgrade?

9. What are symbolic links? when it is required?

10. One of my friend said every upgrade is different what it mean?


Here are my responses

1. During upgradation why we have to drop MRC schema?

Kishore - if you are upgrading from 11.5.9 or to R12 we don't MRC, I am not sure with earlier version. I think that schema is not available in 11.5.9 or

2. Why ADI patch is required?

Kishore - See these threads/docs.

version of ADI release?

Note: 144270.1 - How to Find ADI (Applications Desktop Integrator) Patches on My Oracle Support?
Note: 184090.1 - How to Find and Download the Latest Applications Desktop Integrator (ADI) Patches via Metalink
Note: 382973.1 - How to Get the Latest Version of ADI Patches From Metalink


3. Why ATG patches required?

Kishore - If you want to work with 11g database then we apply interoperability patches, ATG rollup 7 is mandatory before you can upgrade

4. why we have to create or increase the size of tablespaces & which tablespaces we have to create? during upgrade?

Kishore - 11.5.9 follow "one product -- one schema", R12 uses OATM techonology, In OATM fewer tablespaces are used, patch 7197489 has more details which creates the necessary tablespaces.

5. why we have to apply autoconfig patches? because autoconfig is already present?

Kishore - It is always advisible to keep autoconfig patches to the latest, this may be a pre-req for other patches

6. Can i practice a basic upgrade in my laptop from 11i to R12? what i need?

Kishore It depents on the configuration you have, if you have 4 GB with 400 GB HDD u can try

7. why we have to apply patchset 19 for developer? for 11i what is the patch version for developer?

Kishore - This is pre-req, if you are upgrading the database to latest version. Refer interoperability patches note

8. we have to increase the block size also during upgrade?

Kishore - I have never done during my upgrade experience

9. What are symbolic links? when it is required?

Kishore - In computing, a symbolic link (also symlink or soft link) is a special type of file that contains a reference to another file

If you install R12 on Oracle Enterprise linux, apache fails and here is the solution

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

Also, we create a symbolic link for the Apps environement file as follows instead of copying it

APPSEBS.env -> /d02/oracle/EBS/apps/apps_st/appl/APPSEBS_linux1.env

10. One of my friend said every upgrade is different what it mean?

Kishore - Yes, your friend is right, I have done 5 upgrades and each was different experiences, one was 11.5.9 to R12.1.3, other was OS upgrade AIX to Linux and Application upgrade from to R12.1.3. The experience count but it may slightely vary.

Have a Great Day !!!

Queries from Sohail
Posted on: 2012-10-03 18:11:43   By: akr14feb
Query 1

Hi Kishore.

This is Sohail fresher to APPS hunting for a job. It was nice to see your blog its very informative.specially patching & Cloining.

i have some doubts pls clear.

1. when i submitted Active users request only the result is displaying request submitted sucessfully. i think this request is submitted to check how many acitve users are connected to the application.

purpose for submitting this request.

Thanks in Advance.

Here is my responses

Hmm, the Active users - only will let us know the Active users in out database but not connected users

Use the below link to the connected users



Thank u kishore


Query 2

Hi Kishore,

Hope you are fine, pls check this doubt.

In one of my friends company every first week of the month they are running Accounting report from front end.

which is generating huge archive logs and they are increasing space also in archive logs destination.

They are using R12.

My doubt is just to understand this business application.

1. What is this accounting report & when to run this accounting report.
2. Why it is taking more space in archive log destination.
3. Accounting report is a request which will submitted by the application users ?

Pls clear this.



Honestly for a Apps DBA it doesn't matter what report they run, if they require space we just add them, there ends the story, we don't really care what a program does.


Thank u somuch

Query 3

Hi Kishore.

Hope you are fine.

1. what is the difference between EXADATA & Oracle E-Business Suite?

2. what is the difference between ORACLE10g AS & Oracle E-Business Suite?

Today i given one interview on core dba this company is having very large setup they said & they are maintainng

Exadata & Oracle10g AS.

Hi -

Oracle Exadata is a database appliance with support for both OLTP and OLAP workloads. It was initially designed in collaboration between Oracle Corporation and Hewlett Packard where Oracle designed the database, operating system (based on the Oracle Linux distribution), and storage software whereas HP designed the hardware for it

ORacle EBS is for maintaining Oracle Applications like Oracle Finiancials , ORacle HRMS , Oracle manufacturing etc

ORACLE10g AS is an application server mainly for http requests..., now it is been replaced by Fusion middleware - Weblogic Server


Query 4

1. Where apps passwd stores in R12?

Kishore - apps password is not stored in Oracle R12

2. How to clone a application in 11i & R12 if your application contains Custom Top? pls tell the steps.

Kishore - Clone steps remain the same for custom top, for custom top u only do one change


-- create and modify the location in the below file


Thanks & Regard's,


Query 5

1. Dataguard protect your database save how you protect the application can we configure data guard in oracle application to save from disaster recovery?

( Interview Question)

Thanks & Regard's,


Hi Sohail,

for apps tier, every one hour we just sync files from PROD to disaster recovery site, we actually use rsync command, which will only copy the changed values


Hi Kishore,

Thanks for your reply. before runnning this rysnc command how we have to configure data guard in application level?

i know how to configure dataguard in database level.

Pls tell me the steps how to do this. this is an interview question asked me france bank. i need the steps pls.


The below commad is the syntax for rsync, which does a smart copy, the command can be scheduled to run evey one hour

rsync -rltp -v prodappl /x06/oracle/testssc/ &
rsync -rltp -v prodcomn /x06/oracle/testssc/ &
rsync -rltp -v prodora /x06/oracle/testssc/ &


Thanks Kishore. for resync doubt


Query 6

Hi Kishore. Hope you are fine. pls check these doubts in Cmclean.

1. what is the difference between cmclean.sql and EXEC FND_CONC_CLONE.SETUP_CLEAN;
2. where is the location of cmclean.sql script?
3. why after running cmclean we have to give commit;
4. When to run cmclean.sql ?


1. what is the difference between cmclean.sql and EXEC FND_CONC_CLONE.SETUP_CLEAN;

cmclean is normally used when cm doesn't come up, EXEC FND_CONC_CLONE.SETUP_CLEAN will clean fnd_nodes tables after we run autoconfig on db and apps tier which populate the table

2. where is the location of cmclean.sql script?

cmclean is available at Oracle Metalink, attached the same

3. why after running cmclean we have to give commit;

it cleans the concurrent requests which are either lost which are called runaway processes or not completed, once we run this scripts it fixed this issues and we do need to commit to make the changes permanent

4. When to run cmclean.sql ?

when cm is not coming up, sometimes we bring down the database without shutting the concurrent processsion server, all the requests are in middle, the cm not come up, so you need to run cmclean to make this requests closed so that cm can come up


Hi Kishore

You Said..

Cm clean is normally used when cm doesn't come up Ok its fine.

1. But still not understood why to run this EXEC FND_CONC_CLONE.SETUP_CLEAN you said it will clean fnd _nodes tables after we run autoconfig.

what it will clean from fnd _nodes ?

2. After running cm clean we have to run this EXEC FND_CONC_CLONE.SETUP_CLEAN or plstell me the sequence of running this two commands?

3. How we have to run cmclean after downloading from metallink from which node and what is the syntax? & what are the prerequisites. like in your attachment i read we have to

bring down concurrent managers.....

EXEC FND_CONC_CLONE.SETUP_CLEAN is only used for when you clone from PROD to TEST or when database name is changed.

cmclean is used when cm doesn't come up

bring down application, all concurrent managers should be down

now run cmclean.sql connecting as apps user



    Re: Queries from Sohail
    Posted on: 2012-10-05 09:40:27   By: akr14feb
    1. OATM feature is it club all the tablespaces into 14 tablespaces i think?

    pls explain OATM how it reduces the burden on application and how easy for apps dba to manage by comparing to
    old version of tablespaces ?

    Kishore - For apps version 11.5.10 and older, each product had one tablespace, using OATM u can convert tablespaces to fewer tablespaces, in net u should get the information, we did for couple of clients

    2. can i add datafile or resize APPS_TS_TX_DATA ?

    Kishore - Yes, we normally suggest 20% fee space, if it is less then we add datafile

    3. if data is inserting on a datafiles which is connected to APPS_TS_TX_DATA and that datafile table is indexed

    how APPS_TS_TX_IDX will grow my doubt is how rapidly APPS_TS_TX_IDX will grow?

    Kishore - Why you are worried about it, we normally have maintain the database leave other to Oracle to maintain

    5. How to administrator APPS_TS_TX_IDX tablespace like adding or rebuilding indexes?

    Kishore - The same way you do for any tablespace. For adding we use the below command

    alter tablespace APPS_TS_TX_IDX add datafile '/d01/oracle/TEST/db/apps_st/data/a_txn_ind19.dbf' size 200m autoextend on next 200m maxsize 2000m;

Doubts in Forms & Reports - RAJ CHAUDHRY
Posted on: 2012-10-03 18:24:29   By: akr14feb
Hi Kishore

In realtime

1. When we have to compile forms & when we have to compile reports?

2. What will happen when we compile forms ? pls tell what happen internally.

3. What will happen when we compile reports? how this compilation happens internally.



Hi Raj,

1. When we have to compile forms & when we have to compile reports?

Kishore - mostly for custom forms and custom reports, we only compile forms but for reports it is just a copy in binary format

2. What will happen when we compile forms ? pls tell what happen internally.

Below commands are used for compile forms,once compilation is done, fmx (runtime version) is copied to corresponding custom top location which is mentioned as output_file

f60gen userid=apps/apps module=xxtest.fmb output_file=$XXTEST_TOP/forms/US/xxerp.fmx module_type=form

frmcmp_batch module=xxerp.fmb userid=apps/apps compile_all=special batch=yes output_file=$XXTEST_TOP/forms/US/xxerp.fmx

3. What will happen when we compile reports? how this compilation happens internally.

There is no compilation of reports, we directly copy the rdf file


Database refress
Posted on: 2012-11-05 19:36:53   By: Ndivhuwo

Can you please share or post a step by step guide to regfresh only apps database, thus dbtier and not the entire tech stack... no AppsTier.

Thanks in advance

Posted on: 2012-11-08 17:53:19   By: yogeshbhujbal
Hello Sir,

I installed obiee on linux 64 bit. I refer your documents but i want to install & connect to OBIA as well as i wants to install informatica 9.0.1 hotfix 2 with DAC These all are wants to inter connect with apps R12 environment. So can you please help me how to do these things.
Your documents are really very good..
You are doing really great job.

Thanks & best Regards,

Yogesh Bhujbal.

Oracle application 11i ( database upgrade from 9i to 11gr2
Posted on: 2012-12-10 16:00:43   By: kazi_rahil9

I need upgrade my oracle database from 9i( to 11g R2( in oracle application 11i( environment.

I want to migrate this application linux to Solaris

What all pre or post upgrade steps need to perform , specific to oracle application 11i ?

Below is my environment detail

OS:-RHEL 4 update 7
Application: Oracle e-business suite 11i (
Database: Oracle 9i (

Migrate (With upgrade)on

Application: Oracle e-business suite 11i (
Database: Oracle 11g r2

Please give me all The information about Upgrade & migration.

Thanks in Advance,

Rahil Kazi

    Re: Oracle application 11i ( database upgrade from 9i to 11gr2
    Posted on: 2012-12-19 14:06:15   By: akr14feb
    Please follow below note, u need to use expdp and impdp for the migration of database between platforms, here is the note

    Export/import process for R12 using 11gR1 or 11gR2 [ID 741818.1]

    For the complete steps, please follow metalink notes


oracle apps dba
Posted on: 2012-12-18 12:11:42   By: hemantvst76
  Edited By: hemantvst76
On: 2012-12-18 12:12:19
Dear Kishore sir,

I am a post graduate in commerce and 36 yrs old and having experience in bpo for 6 years....

I know it is too late but now I am pursuing oracle apps dba from pansoft Pune (Maharashtra) ...

just want to know does it require any prior experience or knowledge on oracle and also does age factor plays any role in getting a oracle apps dba job?

Kindly reply and remove my confusion

thanking u in anticipation



    Re: oracle apps dba
    Posted on: 2012-12-19 13:49:49   By: akr14feb
    Good to know about you, first you need to be comfortable with Oracle DBA on Linux/Unix platform, Age surely matters but confidence on the subject matters. You may need to tweak your resume accordinlgy, without keeping 3 years of experience it would be difficult to get a job for your age


Save a life
Posted on: 2012-12-21 19:32:45   By: Arijit13
Hi Sir, I am dying to get few answers. Everyone says "KNOWLEDGE SHOULD BE SHARED"....but never happens. I have few questions...can you help me.

Ur patience and co-operation is needed.

My questions
Posted on: 2012-12-21 21:08:55   By: Arijit13
Some of the questions are answered by me. Please checha and if any anything more I need to add please suggest.

1. umask and top command
It is used to define the default permission. When we make a file or directory it has a permission. Eg a directory has 777 permission. Umask is 022. So 777 – 022 is 755.
Top comapnd is used to find the CPU usage.
2. Can I delete Concurrent Manager
to delete a concurrent manager :

You can disable the manager by checking the 'Enabled' checkbox You can simply Terminate the manager and it will not run
again unless you reactivate it. Or, if you really, really want to, you can query the manager in the 'Define Manager' form, and
delete the row. (But DONT do this) .
Note: While checking the enable checkbox make sure the manager is deactivated.

3. i want to know how many users are connected from operating Systems

4. how many users connected to database? Does it mean active users.

5. How to find out the PMON cycle and queee size of Concurrent manager

6. How to find out no of products, active users and concurrent users?

Select count(*) from fnd_products_installations and active users by v$session and concurrent user fnd_user

7. In access log file error 400, 302 and 500? What does it mean? What need to be done?

8. What ate the pre-requisites need to be done before applying a patch?

I need to go through the readme.txt, enable maintaince mode, check invalid counts and also go through the patch wizard becaz it tells the affect of applying the patch, makes a comparisation between patch applied and recommended patches and list out the files in the patch and products with updated files.

Anything else we need to do?

9. I submitted a concurrent request.It was running fine and it takes just 5 minutes to finish..Bt today its taking 1hr bt still its not yet been finished.Then how do you troubleshoot?Plz explain all the possiblities?

10. If mountpoint gets full then how will we know..everytime we dont go to the server and we wont issue df -h.Then how can we know that its getting full

11. )Patch was applied fine in test instance bt when it came to production instance its taking lot of time then how to troubleshoot

12. )On development instance you are applying patch.But you couldnt complete it within maintainence time..then what will you do?will you up the instance without applying the patch or what will you do that time

13. how many concurrent users are currently loggedin to the application and database
from v$license
SESSIONS_MAX NUMBER Maximum number of concurrent user sessions allowed for the instance
SESSIONS_WARNING NUMBER Warning limit for concurrent user sessions for the instance
SESSIONS_CURRENT NUMBER Current number of concurrent user sessions
SESSIONS_HIGHWATER NUMBER Highest number of concurrent user sessions since the instance started
USERS_MAX NUMBER Maximum number of named users allowed for the database

14. What is a snapshot? In which table we get Information?

15. How will check Apache is working in Front-end and Back End
Since Apache is a combination of Jserve and modplsql we can check if the links like httpd:hostname:portno:Jerve: HELLO and httpd:hostname:portno:pls:PROD are working or not or else try to submit a request or anything we can’t do it.
16. What happened Relink adslpice and adpatch?
When the executables are corrupted we do relink operation. It will regerate the executables .
17. What are Oracle Apps DBA Important Tables we use in daily activities

Since we submit requests everyday so the tables would be
Fnd_concurrent_requets, fnd_concurrent_processes, fnd_concurrent_programs and fnd_concurrent_quees.

Any other tables

18. What are the tables updated and created when you apply application patch
Ad_bugs, ad_applied_patches, ad_patch_drivers
Any other tables?
19. Opatch log file location

20. ADPATCH has failed and it indicated there was an error with a worker. What steps can be taken to investigate this problem

See the worker log file rectify the error and restart the worker.

21. Unable to Bring Up Concurrent Manager after Running Autoconfig

22. Can I clone from one operating system version to another?

Yes we can. Eg from solaries lower version to solaries higher version. But not from solaries to windows.
23. What is the difference between Concurrent Requests, Programs, and Processes

24. When you apply C driver patch does it require database to be Up & Why

Yes because it needs to access the D.B to update so many tables,views etc

25. What are invalid objects and Why do I have invalid objects? What causes them? How you identify them

26. Is there a file that lists all of the patches that have been applied to the application

27. What is the difference between apps listener & web listener

Web listener is a component of Apache. Whenever we start the Apache by issuing the command adapcctt.sh it starts the web listener. It is used to receive requests for Apache
However apps listener is a combination of FNDFS and FNDSM. In multi node apps listener is configured in all the nodes. It is started by apachecl.sh or lsnrctl start APPS_$SID

28. Why only for Concurrent Manager, we specify apps/apps password & not for other

29. How do I configure AutoConfig for a multi-node system
30. How do you identify the No. of nodes in Middle tier and db Tier

Is it fnd_nodes

66. What is a Shared APPL_TOP? How do you identify whether it is a shared appl_TOP or not

To know whether the environment is shared APPL_TOP or not , login to first Middle Tier & create any file (like abc.txt) in the APPL_TOP. Now logout & login to other Middle Tier. If you can see that respective file in APPL_TOP, this means you are having shared APPL_TOP.

31. Where are the Application usrs details stored

32. How to find plsql version?

33. Can we start a db in case of shared and unified apple top from middle tier?
Yes for unified appl_top we can but what about shared apple_top

34. Which ORACLE HOME is used by ad utilities

35. Is it possible to revert the patch application? Explain in detail how?
36. How you will recover Online redolog files

37. Can we perform adadmin at db level

38. How to compile a package.
Alter package package_name compile

Need materials
Posted on: 2012-12-23 01:17:28   By: ravikanththeprince
Hi Sir,

I am working as Oracle APPS DBA in a MNC in Hyderabad for the past 5months. I got an idea the kind of work we do regularly but I wanted to learn the subject right from the basics. I am following this site from the day I have joined as APPS DBA. It is the splendid job you are doing here. Please help me by providing the topics for 9i,10g,11gDBA ,11i as well. Hope you will help me on this.

Thanks in advance,

    Re: Need materials
    Posted on: 2013-01-08 14:51:29   By: devika
      Edited By: devika
    On: 2013-01-08 14:52:14
    Hi Kishore,

    I am working as APPS DBA, would like to write the certification exam R12 ""1Z0-238 EBS R12: Install, Patch and Maintain Applications"". Would you mind sugg/send a details materials for preparing this exam.

    Thanks a lot

SQL Query
Posted on: 2013-01-21 16:34:14   By: yogeshbhujbal
Hello Sir,

I am new in EBS Functional Part so i don't have much more knowledge about functional and i required few sql query. Can you please help me for the same. Below is my requirement, please help me sir.

1- List of invoices per PO, Release or receipt
VENDOR_NAME, PO#,PO Date,Release number,Release Date,Release amount,Receipt number,
Receipt date,Receipt amount,INVOICE_NUM,INVOICE_DATE,Invoice received Date,INVOICE_AMOUNT,VOUCH_NO,
Invoice payment status

2- A list of outstanding invoices based on invoice received date
2- B- list of outstanding invoices based on invoices date
VOUCH_NO,invoice description,Current Overdue (1-30),Overdue (31-90),Overdue (>90)

3- number of days taking in paying any invoice

4- Number days taking in validating, posting invoices

VENDOR_NAME,INVOICE_NUM,VOUCH_NO,INVOICE_DATE,INVOICE_RECEIVED_DATE,PO Receipt date,Validate date,Validater Name,Create accounting date,
Poster name,INVOICE_AMOUNT,Number of days for Validating invoice, Number of days for create accounting date
(Invoice receive date to validate date) (validate date to create accounting date payment)

5- List of CCC and CPC transaction
Employee number,Employee name,Credit card #,Transaction Type (CPC or CCC),Expenses type ,IE #,Amount,IE Creation date,Manager approval date,
AP approval date,Create accounting Date

6- Invoices per GL Account number
GL Account Number, VENDOR_NAME, PO#,Receipt number,Receipt date,Receipt amount,INVOICE_NUM,INVOICE_DATE,Invoice received Date,
INVOICE_AMOUNT, VOUCH_NO,Accounting period

7- PO Receipt Details
Supplier Name,PO Receipt Date,PO Number,PO Release number,PO Receipt Number,PO Line number,Description,UOM,Unit Rate,Currency,Net Received Quantity,
Billed Quantity,Uninvoiced Quantity,Uninvoiced amount,Uninvoiced Functional Amount (AED),Invoiced amount,Invoiced Functional Amount (AED),Invoice Number
,AP Voucher number,Charge Account

If you knows the sql query for the same then let me know.

Thanks & Regards,


fuser is not working on Redhat linux
Posted on: 2013-01-25 03:43:02   By: wasiq
  Edited By: wasiq
On: 2013-01-25 03:48:46
Hi Kishore Sir,

When i used the below command on Sun Solaris its working fine,but when i used the same command on Redhat linux its not working.
Note:i have thousands of request files here.
Sun Solaris
$ find . -name "*.req" -mtime +0 -size +10000000c -exec fuser {} \;

Same command on Redhat linux.
Operating system Version details
cat redhat-release
Red Hat Enterprise Linux Server release 5.7 (Tikanga)
$ find . -name "*.req" -mtime +0 -size +10000000c -exec fuser {} \;
find: fuser: No such file or directory
find: fuser: No such file or directory
find: fuser: No such file or directory
find: fuser: No such file or directory
find: fuser: No such file or directory

Could you please help me here and what is the appropiate command on Red hat linux.

Best Regards

How to trouble shoot long running concurrent request!
Posted on: 2013-01-25 04:11:00   By: wasiq
  Edited By: wasiq
On: 2013-01-25 04:13:33
Hi Kishore Sir,

Could you please help me how can i troubleshoot a long running concurrent request and what are the parameters need to be check.

Best Regards

Posted on: 2013-01-25 22:33:03   By: naveenlazar
Dear Kishore Sir ..this is naveen lazar.i am a M.Tech candidate.Currently doing my Ph.D.Due to some reasons i am planning to do SW job.I want to do DBA APPs.Sir just tell me how would be the course and opportunities ....

    Re: Suggestion
    Posted on: 2013-02-07 17:17:43   By: akr14feb

    It is good move to come to database world, requires dedication but surely you can win. Start with Oracle DBA on Linux/Unix,then move to Oracle Apps DBA.

    I can always give tips from side.


      Posted on: 2013-02-26 23:44:52   By: pratap
        Edited By: pratap
      On: 2013-02-26 23:53:59
      hello sir,i have done sql,pl/sql now am in dilema to choose which course will helpfull for me oracle apps technical or oracle apps dba.please suggest us o better career.i dont have any real time knowledge.

form blinking
Posted on: 2013-03-07 18:52:23   By: mounith

This is vandana..my issue was when users open the forms,the forms are blinking..all users face the same problem..Howcan i troubleshoot it?

Please tell methe solution...

Need guidance
Posted on: 2013-03-12 17:13:07   By: mail2urmila
Dear All,
I am new user. I did B.E in computer in 2006 but still I am not able to settle in my career. Though I have exp of 4 years but that is in different different field. And most of the IT companies reuired exp in perticular field. I think I am good at oracle apps dba.
Some of my friends suggested me to put fake exp and go ahead.
I am in confusion what to do. is there any alternate way so that i do not need to put exp and I can join as Apps DBA.

Eagarly waiting for reply.

    Re: Need guidance
    Posted on: 2013-03-12 22:12:44   By: akr14feb
    Good Decision, but before becoming Apps DBA, you need get comfort level on Oracle DBA on Linux or Unix platform, then Apps DBA would be fine.

    All the Best


Need your suggestion
Posted on: 2013-03-15 23:24:12   By: venkateswari
Hi Kishore,
It was great to know you through this site and various forums. I have 7 years of development and maintenance experience in Mainframe batch technology (DB2,COBOL,JCL,VSAM). Currently there is not much market for Mainframes. I initially thought to go with DB2 DBA as it would be similar to my work expertise but then considering future requirement in mind, I thought it would be better to with Oracle DBA or SAP. SAP needs good domain knowledge as well. I see future good for both these areas. But considering my technical knowledge, I am in a mindset to go with Oracle only. People are saying that SAP will overtake oracle also but I don't see it likely happening in near future.
I have good DB2 SQL knowledge. Need your suggestion on how to go about and what to learn in Oracle which has lot of current and future demand.

Thanks in advance,

    Re: Need your suggestion
    Posted on: 2013-03-19 12:16:37   By: akr14feb
      Edited By: akr14feb
    On: 2013-03-23 16:28:07

    Welcome to World of Oracle.

    Well if you are in SAP or Oracle then you are safe, both will be leaders now and in future, for SAP no need to have functional knowledge, basis administration is equivalent to Oracle Apps DBA.

    Well when it comes to Oracle, you can start with Oracle DBA on Linux and Unix, once you gained confidence u can go with Oracle RAC or Oracle Apps DBA.

    Have a test system, and using Oracle VM u can have a instance for practise purposes. some of the good sites like http://www.oraclebase.com and http://idevelopment.info have ample information for Oracle DBA. Do certifcation on Oracle.

    Revert for further queries.

    All the Best !!!


Oracle Apps R12
Posted on: 2013-03-23 10:52:02   By: Shekhar
Hi sir,your suggestions are very helpful to me,can please send me procedure for Apps r12 cloning ,patching,database refresh steps in linux environmen..thanks in advance

    Re: Oracle Apps R12
    Posted on: 2013-03-23 16:28:42   By: akr14feb
      Edited By: akr14feb
    On: 2013-03-28 17:01:52
    Hi Shekar,

    All the mentioned topics are available in my site.


      Apps DBA from Apps Dev
      Posted on: 2013-04-08 02:26:18   By: Prasad
      Hi Kishore
      Can you guide me.. I'm into Apps world from past 10+years.currently working as Techno-Functional consultant. and planning to switch my career into Apps DBA side. Please guide me...I don't know wether it is right time for me to move on to Apps DBA..or stay whatever I am doing and upgrade my skills towards Fusion Apps tech stack like SOA,Fusion MW, ADF..etc . Onething is..If I start as Apps DBA.. my counter starts from '0'yr exp
      Please guide me.


unable to open form
Posted on: 2013-04-25 22:37:01   By: zubair12
  Edited By: zubair12
On: 2013-04-29 10:42:37
hi kishore
i would like to ask u if am unable to open the forms in front end what should i check in backend please reply soon

    Re: unable to open form
    Posted on: 2013-05-16 11:26:07   By: zubair12
    i am not geting any feedback frm ur side when i post a query

Apps DBaa Project
Posted on: 2013-04-29 11:47:35   By: altaf_bacs
  Edited By: altaf_bacs
On: 2013-04-29 11:48:03
Hi Kishore,

its been wonderful reading this blog & to share the knowledge. I would like to know if there is any project on appsdba we can do, as we do not have any realtime exp, so that this project can help us indepth.



    Re: Apps DBaa Project
    Posted on: 2013-05-03 13:57:38   By: akr14feb

    Couple of activities u can take up, right from Installation, patching, cloning and also the upgrade from R11 to R12 are some of tasks a Apps DBA does. Practice in your desktop or laptop

    mail me for further queries.


    Re: Apps DBaa Project
    Posted on: 2013-05-20 11:31:24   By: altaf_bacs

    thank you Kishore for your reply. I want 2 knw is there any institute that can provide me with Apps R12 a project. Since, cloning & patching would be difficult at home. AS i already undergone training, if any institute can provide project facility by taking minimal fee, since they dont have to train me & work around me unlike a new trainee.

    Re: Apps DBaa Project
    Posted on: 2013-05-20 14:22:09   By: altaf_bacs
    HI Kishore, Thk you for the response.

    I tried to practise at home, since i dont have patches im unable to do patching & upgradations from 11i to R12 .. other AD activities im performing. However, if i get a chance to do a project i can work on patching & upgradations as i dont have patches & for upgradation too. Do you know any institute where they provide projects by taking minimal fee or only lab facility ..



No Subject
Posted on: 2013-05-03 14:29:36   By: vemuri

HRMS implemenation
Posted on: 2013-05-03 15:07:56   By: vemuri
Hi Kishore,

We are implementing HRMS(core HR, SSHR and Payroll).
But recently upgraded the Oracle Apps from 11i to R12.1.3.

Present instance Details are below:

Application Version: R12.1.3

Database version: Oracle Database 11g Enterprise Edition Release - 64bit Production

Architecture: Two node (1 Apps Server, 1 DB server)

The two servers has the fiollowing capacity:

Memory: 40GB
Physical Processes =2, with six core each with Hyper threading enabled makes total processors=24.

Type of machine: HP ProLiant DL 380 G7

Operating Syatem: Redhat Enterprise 5.8 x86_64bit; "Red Hat Enterprise Linux Server(2.6.18-308.el5)".
Current users: 290

Current Modules: AP,GL,FA,INV and PO

Now we are implementing the below modules:
New users: 1300
New Modules: Core HR, SSHR and Payroll

Now I want know what are the pre-requites we need to take care before Go live specifically about Server capacity.

What is RAM size suggested? the present one is OK for 1600 users OR we need add the RAM and Hardware Capacity..?

What are the Parameters we need to change the at DB level and Application level for better performance.

Please suggest me.

Posted on: 2013-05-15 13:31:24   By: albertdsouza1950
  Edited By: albertdsouza1950
On: 2013-05-15 13:36:15


My daughter works in EBS R12 as trainee for patching.

she is working for 6 months,is it the right career path considering the future of EBS, or should move as developer.

The other option to look at is the content side of ebs instead of patching.

Could you provide us your thoughts on this.


Training please
Posted on: 2013-06-13 01:26:34   By: yendluri11
  Edited By: yendluri11
On: 2013-06-13 03:33:41
I want to learn Oracle apps dba. please let me know if any one giving training.


Error message: ORA-48913: Write to trace failed
Posted on: 2013-06-26 17:28:44   By: shashi

Im New to appsdba field.i need some help
got an alert saying: Error message: ORA-48913: Write to trace failed. The size limit of the file ([41943040]) is reached.
i checked max_dump_file_size which is 81920. im little confuse here,my trace file should not go beyond 81920 but in this case it is more than that. can you help me understand the relation between these two.

Thanks in advance.

How to configure Oracle HTTP Server to listen from client request by hostname
Posted on: 2013-07-18 14:05:30   By: gulamdyer
  Edited By: gulamdyer
On: 2013-07-18 14:07:52
Hi Kishore,

I have deployed Forms 11gR2 based a small application on Oracle Fusion Middleware 11.1.2 Application server.

My server has 3 LAN card, out-off 3, 2 LAN cards are enabled with IP address and also we have two domain server, one for local users and another is for remote users.

Local domain users can access application using URL but remote users can not access application using hostname:9001/forms/frmservlet or

If you can guide me to configure Oracle HTTP Server I will be grateful.

Gulam Dyer

i need trainee
Posted on: 2013-07-22 16:47:40   By: srikanth63
  Edited By: srikanth63
On: 2013-07-22 16:56:11
hi sir,
this is srikanth i done apps dba course and i got job in a small company. The problem is i'm the only dba to our company bt we have onsite dba. i'm feeling fear to do anything on production database, i just need a support to do some tasks . can any one teach me the real time scenarios. anyone in hyderabad mail to randisrikanth@gmail.com thank you..
i can pay for each concept such as cloning, upgrading....

    Re: i need trainee
    Posted on: 2013-07-30 10:15:04   By: akr14feb

    Shoot a mail at akr14feb@gmail.com


Best Documents
Posted on: 2013-08-21 10:38:04   By: rajeshthalapaneni

These are the best documents which i ever found and very understandable. Thanks..

sap mmc error
Posted on: 2013-09-29 20:02:15   By: shankar225
  Edited By: shankar225
On: 2013-09-29 20:11:28
change of text

Hi Kishore Sir,
This is shankar..I have installed server 2k3 in virtual box and installed sap 4.7 for home purpose, upto 3 weeks it went on well. But suddenly when am starting the server within 3 minutes the workprocess are changing from green to yellow and finally today i am not able to see the tree structure below the sap R management. I have checked in administrative tools > services there i cant see sap system ID.
Can you please help me on this asap.

I followed the steps which you have guided but coming to central instance installation after performing a certain installations the system is showing error near the database server nodes even if i tried retry also there is of no use..Requesting to help me on this..

Thanks in advance,

    Re: sap mmc error
    Posted on: 2013-10-07 07:00:55   By: akr14feb
    Hmmm, I am totally away from SAP, now totally in Oracle Apps, one of best solution when using Oracle VM or VMWare is to take snapshots, so that we can revert back


upgrade from R12 version 12.1.1 to 12.2
Posted on: 2013-10-17 11:20:16   By: praveen131
Hello sir,
i am a fresher and i working as apps dba. i reviewed all you document . you done a good job . its very useful for us.

my manager ask me to do version upgrade from R12 version 12.1.1 to 12.2. .

i tried to upgrade but it throwing the error as " Exception in thread "main" java.lang.UnsatisfiedLinkError: /tmp/stage/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0/lib/i386/xawt/libmawt.so: libXext.so.6: cannot open shared object file: No such file or directory "

pls give me the solution .

From non rac Oracle Apps R12 (12.1.1) to RAC Oracle Apps R12 (12.1.1)
Posted on: 2013-10-22 16:12:37   By: Swathi
  Edited By: Swathi
On: 2013-10-22 16:16:53
Hi Kishore sir,

In our organization we are using Oracle Apps R12(12.1.1)(non-rac) instance and our management wants to implement RAC. They are planning to migrate our database from non-rac to rac instance in EBS. Could you suggest any steps or documents for this process.


    Re: From non rac Oracle Apps R12 (12.1.1) to RAC Oracle Apps R12 (12.1.1)
    Posted on: 2013-10-28 21:12:10   By: akr14feb
    I have send the information to your email


Need Information
Posted on: 2013-10-30 23:44:24   By: teja5c1
Hi Kishore garu,

I am teja I completed B.Tech CSE in 2011,I completed linux,oracle courses,
I am planning my to start my career as Oracle Apps DBA consultant.AND I am planning to settle in USA.I heard that Oracle apps DBA is hot in USA market,So please suggest me to step by step process to schieve my goal.

I heard that linu/unix admin knowledge is required for Oracle DBA ..,really is it mandatory ?? or what else courses i want to do Oracle DBA or Oracle Apps DBA ...

Please help me with ur valuable suggestions...

Need your Help to build mu Career
Posted on: 2013-10-30 23:50:35   By: teja5c1
Hi kishore garu,
I am teja Pursued B.Tech(CSE) in 2011,and completed courses oracle,unix,unix shellscripting.I am planning to settle in USA
after doing job in India after few years.I heard that Oracle Apps DBA is hot in USA market.I am planning my career to become as Oracle Apps Consultant.
So please tell what are courses i need to do to become cracle apps dba consultant.I heard that unix/linux admin is req to learn oracle DBA.Is this is true??
I need more details regarding this..

Please help me giving your valuable suggestions

thank you sir

    Installation error 12.1.1
    Posted on: 2013-12-19 00:49:48   By: raviincontact
    Hi...kishore this is ravi working as an oracle appsdba i got an error rw-500015 jsp login and http is not responding end of installation i have used OEL 4.8 linux version i saw many solutions online like a) stop services and start apps services and runautoconfig and creation of softlink from the location /usr/lib/libgdb.so.2.000 /usr/lib/libdb.so.2 but they couldnt resolve my problem can u provide the solution for this problem

Posted on: 2013-11-07 15:39:50   By: VMK
  Edited By: VMK
On: 2013-11-07 15:41:25

Kishore garu,

How are you?
I am new to the oracle apps and i am working on OTM Platform. I googled for OTM Installation doc, and i navigated to Your site and i downloaded the Installation guide. I need to follow those steps. Thanks for the detailed steps that you made.

I once again thanking you for this useful site. to 12.2.0 Upgrade document
Posted on: 2013-11-26 17:25:50   By: khasim
  Edited By: khasim
On: 2013-11-26 17:28:07
correcting mistakes

Hi Kishore,

This is khasim working as an oracle apps dba,can you please provide the docs related to to 12.2.0 upgrade.If not please suggest me how to upgrade from OEL-4u5( to OEL 5u7(12.2.0).

Thanks in advance,

View Output or Log file error
Posted on: 2014-01-09 14:17:24   By: subratkumar123
Hi All,

I am facing one problem, Whenever I run any report, it runs successfully and shows me Phase completed and Status Normal. But When I want to view the Output or View Log file then it gives me the following error message.(Note: I am using Oracle Apps under windows XP Professional)
An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_HASHIM. There may be a network configuration problem, or the TNS listener on node FNDFS_HASHIM may not be running. Please contact your system administrator.

Please help me to resolve the issue.


Oracle DBA to Oracle APPS DBA
Posted on: 2014-01-10 11:18:13   By: csethi

It was nice to see your experience. Can you please guide me the path to become a Oracle Apps DBA.

I am Oracle Core DBA from last 5 years but Now would like to move into Oracle Apps. Please also help me with its scope. One more thing does Oracle EBS, SOA all comes under Oracle Apps or its different..?

R12.2 installation questions
Posted on: 2014-01-21 21:15:09   By: vduggaraju
Hello, I am installating R12.2 VIS with one DB node Solaris and Apps Tier with Linux (OVM). first install went fine and second install , installation was fine but the weblogic managed services are coming up.

Only one application instance are starting. if you have some ideas , please let me know.

Venkat D

Re: Excellent Idea
Posted on: 2014-02-04 14:54:51   By: sravanth789
  Edited By: dxo1207
On: 2014-02-11 07:36:51
Hi Kishor,

I am new to your website but it seems to be the best till date i have seen, Its like Google for Apps DBA's.
you have made life of Apps DBS's easy , kindly keep updating with latest R12.2.0 docs also.
thanks a lot again.

Syed Imran

R12 Upgrade Document
Posted on: 2014-02-20 02:20:38   By: imran_chaus
i need application upgradation document for 11i to R12

but my database existing version is 11g (

so plz help me

Oracle Apps upgrade from R12.1.3 TO r12.2
Posted on: 2014-07-31 17:45:35   By: abhirao126
Hi Kishore,

Your blog is very helpful for Oracle Apps dba's with good documentation covering all concepts.Could you please share any documents related to R12.1 to R12.2 upgrade.
Appreciate your help and thanks in advance.


Need Info
Posted on: 2015-05-17 17:03:36   By: sandeepkandhway
Hi Kishore,

I'm following your site from a quite long time, and I'm really impressed with the stuff you have shared. Thanks for all these.
Just to update, I have further more queries. I want to do a Oracle 11gR2 2 node-RAC setup on my personal Laptop, over VM Ware, to practice stuffs.
However, I'm not sure whether installing 11i/r12 will work or not. Can you please help on this.


hello sir,
Posted on: 2015-05-22 12:52:49   By: satyakumar
i am completed core dba . i have average knowledge. i will learn apps dba, and go to interviews for 3 years experience. give me solutions...

restrict single session per user in R12
Posted on: 2015-05-30 12:15:53   By: Murugan_t
Hi Kishor,

Good to see many things on your site and very useful to the people who visit your site/blog.

Regarding the subject "Step By Step Instructions to restrict single session per user in 11i and R12". It seems as the existing active user becomes inactive when same user logs in again. Is it possible to restrict same user logging in again if the same user is active.

pls guide me to become a better DBA
Posted on: 2015-07-28 12:58:13   By: surur777
hi expertzz

Am a b tech professional and also took certification in oracle dba 10g . Now i start my career in a small company as junior dba but their is not much more trainning facuilty so pls guide the area where we look much important as junior dba .pls mention the position or type of area to take much important to perform future and also the additional knoweldge we need to become a better dba

thanks in advance

Posted on: 2015-07-28 14:01:11   By: shanmukhApps
hai sir.............

I am fresher in apps dba so some fundemental steps are give me.


thanks to advance.......

    Re: fresher
    Posted on: 2015-08-04 11:46:25   By: rajashekar
    sir plz provide the hot cloning in apps please provide it

EBS R12 (12.1) installation failed
Posted on: 2015-08-19 10:54:09   By: shanmukhApps
EBS R12 (12.1) installation failed at Post Install Checks on Linux : libdb.so.2

installation of fusion middleware
Posted on: 2015-08-27 18:33:15   By: sujith
i have been installing fusion middleware application in linux server, i am getting the following errors which i even cant found in google. Can you please help me out to solve this errors.
Thanking you in anticipation


Oracle Forms Upgrade
Posted on: 2015-09-26 12:59:24   By: jayganesh

I am new to this forum.

We currently use Oracle Forms & Reports (version 6i). We are planning to upgrade from 6i to 10g.

Can anyone give me some information on what is involved in upgrading Oracle Forms & Reports 6i to 10g version.

The database we use is Oracle 10g.

Can someone clarify the below points.

1. I know Oracle forms 10g is a 3 tier architecture and needs a middle tier where we need to install a application server (OAS). What is the middle tier server that should be installed for deploying Oracle 10g forms and reports. Is it weblogic server or just Oracle Application Server (OAS).

2. What are the minimum hardware requirements for a middle tier server?

Can someone give me some information on the above points or can you guide me like where i can find this information which will be helpful for me to do a Proof of Concept.


    Re: Oracle Forms Upgrade
    Posted on: 2015-10-19 12:32:45   By: farookh123

    We migrated multiple Forms/Report 6i applications to 10g and 11g.

    I would suggest to go with OFM 11g(Forms and Reports) as Oracle 10g is already de-supported version.

    You requires multiple changes in your application in order to run in 3-tier .. e.g

    - Code changes – you can’t stat forward compile forms in 11g as there will some changes are required in code as few 6i functionality is not available in 11g
    - Client Work station Changes – you need to have Jre version installed in client workstation to access oracle forms 11g via browser
    - Server Side changes – you have to install below software’s on application server to deploy forms/reports application
    WebLogic 11g(10.3.6) + Forms/Reports

    Feel free to contact me for further information on farookh123@gmail.com


regarding course
Posted on: 2016-01-08 14:36:09   By: manoj
hai sir this is manoj iam new to apps hw can i mve further in this course. presently iam not working in anycompany but ihave a knowledge on oracledba so can u pls give me a guidence on it hw ican mve ..........yourts faithfully manoj

excellent lib ihave never seen ....
Posted on: 2016-01-08 14:41:26   By: manoj
sir iam very thankfull to say that ur postings on dba and apps are wonderfull it is mre helpfull who r new and fresher to this platform ...........ithink so its gods gift to us like such a person like u presented to us for learning good knowledge ...........................manoj....

    Re: excellent lib ihave never seen ....
    Posted on: 2016-03-09 19:23:38   By: akr14feb
    Thanks Manoj,

    Appreciate your comments, you can join our group by sending a mail to appsdba@appsdba.info


interest to learn oracle apps dba
Posted on: 2016-04-11 19:20:10   By: skkallahbakash
dear all&admin

this is allahbakash i want to learn oracle apps dba..
i dont have any idea about this course ..could any body help me out to complete this course .....i am fresher...

what are the courses need to be learn first...?
which platform we will use unix/linux for oracle apps dba?

pls provide some usefull information to complete the course...from basics....information.
thank you in advance to all............
skkallahbakash@gmail.com if you want send any document pls send to mail id...

    Re: interest to learn oracle apps dba
    Posted on: 2016-04-25 12:40:01   By: fairozappsk
    Before you learn Apps Dba you first learn the Core Dba and Rac, asm then you can move to oracle apps dba now we are using 12cdatabase and r12. 2.5 unix redhat6 we are using

Click the below link
My Exposure to Apps

ISCON, MaryLand
Great Falls - Virginia
SRA - Virginia
Horse Racing, Delaware State
Pennsylvania Snaps
Washington DC - Snaps
San Francisco - Livermore Temple Snaps
San Francisco - Golden Gate and WaterWorld
Boston Snaps
Sea World, San Deigo
Disneyland, Los Angeles
Hollywood, Los Angeles
It's A Small World Disneyland

Kishore A SanFrancisco, CA
Volkswagen EOS - Completely convertible Sports Car Snaps

Senthil Site
Manthri Srikanth Site
Live problems/solutions by Vikram Das
Atul - Apps DBA
Famy Rasheed
Apps DBA - Dave
blogs oracle com
Cciontu Site
Madan Mohan Site
Satyesh Site
Scripts - Apps DBA
Advait - Apps DBA
Ramesh Mani - Apps DBA
Ramnik Gupta - R12 Apps DBA
Suresh Lakshmanan - R12 Apps DBA
Fadi Hasweh
Apps DBA
Tips n Scripts
Apps solutions
Apps DBA
Steven chan
Tip & scripts
Oracle Apps DBA
Troubleshoot - Oracle Apps DBA
Oracle Apps DBA
Oracle Apps DBA
Apps DBA
Apps DBA - Q & A

Linux Tutorial
Unix Question And Answers
Send Mail
Command Reference
Day to Day linux commands

Ask Tom
Jeff - Best DBA Site
Arju - DBA Site
Jaffer - DBA Site
DBA Site
Oracle utilities
Oracle DBA tips
Oracle Coach
Oracle DBA Scripts
Oracle OCP topics
Oracle DBA - 20 weeks
Oracle DBA Free Course
Oracle DBA
Oracle DBA
Oracle by example
Oracle Demos
Oracle DBA Workshop
Oracle DBA

Best Forum for Oracle Technologies

Anil u'r the Best
Apps Tech
Apps Tech
Apps Tech

RAC - Oracle DBA
RAC - Oracle DBA
Oracle DBA - problems/solutions
Oracle RAC
Oracle RAC
Oracle RAC
Oracle RAC
Oracle RAC
Oracle RAC
Oracle RAC
Oracle RAC
Oracle RAC
Oracle RAC
Oracle RAC
Good Site for RAC troubleshooting

Daily dba

South Korea, Dubai Snaps