How 2 become Oracle Apps DBA : Part I: E-Business Suite R12.2 Architecture

Looks Good for Beginner.

MAnish

good work buddy..keep it goin..pretty much useful to everyone.

yusuf

Really helpfull.Keep going.

Thanks.

Atul ur first session was great please donot stop continue.ther are very few in this world like you.you are very Good.

Thanks a lot, I’ll try to be regular as long as I am not piled up by work . Keep checking what sponsors has to say on right side menu bar.

really you are doing a great job.

Hi Atul,

This is really a great effort. I was looking for some
kind of Oracle Apps DBA training for quite sometime.

I really appreciate your time and efforts. Please keep
up the good work.

With best regards,
Kailash Raman.

Hi Atul,

It is really nice someone teaching. Thanks a lot for the same. Infact i was looking for someone who can guide me on the same. Keep posting. I found it very useful. I need your help.

Regards
S Govindarajan

Hi Govindarajan,
Thanks a lot, I am just sharing my knowledge with others & learning from others questions & dobts . You can mail me anytime at atul_iiit@yahoo.com

Atul
http://teachmeoracle.com

Hi Atul.
I am already working as an oracle DBA. i have good concept knowledge of oracle database. i participate regular oracle forms Mr. Tom kyte site.. just like Mr. Tom kyte u do some work for student and professional. right now i have no idea about Oracle Apps DBA but i want to learn. i hope u will help me.

Thanx Dear
Keep in touch.

M.S.Taj.

Taj,
You can mail me at atul_iiit@yahoo.com whenever you need any info/query.

Atul

It seems to be instresting to learn about Apps DBA now.

Hi Atul,
Very fantastic and impressive information for new bies…..
How long can it take for an Oracle DBA to become Oracle Apps DBA?

Thanks,
Abid Malik

Abid,
Thanks a lot for compilment . About time to become apps dba, It depends on individual & how much time He/She is spending + if learning is on Job or at Home .

I have noticed that learning on Job is much faster.

Atul

This work has to be appreciated… definitely.. Atul…, Flowers to you..!!!

Prasant

Prasant & everybody ,
Thanks a lot for your compliments . Do send me feedback how to improve & what topics you want to hear from me.

Atul

Hi

The efforts and the work you have done is very good. Thanks for guiding to learn the APPS

Mahesh,
Thanks a lot for compliment, you can download 11i software from

http://edelivery.oracle.com

Atul

Excellent work Atul. Great. Keep it up. You are infact setting up a good example of “Sharing” and doing good to the society.

I have problems understanding “Forms Listener Servlet Architecture”. Could you please explain it in your words and also its advantages.

Thnx
Ramana

Ramanna,
Thanks a lot for all those good words. You raised very good point . Forms can run on both socket or servlets by default sockets. I will explain in detail about forms in servlets with Advantage & disadvantages of using forms via servlets and how to configure it in my coming posts.

Atul

Thanks a lot Atul for your prompt response.

I would be waiting for your post on “Forms Listener Servlet Architecture” and their advantages.

I would be following your posts regularly as I have started learning “Oracle Apps DBA” with your help. But if possible could you pls drop me a mail on ramana_orac@yahoo.com when you post info on “Forms listener server architecture”

Thnx & Regards
Ramana

Its good for people like me looking for position in APPS DBA from DBA.

Thanks. Vignesh

This is good for people like me to begin APPS DBA from DBA

Vignesh

atul,

you are really doing a great job. this is my first day i happen to hit this web-site. i was also looking for something which would give me a start. i am already a DBA, so now i would like to pickup APPS DBA.

sudhir.

Atul,
you are doing great. this is my first hit on such a web-site, in all my browsing years. i was looking for some information on the oracle apps, as i myself am a ORACLE DBA. This would give me a great start.
sudhir.

Sudhir,
I Wish you could find everything you need as Apps DBA in coming years from thius site & my other site Teache Me Oracle

Hay Atul,

Its Precise and to the point to starters …. Good work ….

Martand

Thanks a lot to everyone for every one for making this site huge success.

Do ket me know if you want to know about any topic in apps & thats not included here .

Atul

Hi, Atul

Your work is very execllent. If i can help u for this work its my pleasure.

Bijay

HELLOW M.r ATUL .ITS VERY NICE KEEP ITUP. ITS VERY MUCH USEFUL FOR AVERY BODY WHO KNOWS DBA CONCEPTS LITTLE BIT.WITH U R BLOG WE CAN LEARN LOT OF THING
THANQ

hi Atul,

this is srikanth already working as Apps DBA this site will be usefull for beginners

srikanth bolagani

Hi Atul kumar

Good work, thanks lot

Realy help full to the beginners
i am also a beginner for oracle apps dba.

Hi Atul kumar

Good work, thanks lot

Realy help full to the beginners
i am also a beginner for oracle apps dba.

looks very simple…

Thanks a lot to all of you for your comments . Could you please suggest how to improve here & Site

http://teachmeoracle.com (Dedicated for Apps DBA’s)

Atul

Atul
Thanks alot This site is very useful.

From
Chandrakanth

Hi Atul it’s really gr8 to see such a website..i will also coprate with u …

Thanks a lot for your support.

Now you can post your questions/doubts problems in Forum dedicated to Apps DBA’s at

http://teachmeoracle.com/forum

They are really helpful
keep going
thanks a lot
-Madduri

hi atul

this is kumar.am a tech consultant and setups and sysadmin for oralce app’s .really am confusing about my future so am planing to learn app’s dba .
am in chennai am working for one of the major it company..can any one suggest wich is gud institute for app’s dba or any one teaching who is working .any body know’s let me know
my e-mail id:sullank@gmail.com

hi atul

this is kumar.am a tech consultant and setups and sysadmin for oralce app’s .really am confusing about my future so am planing to learn app’s dba .
am in chennai am working for one of the major it company..can any one suggest wich is gud institute for app’s dba or any one teaching who is working .any body know’s let me know
my e-mail id:sullank@gmail.com

KK few training Institutes are listed at http://teachmeoracle.com/training02.html

Atul

HiAtul
Looks pretty good for beginners.its evry uselkfulfor all and most useful for a new career launch IN Apps.KeepGoing ..Your should grow good as you keep good in sharing your knowledge

Hi Anonymous,
Thanks a lot for your wishes, I need some of you to help other Budding Apps DBA in answering their questions/doubts at forum http://teachmeoracle.com/forum dedicated to Apps DBA’s

Hi Atul,
I would like to publish my documents/experiences in http://blogs.oracle.com/ . How to do that.

You can request to put a link of your blog to http://blogs.oracle.com . I don’t know what they look for but if you could share your blog name with readers

You can have blog space at http://blogs.oracle.com/yourname
only if you are oracle employee .

If you are not from oracle then put it on some site like I am doing on blogspot.com

Thanks for the help!

good stuff as always!

Hi,
This looks a great site for a beginner such as me. kepp up the good work.

Alan.

Hi Alan ,
Thanks a lot for your compliments ….

Atul

hi atul..first of all thanks for sharing ur knowledge ..
I am NOT a DBA but a java developer who uses oracle a lot for procs, functions,queries etc..basically PL/SQL ..i feel i m okie in all that..i wanna switch to oracle Apps ..and NOT oracle apps DBA …do u have any reference where i can start from? please if u can reply back at letseewatsup@yahoo.com i would be glad. THanks a TONNNNN!

You can start with Anil Passi’s site for technical apps development at http://oracle.anilpassi.com

Atul

Hi Atul,

Thanks for what you are doing.

Keep up the good work

Hi atul
Iam new to oracle . so plz tell me how to be strong in oracle basics . In which areas i have to be strong ……Wat are all concepts i should be strong

Mano,
In my views most important thing you should understand is Oracle Database & Apps Architecture & to understand various components of Apps.

Then you can focus on Patching , Cloning …

hello friend atul
you have done a wonderful job,Its really a nice site.it will help lot for those who can’t pay a huge training fees. I really appreciate your job. I will definitely become a aPps dba.
thanks and regards;
sadashiv shinde(oracle 9iocp_dba trainer pune)

Thanks Sadashiv

Atul

Hi Atul ,

U r doing a great job ..Its like showing a way to the one who shows has lost guy ..

Great job,Simply classic energetic information i had,Myself Thivagar & beginner in DBA field preparing for OCP 9i,very much useful to fresher like me & Hats of thnaks Atulji, Keep goin on & on …
Lots of Heartly blessing to u & ur family.

Great job,Simply classic energetic information i had,Myself Thivagar & beginner in DBA field preparing for OCP 9i,very much useful to fresher like me & Hats of thnaks Atulji, Keep goin on & on …with lots of Heartly blessing to u & ur family.

Thank you for a great compilation of the Oracle. It really was helpful.

Santosh,
Thanks a lot !!!

Hi Atul,
Good work. Impressive. Although, I do not use the site, but I am very much impressed on the amount of work you have put in.

Congratulations.

Sunil

Sunil,
Thanks a lot for those good words. Your comments & readers feedback are my inspiration. Do let me know if I can try improving somthing on this blog to make it useful to everyone including you 🙂

thanks a lot it is very useful for a beginner like me
keep going

Thanks a lot anonymous

Your site seems very interesting! Thank you for your hard work.

Thanks a lot Vinod

Hi Gurudev,

I just started learning Apps DBA.

Pls bless me.

Regards,
Rakesh Reddy

Hi Atul,
I am really touched the way you put togather facts for Apps DBA. You are in UK but due to your auspicious work, you have reached everywhere.
I am certified 10g DBA and want to start Apps DBA. Where can I find books/references?

Thanks,
Dilesh

Dilesh,
Thanks a lot .

All Apps Guides are updated in above post itself at

http://download-uk.oracle.com/docs/cd/B25516_08/current/html/docset.html

Hi Atul,
It is really nice to have your email so quick. I book marked the link for future reference. As a DBA, I have setup 9i, 10g databases from scratch and applied patches,performed backups and installed 10g Apps server and configured report servers. I have gone through Oracle Financial 10.7sc intensive training in India, will it help me in becoming Apps DBA? I am a really good developer as well and got certification for developer 6i Release 2. Now, looking to my exposure, will you please tell me what step should I follow to start ii1 Apps DBA? Do you think that classroom training is required for Apps DBA?
Thanks,
Dilesh

Dilesh,
I think its more than enough. I would suggest you instead of class room teaching start with hands on Installation, patching & cloning 11i.

Good luck for your Journey towards Apps DBA

Hi Atul,
Thanks for your inspirational email. I will follow your suggested path.
Dilesh

Hi Atul,

This is really a great effort. Keep Doing.

Regards,
Neeraj

Hi Atul,

This is really a great effort. keep Doing.

Regards,
Neeraj

Hi Atul ,

Tis really a great effort , keep it up .

Prasanta Patnaik

Thanks Prasanth & Neeraj

Regards
Atul Kumar

excellent blog

Hey Atul,

I am a friend of Dennis who works in Oracle Bangalore and He spoke very high of you and also told me about this site. Its a wonderful site. I think this site has become similar to asktom. Hats off to your good work Pal.

Thanks
John

Hi John,
Thanks a lot for your wishes .

Atul

Hi Atul,
This is really a great site especially for beginners.
Can you throw some light on Oracle Alerts especially Event Based Alerts?
Waiting for your update.

Thanks
Anand

Anand ,
Thanks a lot. I am not very good in alerts but will try to cover in future whatso ever I know

Atul,
Thanks for your assurance. I wanted to know one more thing. Is it possible to configure HTTPS only for the login screen, so that the username and password can be pass through internet encrypted instead of clear text? My organization does not want to do any investment in procuring any certificates. Is it possible to accomplish this without making any investment?

Waiting for your update….

Thanks
Anand

Yes you can tweak around using sso. For free you cabn use test certificates comes free with oracle HTTP Certificates

Thanks for the update Atul. But can you please elaborate? Probably a URL or a link in your site would help. We are not using SSO here.

Thanks
Anand

Anand ,
To be frank it is bit complicated (not very straight forward) I did some work on 10g AS Integration with Apps for SSO but I don’t to post it on site at this minutes . Here is metalink note which you can refer metalink note

233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release…

& then configure SSL for HTTP Server on SSO (Infra tier).

You have to study a lot for this

Thanks Atul for the metalink note.

Regards,
Anand

Many Thanks to you Atul…for offering your genuine help in teaching Oracle!!

Aditya P

Hi Atul, Just now I started this training .It is looking too good. I’ll try to be regular

Thanks Veera.
Pass it on to your friends as well & do let me know if you need any further information

This site is exactly what I’ve been looking for. Thank you

-Everett

Hi Atul,

How are you, My question is how do we configure PCP on 11i Apps.Please give some tech Docs

Thanks & Regards
ASD

ASD Follow

278816.1 How to Setup Parallel Concurrent Processing using Shared APPL_TOP for RAC Environment

Kindly use forum http://teachMeOracle.com/forum for such doubts in future

You are a decent man. It’s hard to find people who would take up a noble deed like this. Goddess Saraswathi be with you always..

It really Helped me alot but please let me know whats the difference between DBA and Apps DBA??? the operations are same onyl clonning and patching and updation is what apps DBA has to do ………..please correct me if am i wrong ….

hi,
I am not an Oracle DBA, But interesed in Apps DBA. Is it possible to learnn it?

Yes !!

Hi Atul,

This is priyanka. I m very much interested in Oracle Apps. I not DBA ya but i have learnt Oracle 9i during Btech. Can i learn Oracle Apps with having much knowledge abt Oracle. If no then pls guide me how to start and wat all i should study.

Thanks

Hi Atul,

I m not DBA but want to learn Oracle Apps though i have studied DBMS and Oracle during Engineering. Cud u pls guide me how to start and wat all Topics shud i go through to become Apps DBA

Follow section under For Apps DBA Beginner’s in left menu bar for start

Hi Atul:

Thanks forsuch a good knowledge giving it free.
I am a DBA, wana to nbe Apps DBA?
Will the study at ur site will be enough or I need to go through something else?

Regards
Bhushan Walde

Bhushan,
For a start this blog should be fine but you have to read more from Oracle books for specific issues

Hi Atul,
All the Apps DBA Info on same page this is really great effort. Keep it up, its very useful for all.

Dinesh (Govind)

Hello Atul
Well one can’t stop appreciating all the effort you are putting into building this blog.Thankyou so much.It is overwhelming ….everybody here seems to be a DBA before they considered APPS Dba well, i am not a DBA and what are the other books I need to read along APPS books.Two others asked you the same and u replied saying to start from the beginners section…but it is unnerving to see ” First thing is you should be Good in Oracle Database Skills and I assume you are already very good as DBA or don’t need any formal training as DBA” 🙁 please help

very helpful, thanks

Awesome work buddy… Thanks

I am very thank full to giving such information

Hi Atul,

Good Work, Started my First Day Class 🙂 to be a APPS DBA. I am planning to move ahead, with E-Business,

Cheers & Keep it updated to help people like me

Ravi Prakash

Hi Atul,

very thanks to u to help pepole
to their self in road of oracle
APPL DBA.

Thanks and
Regards.

J.smith

Hi Atul,

Very thanks to you to help us to
become oracle app Dba .

Thanks and
Regard.

J.smith

Hi Atul,
The Documentation will really help a beginner like me. I am a beginner in apps dba and I need to know if Oracle applications can be installed on a home PC ? I mean in one PC with a configuration of 512 MB with 40GB hard drive or do I need to look for a sever in Web, something like webhosting ? If so, which is my best option ?

Regards,

Rajesh

You don’t need server and can be installed on normal computer but you might need more CPU and harddisk.

Check installation guide with prereq. for installing apps

Hi Atul,

First of all a very big thanks for the wonderful help that you have been providing for all learners like us.I would like to know if there is any site where we can get more knowledge on core DBA as well.
If so that would also be a great help again …
thanks & regards
seha

Hi SEha,
Thanks for these nice words. For core DBA I am not aware of any site which provide free training but my recommendation . Go to oracle documentation and pick oracle dba documentation nd go through them

Really i am surprised why i didnt know this website earlier. Man your Efforts soooo much Appreciated. Thanks a lot.

Dear Atul,

is it possible that the client ( desktop tier) connect to forms server without the web server ( apache) and in case the apache server is down what will happen?

Regards,

Samer ALJazzar
Oracle DBA
NBK – Kuwait

No , Initial connection will always be via Apache in standard Oracle Applications 11i

Hi Atul,

I have basic knowledge of oracle 9i database, i am looking my career as ORACLE APPS DBA. Will it possible for me to achieve that.

I had been with the Oracle application concepts, im not finding any difficulty in understanding them.

It really sounds good.

Note: I dont have depth knowledge on database. I am working as UNIX Administrator.

regsrds,

Nagesh Prabhu

Yes Nagesh, you can be good apps dba provided you focus on basics and work hard

This is a best.
but give step by step giude.
This is perfect for every one.

thank,
Suhag Shukla(ORACLE DBA)

Thanks Suhaag, Step by Step will take quite a lot time for each post but I’ll try to put as much detail as I can in my future posts..

I have gone through the material you recommended (11iconcepts pg 1-19). It is quite interesting not very complicated and not long just as you had said.

So basically, the aim was to grasp the architecture of the E-Business suite.

Now am looking forward to the installation part of it.

Hi Atul,
Can U plz Suggest a blog or site 2 learn Oracle 10g DBA by Step by Step

I am not aware of step by step but few dba blogs are mentioned in blogroll

hi Atul, Ur blog is good but i found ur blog is just overview on all the topics, why dont u go more deeply on all the contents.

Thanks for feedback, yes I agree majority of posts are on overview and reason for that is most of guys I met are not clear of concepts even so I thought of dicsussing them first though I have some posted on few things in detail as well . Do let me know on which topic you want me to cover in detail and I’ll try to cover them

Hi Atul,

This is Shobhit. I m very much interested in Oracle Apps. I am 10g Certified Professional but i am a fresher. Can i learn Oracle Apps . If yes then please guide me how to start and what all i should study.And is it good to switch from enterprise to Apps.

And in last your blog is really having much to learn.

Regards,
Shobhit Saxena

Guys,

Oracle DBA’s life is not a cool one ,try to switch to application development for a peaceful life .

Cheers,
Vinod (Oracle DBA)

I am a new DBA in Oracle Application 11i. I was worried, how can I learn this. At last I found this site.

It’s a ggod start for me. Material on thsi site is more helpful to become Oracle Application11i DBA.

Thanks.

Hi Atul,

I am a beginner for Oracle Apps,I am interested in pursuing a career.I refer the material you provide.I would like to practice the installation and the patching,can u guide me how to go about. I have an external hard disk, can I install the linux and the oracle Apps on the Hard disk, if so how can I or if there is any other alternate way that i can practise.Could you please help me out..

regards
Abhi

Dearest Atul
Thanks a ton, this would become an highway for 11i training, great work, splendid……
Divaker V Vittal
Oracle DBA

Dear Atul,

Keep up the good work. Its amazing to see you give simple solutions to the problems which seemed nearly impossible before getting to your site.

warm regards,
Pankaj Sharma
http://www.shreecement.net/sysadmin.nsf

Hi Atul,

I believe its an exact web site for Oracle Apps DBA, But can u plz clear my doubt.

Am an high end Oracle DBA having 3 yrs exp in HP,configured more than 20 Dataguard for banking DB’s and a lot of hard core performance tuning work!!!!!!
So is it proper way that i can switch to Apps DBA domain….
Can u plz compare Oracle DBA and Apps DBA in terms of Salary,demand in market,good future.
Your guidance will be highly appreciable…..

Rgds,
Yasser

Dear Atul;

Gr8 work, please continue to support us.

I am a beginner in this field and i need a lot of support from people like you. Please keep on doing the good work.

I am interested in your training program that you are going to conduct in India, please Email me more info regarding that.

Thanks again.
Sajid Khan
mail4saj@gmail.com ; mcasajid@gmail.com

Dear Atul,

I am an Oracle DBA looking a career in Apps.
You are doing excellent work buddy.

It is very helpfull for people like me.

I am astonished at your patience level.

Keep it up.
Thanks
Sridhar.

WOW ! it is a great site, unfortunately I didn’t find it earliar, your effort is helpful to the computer professionals particularly who are interested to become Oralce Apps DBA.
Great Job Atul, keep it up……….

Hi Atul,

can you give about info.( 1Z0-233 Oracle 11i Install, Patch and Maintain Applications)

about book.

Thanks

Atul,

This is the best information site i have ever seen.

Keep up the good work dosth.

Santhosh.

Hi,
Atul , u have done a gr8 job.

I have a query for u . Basically iam a Oracle DBA, but got an oppertunity to work as Apps DBA. Here i don’yt have any one to teach me iam learning og f my self and maintaing the Production system.

If possible can u mail me the procedure for cloning my Production system.

Thanks in advance.

Regards.
Lucky.
Saudi Arabia,
liyakhat_md@gmail.com

Good job mate, I am working on Oracle Apps 11i environment.. it is really interesting to keep testing your professional skills 🙂 … can you please send me your email, so we may do some business…

Thanks body

Hi Jehad,

Do you whant what e-mail? Mine?

BEst Regards,
Paulo Portugal.

Hi all,

Just a clue, if you want to really learn it, install it and then practice a lot(install patchs,use everything of adadmin, add languages, crash you database, rollback configuration,etc).

Best Regards,
Paulo Portugal.

Thanks Jehad,
You can contact me at

atul @ onlineappsdba.com

Hi Atul

I have been following your site for past couple of months. Its very informative but one suggestion I have is that for people who don’t have access to metalink and oracle support, could you not create a FAQ of sorts where you can put in the frequent problems which have been encountered by you and the solutions for those problems.
Your site is nice but there’s too much theory in it…Or maybe thats why you have those webinars/Online Training on the site….

Hi Atul 🙂 u r Cute 😉

Can you send please 1z0-233 sample questions to
krishel124@yahoo.com

Thanks a lot,

Kris

I think it would help a lot for me and others….))))

thank u buddy

Hi Atul ,

First site I have seen where information provided is consistent , accurate and up-to-date.

Hi,

very goog site, and the idea is is the greatest

thanks

Hi Atul,
God bless you for this good work. I’m very new to Apps DBA responsibility , with just about 2 yrs of experience as Oracle 10g DBA ,I’ve have a long way to go.But I’ve greatest penchant for 11i Apps.I’ll keep in touch with you for any relevant enquiries/discussions.

Thanks again.

Arshad.

Thank very good for anyone who want to start career in oracle apps dba.
i am new and yet not install oracle apps yet.today i will try to installl..
but your suggestion are very important for me …
please guide me because i am new and want to learn oracle apps ..

thanks

Hi Atul,

You are doing a fine job. Pls guide me; I am working as a DBA on Oracle 10g Server. My Database knowledge is fair, not so good. I want to switch to APPS DBA. How to step further ? Can APPS DBA study will improve my Database Knowledge ? Little Confused !

Regards,
Muhammad Umer Iqbal

hi Atul,

i worked in a comp for some months,during my training i found that i was most interested in DB field.i have some knowledge in sql,but i dont have any knowledge in oracle,one of friend told me about this oracle 11i apps DBA course.i dont know whether i can do this course,since i dont have any knowledge in oracle.morever i dont have much industry experience.please advice me about this.

Thanks
murugharaj

Yes, you can learn/become Oracle Apps DBA but you have to practice a lot. (If you wish to be expert in this domain)

for Umer, you need to work harder to achieve something

Hi Atul ,

I have a question to ask , can I install Oracle apps on my Home PC for practice??

Please assist

Yes inder you can install as long as you have enough memory, disk and right o.s.

Hi Anil,

I am a Oracle Apps Techno Functional Consultant and wanted to learn Oracle Apps DBA. Can you please suggest from where I can start.

Thanks
Faiz

hi atul,

do u know any “oracle apps dba” traing institute in sheffield(uk). or is there any job opportunity for “oracle dba(production)”.
if i have 3yrs experiance “oracle dba(production)” and if i want to move as “oracle apps dba” which topic i should select during the apps dba course?

Hi Atul,
Need your expert advise,
I need to make a major decision in my career.I’m basically into oracle apps functional domain since 2 years and have now been asked to move to Apps DBA . Is it good considering that i have very little idea about DBA .
Please suggest as to what is the learning curve for picking apps dba skills so as to work in a decent situation without much help.

Hi Atul,

I m Mohammed Ashfaq Hussain from saudi arabia working in a Ministy, i m Core DBA & i know basics of Apps DBA i would like to become very good in Apps 11i / R12 so thanx very much to supporting us..

thx
wajid
00966550682896

Hi Atul,
I work as a performance tuner and am planning to move into Apps DBA as i find it intresting. I hope I can learn much from this site.

I have a question though- being a DBA, you have to be in shifts. How do you manage your personal life with shifts. Especially if both hus. and wife are working?

thnx,

Hi…Atul
I’m beginner for oracle APPS DBA.I’ve got knowledge in oracle DBA..so could plz advice me how to become a APPS DBA

Good Question (how to become apps dba)

My tips

1. Go through Oracle Apps Architecture Guide
2. Go through Oracle apps Installation Guide
3. Install Oracle Apps
4. Go through file system (physically on server) and from Oracle Apps concepts guide
5. Learn Start/Stop of apps
6. Go through ad utilitites guide
7. Apply apps patch using adpatch
8. Check ad controller adctrl to see worker status
9. Clone apps instance using metalink notes
10. Finally try backup

This should cover most of day to day task for apps dba’s

For next level learn Advanced deployment like
1. Mulitple Middle tier configuration
2. Setting load balancer and DMZ
3. Integrating apps with OID/SSO
4. Upgrade from 11i to R12
5. Confihuring SSL
6. Upgrading tech stack in apps
7. Upgrading database with apps
8. Configuring RAC with apps database

For documentation check http://www.oracle.com/technology/documentation/applications.html

Hi Atul,

Undoubtedly you are really doing good job.

Would you help me out with some information on Oracle Apps 11i Functional as i am planning to do this course and also about the future prospect and scope for this course.

For functional training check http://focusthread.com/training

hi Atul,

I want a conceptual concept of Oracle Apps like
— what exactly the six different servers contains.
— is it same as our database server.
— what is the archietecture of these six servers.
— where the actual html forms/ frx files/ report files are stored etc…

I am new to the Apps.

Please reply

Thanks,
Ash

– what exactly the six different servers contains.
Database Server, Web Server, Forms Server, Concurrent Manager Server, Admin Server, Discoverer Server (This is for 11i)

– is it same as our database server.
Database Server for apps is same as standard database server with some additional things like Autoconfig under apputil directory in Oracle Home. Forms & web server are based on Oracle Application Server

– what is the archietecture of these six servers.
Check Oracle Apps Architecture Guide

– where the actual html forms/ frx files/ report files are stored etc…
On application tier under APPL_TOP under their own product directories (check file system under Architetcure Guide)

http://onlineappsdba.com/index.php/2006/08/08/apps-architecture/

thank you atul for your reply

is there specific reason for dropping discoverer server in 12i architecture

Thanks
Ash

Hi Atul,

for basics i read Ch 1 & 2 of Oracle Application Concept.
I installed R12 on my test machine.

but still, not getting clear idea.
for more basic knowledge which chapters should i read either from concepts or from installation guide.

please suggest.

Thanks
Ash

Hi ATUL,
nice post!

Hi,

I am workin as an ERP Administrator and had plans to switch to Oracle Apps DBA. I am OCA in Oracle 9i (SQL and Fundamentals). I have conceptual knowledge of Oracle DB architecure and it has always been my fav subject. For I get chance to work in real time on Oracle few time like installing Oracle Db, crating table, indexes, altering users, access level etc. My total exp is around 6 yrs. Can you please suggest me if I can swith over to Oracle Apps DBA (as I am ERP Admin, my knowledge of working in ERP will help as understand modules, patches, deployment, etc..). Reading above guidance about learning Oracle apps DBA as given me morl support that yes it is not tough. Can you pls advise me how should I pick it up and can swith over to ully Oracle apps DB profile.?

i am working as oracle core DBA, I would like to switch to apps DBA, so its nice to learn the conecpts here.

thanks alot

thanks for the information,its very useful for me..

its really good work keep it up Atul

Hi Atul,

Hope you are doing well..First of all i want to say a big thank you for your great efforts in sharing your knowledge..great work..

Right Now working as an Oracle Dba and would like to know more about Apps. Today i went through your site and start reading about the Apps concept.

Again Thanks a lot

With Regards
Jishar

hey

i just got the apps concepts material and will be starting on it tonite, a big thank u for such a great job u doing as i want to follow the apps DBA this is a great start for me ,

Big thank you
God bless

Tummies

Hi Atul
Really great job
i am not able to find 11i on edilevery site.can you pls tell me which option should i download

@ Jaspreet , check this

http://onlineappsdba.com/index.php/2009/07/17/oracle-e-business-suite-erpapps-11510-software-download/

Hi Atul,

I read your forums and it is very helpful.

You are doing really a great job. I need your advice.

I have 6 years of PL/Sql development experiance and now i am working as Tech Lead in one of the company. It is right decision to become Oracle Apps DBA now.

I have not worked on form and reports nor more on Oracle Core DBA.

Please suggest/advie me, Is it correct decision to join Apps DBA in this stage or should i continue with my current profile ?

Thanks,
Rahul

hi atul,

Thanks for giving valuable supporting.
Am working as a oracle apps dba! still am not done any certification… can i do directly oracle apps dba cerification? is it possible?
Thanks!

Hi Atul,
Good Going
may i know what’s the difference between
Apps Technical
Apps Functional
Apps Techno-Functional

hey gr8 work atul.
its like metalink support from oracle
i have good knowledge regarding apps but 0 in troubleshooting
if u forward some doc or ppts regarding d the same if possible

what is the meaning for vision demo database

@ Khaja,
Vision Demo Database means Oracle Apps will be installed with demo data which functional guys can use to test functional setup. From DBA’s point of view size of database will be much bigger when selecting Vision compared to fresh database.

hai atul you told me answer for “how to restrict users from loging in to instance even front end is up and running?”

answer is this,

Configure Firewall between users and application tier and block web server port on firewall
please tell me how can we do this?
thanku

@ khaja,
Fir decide which Firewall you are going to use (hardare or software) then use appropriate firewall document to block/allow port.

If your application tier is on Linux you can use pre installed software firewall “iptables”

http://en.wikipedia.org/wiki/Iptables

Hi Atul,

Is the book Oracle Applications DBA Covers 11i and R12 sufficient enough to prepare for the exams 1z0-235,1z0-236 and 1z0-233 atleast to an extent of 75% to become an Oracle Apps DBA 11i ?
Please guide me in this.

Thanks in advance.

Sorry, I have not mentioned the author of the book

book – Oracle Applications DBA Covers 11i and R12
author – Joyjeet Banerjee
Publications – Tata McGraw-Hill Publishing Company Limited

@ Vishnu,
I have not seen book myself. To check if it covers certification topic, simply check index of book with exam topics for 1Z0-233 http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=1243197&lang=ZHS&p_exam_id=1Z0_233

1Z0-235 & 1Z0-236 are core DBA topics and I don’t think 235, 236 topics are covered in detail in book you mentioned above.

Thanks for your reply,

I want to know which path will be more fetching for a fresher to become Oracle Apps DBA 11i, considering the time factors and availablity of study materials.

1) OCP DBA 11g -> 1z0-233
or
2) 1z0-235,1z0-236 -> 1z0-233

Please suggest me.. Thanks..

@ Vishnu,

My option would be 1st i.e. OCP DBA 11g -> 1z0-233

@Atul

Thanks a lot.

hi atul
can please tell me what is the difference between
SHARED APPL_TOP,DISTRIBUTED APPL_TOP
and iam reading that book 11i concepts
i completed till admin server its good till where i can stop it.
thanku alot
khaja

@ Khaja,
Check metalink note
243880.1 – Shared APPL_TOP FAQ

Hi, Atul

Thank a lot for helping out the beginner professional.. keep it up.. keep helping

Regards
JALAJA.K

hi atul,

thanks u very much .can u please elaborate all the concepts.

Regards
siva

Hi Atul,

It’s really very helpful in getting through the apps architecture….thanks a lot.

Regards,
Aishwarya.

Hi
i wanted to switch over the oracle apps DBA.i dont having the DBA background but having the experience in oracle 9i database With strong knowledge in SQL.

can i choose the field of apps DBA?

Please suggest me!

THNKS

HI,

Im Fresher joined recently and trained as Oracle DBA.

Is learning Apps now a correct time ??

I like to be a Apps DBA. Where can i learn Apps ??

Regards,
Sundar.K

@ Sundar,
Yes in my view this is correct time .

You can learn on your own by picking apps dba documentation from Oracle.

You can also join one of training institute (join one which provides hands-on practice sessions)

Check http://focusthread.com/training

link is not working. it is invalid url.

@ Abha,
Are you talking about apps dba training link mentioned above or something else ?

http://focusthread.com/training/online-apps-dba-training-11i-r12/47-oracle-apps-dba-training

Hi, Not everyone would take out so much time to help out people. it really is a great thing you have done,

I’m a DBA but i also like to learn oracle apps.
This might sound stupid but I am somehow unable to locate the guide “oracle applications concepts” in the EBS link you have posted.

are you referring to Oracle Applications 11.5.10.2+ Online Documentation Library? Please help me out as i want to start off as soon as i can

got it, Thanks i will go through and let you know if i have doubts

Hi,
We are having oracle 9i database running in a different server machine and oracle 11i forms running in a different server machine. I like to know how these two servers are linked to each other and where the respective settings are in. We use a solaris sparc server. i used to start the database startup script first and then the startup script for forms server in the different machine. what are the settings that link the database to the forms server

Thanks Atul,
Kindly suggest me an Open source linux OS which i can install in virtual box and test all the softwares. I am well trained in unix platform. I felt ubuntu was a bit easy to use but i am not able to install any oracle software for testing as all ends up with an error

Thanks atul,

It seems my server is connected in a socket mode.
I checked the listener.ora and tnsnames.ora. I found the following lines . are they the configuration settings that connect each other

listener.ora

SID_LIST_PROD =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= TEST)
(ORACLE_HOME= $ORACLE_HOME)
(SID_NAME = TEST)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = $ORACLE_HOME)
(PROGRAM = extproc)
)
)

tnsnames.ora

#
# Intermedia
#
extproc_connection_data =
(DESCRIPTION=
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROCPRD))
)
(CONNECT_DATA=
(SID=PLSExtProc)
(PRESENTATION = RO)
) )

Is the ExtProc connecting both the servers. If not why are they used.

Hello Atul Sir,

May I please have your email id(The one you use often).
Mine is uditappsdba@gmail.com
I shall be highly obliged.

Regards,
Udit Kulshrestha

Hi Atul,