Apps Architecture

This Topic is quite important and I recommend you to go through this thoroughly.
First I want to discuss terminology which you will encounter here & in most of Oracle Documentation.

Server – is a process or group of processes and provides a particular functionality/service For example, Database Server listen and process database requests, similarly Web Server listens for and processes HTTP requests.

Tier – is a logical grouping of services, may be on single machine or spread across more than one physical machine. For Example, Middle Tier in Oracle apps consist Form,Web,Report…Services. Forms & Report can be one machine 1 & Web Server can be on machine 2, still they will be part of same tier called as Application Tier or Middle Tier.

Node – is referred as Machine, Each tier may consist of one or more node and each node can potentially have more than one tier.

Desktop Tier – Oracle Applications/E-Business Suite is built on three tier Architecture with first Desktop Tier ic client machines accessing applications via browser(HTML based Self service applications) or Java Applet(Jinitiator) for Form based interface.

Application/Middle Tier – Second is Application Tier also called as middle tier consists of WebServer Forms, Reports, Concurrent processing, Discoverer and Admin Server. I suppose its known as Middle tier because it lies between our desktop & third tier called database tier.

Database Tier – Third is Database Tier contain Orale database server which store all your application data. I am sure if you are DBA you know it 🙂

About Architecture of Individual Component like , Web Server, Form Server …. I will cover in my future posts.

Now you can raise your doubts/questions/issue in forum at http://teachmeoracle.com/forum (Dedicated to Apps DBA’s)

Happy Apps Learning .
Oracle Apps DBA

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

41 comments
Anonymous says August 9, 2006

Very helpful. Thanks and keep the good work.

Reply
Anonymous says September 20, 2006

Outstanding and perfectely timed , as many DBA’s are desperately looking for precise and up to mark contents and you have kept exactly those here .

Reply
Atul Kumar says September 20, 2006

Thanks a lot.
Could you please leave your name as well as its good to know everybody here .

Shoot a mail on topics which you don’t see here & want to hear about in Apps.

Atul

Reply
muralidhar says October 4, 2006

hi this is fine

muralidhar

Reply
Anonymous says November 27, 2006

Nice blog for Oracle Apps DBAs.

Regards,
Sabdar Syed,
Oracle Apps DBA.

Reply
Atul Kumar says November 27, 2006

Thanks a lot .

Regards
Atul Kumar

Reply
Anonymous says January 31, 2007

I have a doubt here. While sharing ans app tier, whats the expected behaviour? will all the services come up on both the nodes if i have enabled all the services on both the nodes? will there be 2 diff web entry points???

Reply
Atul Kumar says January 31, 2007

Hi Anonymous,
If you have two middle tiers (on two servers) you will end up having two web entry & last installed will be final web entry stored in database.

In order to overcome this problem you have to use load balancer & use virtual host as webentry URL

Do let me know if you have any further doubt. Check implementing HTTP hardware Load balancer to understand it more

Reply
Anonymous says February 2, 2007

Oh… so if suppose i am enabling all the services on both nodes of a 2 node installation, then both the login urls should work ideally….or only the one where autoconfig was run recently will work… please clarify

Reply
Atul Kumar says February 2, 2007

Yes both will work but if you shutdown services on middle tier installed last , forms won’t work as ICX forms launcher at site level will point to last installed middle tier

Atul

Reply
adusumilli_nitesh says February 13, 2007

wow..that was terrific..keep up the good work

Reply
Atul Kumar says February 14, 2007

Thanks Nitesh

Reply
Shekinah says February 26, 2007

Hi Atul,

Your site is really very helpful. Wow! Really good work.
I was working as an Apps DBA Oracle India. However, currently for 6 months I have’nt got the right job as an Apps DBA in another country just because people ask for certification here and its too expensive for me. i wonder how i’ll find my way thru this. But, this site of your gives me lots of information.

Thanks,
Shika.

Reply
Atul Kumar says February 26, 2007

Shika,
Thanks a lot for your comments & feedback.

If you wish to move out from India to work in other country , I think biggest challeneg is to get work permit for specific country .

If you wish to come to UK I will share my experience & things one should do start here independently . Stay tuned

Atul

Reply
Shekinah says February 27, 2007

Atul,
Thanks for a prompt response!! India is a very forward with IT-Jobs and no doubt anyone will get a job there. However, I have a residence visa and have moved to UAE. So, searching for an apps job right here currently. Thanks for being kind in offering me your suggestions. Indeed every post of yours is pin point “CLEAR” and helpful.

~Shika.

Reply
Anonymous says March 6, 2007

Hi Atul,

Is it possible to configure TAF(RAC) in 11i Apps Env.

Thanks & Regards,
ASD

Reply
Anonymous says March 6, 2007

Hi Atul,

I have very less exp as an apps dba as compared to you but would like to know is it possible to configure TAF(RAC) on 11.5.10
Thanks for the help

Regards,
ASD

Reply
Atul Kumar says March 7, 2007

Hi ASD,
Quite good question , We can configure TAF for 11.5.10 with RAC for database & another middle tier for application tier but that is not truely transparent as exisitng used will definately disconnected & has to reconnect but I suppose oracle might improve this on R12 which are with OC4J where user sessions can be transparently failed to another OC4J & another node if DB goes down

Reply
Anonymous says March 14, 2007

are u aware of AD features like java_worker,code_level,schema_swap etc???could you please let me know what are these and why are they used?
what would happen if we will enable or disable these features?

Reply
Anonymous says March 16, 2007

i am waiting for your reply on ad features…

Reply
Anonymous says April 2, 2007

Excellent site for Oracle Apps DBAs keep it up.
Regards,
RAF
Oracle Apps DBA
Warwickshire County Council

Reply
Anonymous says April 9, 2007

Atul,

I have to configure failover for dbnode which is on a package hosted on a VNC cluster of four servers. I have run adfgclone and have used the virtual hostname for this. But when I try to connect to database using applmgr login it says ORA-12224: TNS:no listener.
Please help.

Regards
Venu

Reply
Atul Kumar says April 9, 2007

For any issues raise them in forum at http://teachmeoracle.com/forum

Reply
Anonymous says July 8, 2007

Mr.Atul

All your effort makes so many people life brighter. Thanks.

presently we have two node installations for oracle apps ebusiness suite

apps/db server running in sun solaris / 11.5.7 /dbs 8.1.7

we are planning to create a new environment as mentioned below.

apps – os linux – apps 12i
db – sun solaris – db 10g rel2

how to go about this setup and any documents we can follow as step by step to complete this project.

vidya

Reply
Atul Kumar says July 8, 2007

This can be achieved by Upgrading database to 10g and apps to R12.

For upgarding database in preperation to R12 visit

http://becomeappsdba.blogspot.com/2007/01/oracle-r12-upgrade-from-11i-database.html

For full R12 Upgarde visit

http://download.oracle.com/docs/cd/B40089_05/current/html/docset.html

Oracle Applications Upgrade Guide: Release 11i to Release 12 (zipped)

Reply
Ahmed Khan says August 27, 2007

Hi Atul.

I am Ahmed Khan working saudi Arabia this site is really very good.

Thank u

Reply
Ahmed Khan says August 27, 2007

Hi Atul.

I am Ahmed Khan this site is really very good.

Reply
Atul Kumar says August 27, 2007

Thanks Ahmed

Reply
Anonymous says September 6, 2007

Hi Atul

I am having 120GB external USB Harddisk can i install Linux and oracle apps in that?

Ahmed Khan

Reply
Atul Kumar says September 6, 2007

Yes you can install 11i Apps but not R12 Vision

Reply
Anonymous says September 10, 2007

Hi Atul

I am having Linux 4 CD’s so can i install Linux in virtual machine with cd’s coz i want to use Windows and also at the same time Linux and also i want to install oracle apps this all i want to do on Extrnal USB harddisk so can i?

Ahmed khan

Reply
Anonymous says September 11, 2007

Hi Atul

What file system should is use for External USB Disk so that i can use it on windows n also i need to install Linux.Actually 100 GB i want to give to Linux & oracle and 20 GB i want use it as my personal drive to keep my personal data.

Ahmed Khan

Reply
Anonymous says September 13, 2007

Hi

Please,Can any one one answer the above question.

Ahmed Khan

Reply
Atul Kumar says September 13, 2007

Use NTFS and for any issues/ questions raise them in forum at http://teachMeOracle.com/forum

Reply
sunil says September 22, 2007

really u blog help me a lot….i need
workflow for APPS user login in OAM

Reply
shahid ahmed says April 26, 2008

Thanks for the great sharing. Its really helpfull to us.

keep it up

Reply
SKG says September 14, 2008

Hi Atul,
Its a great website and nice modules too..

Can you please let me know the details of oracle how it executes queries.

Parsing and execution in detail,where it converts to machine code..if it does ??

Thanks

Reply
Ash says June 26, 2009

Hi Atul

Thanks for the brief intro.

When you will be explaining architecture of Individual Component like , Web Server, Form Serve. I read ist Chapter of 11i Concepts but i want to learn it conceptually. the way you explains…

Please post it soon if you have time.

Regards
Ash

Reply
Ash says June 30, 2009

waiting for your reply

Regards
Ash

Reply
parvathi says July 15, 2009

Hi Atul,

its really good and helpful
tones and tones of thanks
parvathi

Reply
Add Your Reply

Not found