>  Operating System
>  VMWARE
>  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

Home

Username

Password

Remember Me



Installation Guide for PeopleSoft 8.4

Installation
User Maintenance

>  Application Integration Architecture
>  OBIA

Installation
RMAN - Backup & Recovery
Replication
Convert DB Character Set
DATAPUMP
Recoveries
Oracle 11g Topics

   Installation

No menu items for this menu.



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.


A.Kishore

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
 
Kishore,

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

Regards,
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.

    Regards
    Kishore


      Re: Excellent Idea
      Posted on: 2012-01-09 12:29:20   By: joshipodili
        Edited By: joshipodili
      On: 2012-01-09 12:29:43
      hi
      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

      REgards
      y



        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 :)

        A.Kishore




    Re
    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..


    UPGRADE DOCUMETTATION HELP
    Posted on: 2011-02-01 00:47:16   By: bhojsree2
     
    HI KIshore,
    Am new to DB and APPS can you please help me am now in a project to upgrade 10GR2 RAC+ASM WITH 11i APPLICATIONS. i NEED TO UPGRADE IT TO 11GR2 RAC+ASM WITH 11i APPLICATIONS ON OEL5 OPERATING SYSTEM.CAN YOU PLEASE HELP ME WITH THE UPGRADE DOCUMENTATION.


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

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


    --Raj
    srdba1@yahoo.com


    upgrade from 11.5.9 to 11.5.10.2
    Posted on: 2011-11-04 21:59:59   By: zavi
     
    Hi,
    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 11.5.10.2
    thanx
    zavi
    zavi07@gmail.com


    Re: Excellent Idea
    Posted on: 2011-12-01 15:19:12   By: debabrata
      Edited By: akr14feb
    On: 2012-01-22 23:14:33
    Hello,
    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 .

    Regards
    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

      Kishore


    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.

    thanks
    Shiva



    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


    Upgrade_R11.5.10.2_R12.1.1.pdf
    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 11.5.10.2 with Database 12.1.1

    Regards,
    Chandrasekar s
    Tamilan


    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 :)

Cheers,
Rathinaganesh
arganesh4@yahoo.com


    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.

    Regards
    Kishore


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

    Regards
    Kishore


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

Thanks&Regards
Subramanian
CitiGroup,TampinesJunction,Singapore.




    Re:
    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.

    Thanks.

    Regards,
    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

Regards,
Ramesh


    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.

    Regards
    Kishore


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

      Can you please send me the document for upgradation for 11.5.10.2 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
         
        http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=48&MMN_position=36:36


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!

Chawla


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).

Regards,
Nabil



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

bye
Ashok



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,
Nabil


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,
Iqbal…



    Re:
    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
    Thanks
    Guru

    smvguru@yahoo.com


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

Thanks


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,
http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=13

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

Cheers..
Hitesh Mishra


    Re:
    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.

    Regards
    Kishore


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
     
    Hi,

    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.

    Regards
    Kishore


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
    Well,
    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.

    http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=33&MMN_position=28:28

    Please do revert for more queries.

    Regards
    Kishore



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
Salim



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

    Thanks
    Gurunathan


      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 11.1.0.7 to 11.2.0 kindly provide me the document.

      Regards
      Thanks for your Support
      Farhan



        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

          http://www.appsdba.info/docs/oracle_apps/RAC/Install_11gR2_software_upgrade_to_11gR2.pdf
          http://www.appsdba.info/docs/oracle_apps/upgrades/upgrade_r12.1.1_r12.1.3.pdf


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
Raj


    Re:
    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.


    Regards
    A.Kishore


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.

Thanks.


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

    Thanks
    Kishore


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.

    Regards
    Kishore


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

thanks
Sreeram


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

    http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=48&MMN_position=36:36


Hi
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
simmisahay@gmail.com



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

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

    Revert for further queries.

    Regards
    A.Kishore



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
 

Hi,
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

    Regards
    Kishore


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

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
 
hi,
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
     
    Hi,

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

    Thanks
    Kishore


      Re: oracle application
      Posted on: 2010-11-08 10:14:00   By: raghavendrachari
       
      thanks,
      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.
        Kishore


      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
      Regard,
      Syed



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
wishing

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
Arief


    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


    Regards
    Kishore


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?

regards,
Raghavendrachari


    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

    Regards
    Kishore


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

    http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=18&MMN_position=8:8


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
 
HI,

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

need ur help regarding it.

Regards
Krunal


    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,
Satya


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

    Regards
    Kishore


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:

HTTP
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.

JSP
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.

        Kishore


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
Raghu


    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

    Regards
    Kishore


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.
Thanks&regards
ANAND




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

    http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=60&MMN_position=56:56


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.

Nikhil
bnikhil08@gmail.com
+91-9949521842


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.

OS:RHL4.0
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


StackTrace:
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

Regards,
Narasimharao


    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!

spavlovsky.




Upgrading EBS 11i to R12.1.1
Posted on: 2012-01-08 19:18:33   By: sameer_dba
 
Hello
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
database:9.2.0.6.0
application: 11.5.10.2

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

    http://appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=48&MMN_position=36:36


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 executed FND_CONC_CLONE.SETUP_CLEAN;
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 11.5.10.2




Oracle Identity Mangement
Posted on: 2012-01-17 11:56:13   By: Farhan
 
Hello,
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.

Regards
Ibrahim
India


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

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


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

    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,
    Ali


apply maintenance patch to 11.5.10.2
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 11.5.10.2 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 11.5.9.2 to upgrade to 11.5.10.2 please provide the solution for same
any help...
thanks


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

    Regards
    Kishroe


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

Your reply will be highly appreciated..

Regards
Farhan


    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
 
sir,
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
     
    Hi,
    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

      http://appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=47&MMN_position=35:35


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

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

    Thanks
    Kishore


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.

Regards,
Sri


    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.

    Regards
    Kishore


i need your help plz guide me:
Posted on: 2012-03-11 15:48:51   By: namrata
 
sir,
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
     
    Hi,

    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

    Regards
    A.Kishore



Hi
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.

thanks
Shiva


    Re:
    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
     
    Hi,

    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.


regards,
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

    A.Kishore


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

    c:\windows\system32\drivers\etc

    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.

Thanks,
mallikarjunreddy9985@gmail.com


    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

    Regards
    Kishore


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

      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.

      Regards,
      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

        Regards
        Kishore


        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.



Apache
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

Regards,
OraDbase








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.

Regards,
Ashok


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

    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.

    Thanks&Regards
    Murthy
    9959226779


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?


Danesh,

Here are my responses


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

Kishore - if you are upgrading from 11.5.9 or 11.5.10.2 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 11.5.10.2


2. Why ADI patch is required?

Kishore - See these threads/docs.

version of ADI release?
http://forums.oracle.com/forums/thread.jspa?messageID=4234809

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

Thanks,
Hussein


3. Why ATG patches required?

Kishore - If you want 11.5.10.2 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 11.5.10.2 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.
Sohail


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


http://onlineappsdba.blogspot.in/2008/05/count-total-number-of-users-connected.html

Thanks
Kishore


Thank u kishore

Sohail


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.

Regard's.

Kishore

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.

Thanks
Kishore


Thank u somuch
Sohail


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

Thanks
Kishore



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

cd $APPL_TOP

-- create and modify the location in the below file

customDEV_racerp.env


Thanks & Regard's,

Sohail.


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,

Sohail.

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

Kishore

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.

Hi,

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/ &

Regards
Kishore

Thanks Kishore. for resync doubt

Sohail


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 ?
5. when to run EXEC FND_CONC_CLONE.SETUP_CLEAN ?

Regard's,
Sohail.



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


Sohail

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


Sohail

NOW ITS CLEAR




    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.

Regards,

Raj.

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


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

R12
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

Kishore


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

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


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

I installed obiee 11.1.1.5 on linux 64 bit. I refer your documents but i want to install & connect to OBIA 7.9.6.3 as well as i wants to install informatica 9.0.1 hotfix 2 with DAC 10.1.3.4.1. 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 (11.5.10.2) database upgrade from 9i to 11gr2
Posted on: 2012-12-10 16:00:43   By: kazi_rahil9
 
Hi,

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

then
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
NOW

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

Migrate (With upgrade)on

OS:-Solaris
Application: Oracle e-business suite 11i (11.5.10.2)
Database: Oracle 11g r2

Please give me all The information about Upgrade & migration.

Thanks in Advance,

Rahil Kazi
kazi.rahil9@gmail.com


    Re: Oracle application 11i (11.5.10.2) 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

    Thanks
    Kishore


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

regards...

hemant



    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

    Thanks
    Kishore


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
select SESSIONS_MAX,
SESSIONS_WARNING,
SESSIONS_CURRENT,
SESSIONS_HIGHWATER,
USERS_MAX
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?
http://appstier.blogspot.in/search/label/Concurrent
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,
Ravikanth


    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
    Devika


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
column-
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
column-
Invoice type,VENDOR_NAME,INVOICE_DATE,INVOICE_RECEIVED_DATE,INVOICE_NUM,INVOICE_CURRENCY_CODE,INVOICE_AMOUNT
VOUCH_NO,invoice description,Current Overdue (1-30),Overdue (31-90),Overdue (>90)

3- number of days taking in paying any invoice
column
VENDOR_NAME,INVOICE_NUM,VOUCH_NO,INVOICE_DATE,INVOICE_RECEIVED_DATE,Invoice Date,INVOICE_CREATION_DATE,Payment terms,
GL_DATE CHECK_DATE,CHECK_NUMBER,INVOICE_CURRENCY_CODE,INVOICE_AMOUNT,Number of days for processing payment

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,

Yogesh.


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 {} \;
./l69377073.req:
./l69624470.req:
./l69437151.req:

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
Wasiq


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
wasiq


Suggestion
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
     
    Hi,

    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.

    Regards
    A.Kishore




      Suggestion
      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
 
Hai,

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

    Regards
    Kishore


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,
Venkateswari


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

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


    Regards
    Kishore



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.

    Thanks
    Kishore


      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.

      Thx
      Prasad


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.


Regards,

Altaf


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

    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.

    Cheers
    A.Kishore


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

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

    Regards,

    Altaf


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 11.2.0.2.0 - 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.




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

Hi

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.

Regards
Albert


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

Thanks,
naren


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

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 111.1.0.98 and 192.168.0.98 also we have two domain server, one for local users and another is for remote users.

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

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

Regards
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
     
    Hi,

    Shoot a mail at akr14feb@gmail.com

    Thanks


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

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,
Shankar


    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

    Kishore


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.

Thanks


    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

    Thanks
    Kishore


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


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

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.


11.5.10.0 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 11.5.10.0 to 12.2.0 upgrade.If not please suggest me how to upgrade from OEL-4u5(11.5.10.0) to OEL 5u7(12.2.0).

Thanks in advance,
Khasim


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.

Thanks



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

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.

Thanks
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.

Regards
Syed Imran




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

but my database existing version is 11g (11.1.0.6)

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.

Abhi





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
Sarfaraz
Apps
Apps
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
Troubleshooting
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
Tracing
Oracle DBA tips
Oracle Coach
Oracle DBA/RAC/MySQL
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
Craig
Craig


South Korea, Dubai Snaps