Apps Architecture

Very helpful. Thanks and keep the good work.

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 .

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

hi this is fine

muralidhar

Nice blog for Oracle Apps DBAs.

Regards,
Sabdar Syed,
Oracle Apps DBA.

Thanks a lot .

Regards
Atul Kumar

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

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

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

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

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

Thanks Nitesh

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.

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

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.

Hi Atul,

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

Thanks & Regards,
ASD

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

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

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?

i am waiting for your reply on ad features…

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

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

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

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

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)

Hi Atul.

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

Thank u

Hi Atul.

I am Ahmed Khan this site is really very good.

Thanks Ahmed

Hi Atul

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

Ahmed Khan

Yes you can install 11i Apps but not R12 Vision

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

Ahmed,
Yes you can install it check

http://becomeappsdba.blogspot.com/2007/03/installing-vmware-linux-for-oracle-apps.html

http://becomeappsdba.blogspot.com/2007/03/install-oracle-enterprise-linux-on.html

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

Hi

Please,Can any one one answer the above question.

Ahmed Khan

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

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

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

keep it up

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

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

waiting for your reply

Regards
Ash

Hi Atul,

its really good and helpful
tones and tones of thanks
parvathi