Oracle Application DBA

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

Comments

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

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

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

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

restrict single session per user in R12 Posted on: 2015-05-30 12:15:53 By: Murugan_t
Hi Kishor, Good to see many things on your site and very useful to the people who visit your site/blog. Regarding the subject "Step By Step Instructions to restrict single session per user in 11i and R12". It seems as the existing active user becomes inactive when same user logs in again. Is it possible to restrict same user logging in again if the same user is active.

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

hi expertzz

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

thanks in advance

fresher Posted on: 2015-07-28 14:01:11 By: shanmukhApps
hai sir............. I am fresher in apps dba so some fundemental steps are give me. please...... thanks to advance.......

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

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

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

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

Hi,

I am new to this forum.

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

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

The database we use is Oracle 10g.

Can someone clarify the below points.

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

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

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

Thanks,
Jayganesh

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

Hello,

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

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

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

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

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

Regards
Farookh

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

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

Re: excellent lib ihave never seen .... Posted on: 2016-03-09 19:23:38 By: akr14feb
Thanks Manoj, Appreciate your comments, you can join our group by sending a mail to appsdba@appsdba.info Regards Admin http://www.appsdba.info

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

dear all&admin

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

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

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

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