Friday, November 16, 2012

Test 2

Please register.

Posted by: akr14feb on 01/13/2009 04:25 AM
Guys,

Please do create a new account using "New Account Signup " to get latest updates and to access Oracle Forums, if it not working please send a mail to akr14feb@gmail.com

Thanks
A.Kishore

Volkswagen EOS - Video

Convertible Car

Today's Quote

I am not afraid of the one who know 1000 steps,but i am afraid of the one who practices a single step 10000 times

-Bruce Lee

"Take up one idea. Make that one idea your life - think of it, dream of it, live on that idea. Let the brain, muscles, nerves, every part of your body, be full of that idea, and just leave every other idea alone. This is the way to success, that is the way great spiritual giants are produced."

- Swami Vivekananda

Focus on one task at a time

In reality, you can only focus and place effort on one task at a time. It is better to have one task fully completed than have several uncompleted tasks. When you focus on several things at the same time, you simply don’t get alot achieved and you are creating hardly any room for error. Also your concentration becomes more scattered when you focus on too many things at once.



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

Ugg Boots Outlet
Posted on: 2012-11-03 11:35:50 By: hyz
Should you not take advantage of powder you won't use a stream-lined with a reflection, thus both locate a plastic tote having a integrated reflection or even find a small lightweight reflect that you could put on your own eco friendly beauty totes.
Eco friendly aesthetic hand bags are generally similarly attractive journeying as they are able maintain all your makeup vegetation in one place,Coach Outlet Online which can be much more organized as compared to leaving behind the cosmetics goods bodyweight inside your toiletries handbag.Cheap Polo Shirts Having environmentally friendly beauty totes manufactured from natural cotton in journeying looks a lot more classy rather than padding every one of the cosmetics within a large bag.
If you wish to end up being uncluttered plus much more organized, Christian Louboutin Shoes Outlet why won't you are making use of beauty tote in your house?Replica Rolex Wathches There is a constant identified a way regarding maintaining makeup paint brushes directly into hands when you find yourself in a rush in the morning. Ugg Boots Outlet Environmentally friendly beauty hand bags involving organic cotton are accessible in numerous hues and classy looks for more details you can just click here: - www.thecotton totes.org


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.

No comments:

Post a Comment