Leave a Comment:
238 comments
good work buddy..keep it goin..pretty much useful to everyone.
yusuf
ReplyAtul ur first session was great please donot stop continue.ther are very few in this world like you.you are very Good.
ReplyThanks 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.
ReplyHi 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
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.
ReplyTaj,
You can mail me at atul_iiit@yahoo.com whenever you need any info/query.
Atul
ReplyHi 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
ReplyThis work has to be appreciated… definitely.. Atul…, Flowers to you..!!!
Prasant
ReplyPrasant & everybody ,
Thanks a lot for your compliments . Do send me feedback how to improve & what topics you want to hear from me.
Atul
ReplyHi
The efforts and the work you have done is very good. Thanks for guiding to learn the APPS
ReplyMahesh,
Thanks a lot for compliment, you can download 11i software from
Atul
ReplyExcellent 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
ReplyThanks 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
ReplyThis is good for people like me to begin APPS DBA from DBA
Vignesh
Replyatul,
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.
ReplyAtul,
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
ReplyThanks 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
ReplyHi, Atul
Your work is very execllent. If i can help u for this work its my pleasure.
Bijay
ReplyHELLOW 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
ReplyHi 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.
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
ReplyHi Atul it’s really gr8 to see such a website..i will also coprate with u …
ReplyThanks 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
Replyhi 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
ReplyHiAtul
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
ReplyHi,
This looks a great site for a beginner such as me. kepp up the good work.
Alan.
Replyhi 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
ReplyHi 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 …
Replyhello 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)
Hi Atul ,
U r doing a great job ..Its like showing a way to the one who shows has lost guy ..
ReplyGreat 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.
ReplyThank you for a great compilation of the Oracle. It really was helpful.
ReplyHi 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
ReplySunil,
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
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
ReplyHi 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
ReplyHi 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
ReplyHey 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 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
ReplyThanks 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
ReplyMany Thanks to you Atul…for offering your genuine help in teaching Oracle!!
Aditya P
ReplyHi Atul, Just now I started this training .It is looking too good. I’ll try to be regular
ReplyThanks 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
ReplyHi 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
ReplyYou 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..
ReplyIt 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 ….
Replyhi,
I am not an Oracle DBA, But interesed in Apps DBA. Is it possible to learnn it?
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
ReplyHi 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
ReplyFollow section under For Apps DBA Beginner’s in left menu bar for start
ReplyHi 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)
ReplyHello 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
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
ReplyHi Atul,
very thanks to u to help pepole
to their self in road of oracle
APPL DBA.
Thanks and
Regards.
J.smith
ReplyHi Atul,
Very thanks to you to help us to
become oracle app Dba .
Thanks and
Regard.
J.smith
ReplyHi 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
ReplyYou 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
ReplyHi 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.
ReplyDear 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
ReplyHi 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
ReplyYes Nagesh, you can be good apps dba provided you focus on basics and work hard
ReplyThis 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..
ReplyI 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.
ReplyHi 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
Replyhi 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.
ReplyThanks 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
ReplyHi 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.
ReplyHi 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
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
ReplyAtul,
This is the best information site i have ever seen.
Keep up the good work dosth.
Santhosh.
ReplyHi,
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
ReplyHi 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.
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
ReplyHi Atul ,
First site I have seen where information provided is consistent , accurate and up-to-date.
ReplyHi 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.
ReplyThank 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
ReplyHi 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
Hi Atul ,
I have a question to ask , can I install Oracle apps on my Home PC for practice??
Please assist
ReplyHi 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,
ReplyHi…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
ReplyHi 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.
Replyhi 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/
Replythank 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,
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.?
Replyi am working as oracle core DBA, I would like to switch to apps DBA, so its nice to learn the conecpts here.
thanks alot
ReplyHi 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
ReplyHi Atul
Really great job
i am not able to find 11i on edilevery site.can you pls tell me which option should i 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
@ 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
ReplyHi 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.
ReplySorry, 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.
ReplyThanks 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..
Replyhi 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
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
ReplyHI,
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
Reply@ 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
ReplyHi, 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
Replygot it, Thanks i will go through and let you know if i have doubts
ReplyHi,
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
@ Karthik,
Depending on mode in which forms is configured (Socket or Servlet) it uses TNS or think jdbc to connect from forms server to database. (connect details are in $TNS_ADMIN of Forms/Report ORACLE_HOME or in dbc file under $FND_SECURE)
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
@ Karthik,
You can use Oracle Enterprise Linux (OEL) 4 or 5 and download same from http://edelivery.oracle.com/linux
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.
ReplyHello 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
@ Udit,
Post any query/doubt on this blog under comments section
Hi Atul,
Could you please let me know how to find the below info from 11.5.10.2 instance.
1. Total no of application users that exist module wise
2. No of users logged in module wise
3. No of users logged in last ‘n’ days
Thanks in advance
Regards
vara
Atul,
Thanks for the blog.
Your blog is very helpful. As I wanted to learn apps dba concepts, but no clue where to start. Your blog shows the path where to start.
Thanks Once gain.
Regards,
Kusuma
Dear Kumar,
I have executed adpatch to apply a patch 10627713. While patching, I have received the following error, kindly guide what should I do to rectify the below error ??
++++++++++++++++++++++++++++++++++++++++++++
error message while patching
Parsing and loading patch driver file…
212 lines processed.
Not checking patch integrity as integrity checking flag is turned off.
Successfully read patch driver file.
Determining target release…
Current target release is 12.1.1
AutoPatch warning:
None of the NLS languages listed in the patch driver file are
installed in the database instance.
Patch 10627713:IS is a NLS patch.
You must first apply the corresponding US patch
for the NLS patch(es) listed above.
AutoPatch error:
——–
A fatal error related to codelines or codelevels has occurred.
See messages above for details.
——–
You should check the file
/u01/app/oracle/AKBLPRD/apps/apps_st/appl/admin/AKBLPRD/log/u10627713.log
for errors.
++++++++++++++++++++++++++++++++++++++++++++
Kind Regards,
Junaid
Reply@ Junaid,
It looks like you are applying NLS patch where as you must first apply base US ENGLISH patch.
@ Junaid,
When you downloaded patch , for which language you download ? Select Language as US English and apply that patch
Trying to configure SSO for OAM
11.1.1.7.0.Other components used are db11g,weblogic,OID,http server webgate.I’m
totally confused,browsed all the related topics on google ,but no use ,got even
more confused.Dont know how to use the identity ,policy & credential
store.totally lost pls help.
Trying to configure SSO for OAM
11.1.1.7.0.Other components used are db11g,weblogic,OID,http server webgate.I’m
totally confused,browsed all the related topics on google ,but no use ,got even
more confused.Dont know how to use the identity ,policy & credential
store.totally lost pls help.
– Install OAM as per installation guide
– Install OID and integrate OID with OAM
– Install OHS
– Configure OHS as proxy (mod_wl_ohs) to forward requests to OAM
– Install WebGate on OHS
For time being forget about identity, policy and credential and ask query specific to installation & integration document .
ReplyPlease do you have a free class that explains difference betwwn
APPS DBA and 11i/R12 DBA
the place of Web Logic, OC4J, SOA suite, and Oracle Fusion in studying AppDBA
Hi now i have completed Oracle DBA then thn surely ill continue in apps dba too . My future plan is to start a bussiness either online r offline.Oracle is my interest so can i make use of my Intersted app Oracle to develope a bussiness or not. Is ther any chance like tat.if so please explain through mail @
babuthiagu31@hotmail.com
eagerly waiting for ur valuable suggestion!!!
Dear Atul Kumar,
my name is ehsan and i am fresh graduate i have completed Mcs, and want to become Oracle DBA and Apps DBA so please guide me as beginner and tel me the best plate forms for basics learning which is best for start a Oracle DBA and Apps DBA, i am waiting for you kind replay and quick reply is appreciated
@Ehsan,
Read on Architecture, Installation, Configuration, Patching and Cloning of EBS 12.1/12.2
Free documentation is at http://docs.oracle.com/en/applications/?tab=3 , We are starting new Apps DBA batch in August 2015, so if you want Training with Lab exercises and dedicated machine then you can join that .
Reply[…] started blogging 9 years back with first post as How to become Oracle Apps DBA (back then it was 11i) and with 225 comments, this […]
ReplyHi Atul,
Thanks for your effort.I am working as a linux admin and am i want to learn oracle dba and oracle apps dba as well.i heard that oracle rac dba also in demand.Please suggest me that can i learn oracle dba as well oracle rac.
Need your suggestion please.
ReplyHi Arif for RAC , I would suggest you first learn Oracle DBA and then enhance it to RAC .
You can learn Oracle Apps DBA in parallel or separately then Oracle DBA . We are starting new batch of Oracle Apps DBA Training on 8th of August http://k21technologies.com/oracle-apps-dba-training and there is discount of 100 USD if you register by 4th of August. If you are learning Apps DBA then start with 12.2 as this is latest version . Check my latest post on same http://onlineappsdba.com/index.php/2015/07/15/how-to-becomelearn-oracle-apps-dba-r12-2-part-i/
ReplyHi Atul,
Thanks for the reply.Can you please tell me that if i change my career from linux admin to oracle dba it will not affect my career right? or linux admin + oracle dba skills will add more value to my profile.please need your advice here.
ReplyHi Atul,
Waiting for your advise.once you confirm i will register today.
ReplyYes It’ll be an added advantage for you and you’ll unlock new opportunities for you. For this training the pre-requisite is basics of linux so you can proceed to enroll yourself for this training and our support team will be here to support you. We’ll also share Apps DBA interview Questions with you that you may help you in cracking interview.
We’ll also provide you dedicated machine to practice hands-on that you do using our step by step instructions and also recording of sessions for next one year that you can replay to get more clarity on concepts.
To register please follow: http://k21technologies.com/oracle-apps-dba-training
ReplyI have good knowledge in Oracle SQL, PLSQL and planning to learn Oracle Apps DBA.
Can you please guide me. and shall I learn Apps DBA without an Oracle DBA?