|
| Upgrade Oracle Apps 11i with Database to 10g R2 |
| Thursday, August 31, 2006 |
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
This is in continuation from my previous blog on 28th August about upgrading database for Oracle Apps 11i. If you have not seen previous update on overview of DB upgrade for Apps 11i you can Click Here
Upgrading a Oracle Apps 11i Database is Upgrading Usual 10g Database + some additional steps which are specific to Oracle Applications 11i. So if you have already done a database Upgrade you simply need to follow metalink note # 362203.1
Database upgrade is Two Step process: First Upgrade your software i.e. your files under Database $ORACLE_HOME to provide new executables .
How to upgrade software from 8i, 9i or 10.1 to 10.2 just go to directory where you have downloaded 10.1.2.0.2 database & go to Disk1 & execute ./runInstaller . This will start Universal Installer & then you have to choose different Oracle_Home to install 10.2 software . (Check oracle database upgrade guide at http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14238/preup.htm#i1007718 ) After software Installation you have to install software for companion CD in above ORACLE_HOME i.e. one for 10.2 only.
Why I need to Install companion CD separately, I never did it earlier ? Oracle recently started shipping Ultra Search as part of companion CD which earlier used to come with database software only Apply 10.2.0.2 patch 4547817 on top of 10.1.2.0.1 base release. For instructions on How to apply patcheset 10.2.0.2 check ReadMe of patch & you again have to apply it via OUI Upgrade database Metadata Once software is upgraded you have to upgrade Metadata and option you have is via executing sql's mentioned in upgrade guide or dbua ( database upgarde assistance tool ). Oracle Universal Installer while upgrading software also prompt you to upgrade database while upgrade software. Depending on your comfort you can choose method to upgrade database. I prefer using manual method i.e. via upgrade sql files. Now apart from upgrading database there are some pre upgrade & post upgrade steps specific to oracle applications 11i & follow them as mentioned in metalink note # 362203.1 some are option & some are compulsory . I want to discuss Native Compilation in Oracle 10 g database but because of time constraints I will discuss it some other time.
From now onwards slowly I will move on Advanced Apps DBA tasks like
Adding extra Node in Applications 11i
Implementing SSL with Apps 11i webserver
Disaster Recovery Implementation
Configuring 10g Application Server with E-Business Suite 11i
Don't forget to leave comments and if you have any doubts in Apps 11i mail me at atul_iiit@yahoo.com or post here as comment.
Atul Kumar
Oracle Apps DBA |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 6:39 PM
  |
|
|
|
| Oracle Apps DBA Preparation Cloning 11i |
| Wednesday, August 23, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Now I assume that you are familiar with
Overview & Architecture of Oracle apps 11i
Installation procedure of oracle apps 11i
File System & Various TOPs in Apps 11i
How to Start Stop various Services in Oracle Apps 11i ( like Apache, CM, Report, Apps Listener, Database, DB listener )
If not first please go through following topics to familiarize yourself with Oracle Applications 11i
http://becomeappsdba.blogspot.com/2006/08/apps-11i-dba-preparation.html
http://becomeappsdba.blogspot.com/2006/08/oracle-apps-dba-preparation-ii.html
from Today I will take tasks / roles which Apps 11i DBA perform like cloning patching , configuring using Autoconfig. So today lets start with basics of cloning .
In order to fully Understand cloning basics , I suggest you go through Chapter 6 , Cloning
at http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/11iconcepts.pdf
Go through page (75 - 78) just four page to understand basics of cloning in Applications 11i . Various topics in that are Cloning Tools, Cloning Options , Rapid Clone Operations. This will give you overview of cloning oracle apps 11i steps . If you have any doubts in over view of cloning apps 11i instance , leave your comments .
In next post We'll take closer look at Cloning , rapid clone , difference between rapid clone & Autoconfig.
For those who want to know about JVM in apps 11i , you can check at my site at http://teachmeoracle.com/jvm.html (If you ever encounter JavaLangOutOfMemory error or want to know where are JVM logs or how to increase number of JVM's or JVM related configurations in Oracle Apps 11i then visit http://teachmeoracle.com/jvm.html
Atul Kumar
Oracle Apps DBALabels: apps, cloning |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 1:57 PM
|
|
|
|
| Apps 11i DBA preparation |
| Saturday, August 19, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
As I am getting lots of request for how one should prepare for Oracle Apps 11i DBA in
Technical domain including Sysadmin, I am summing up things you should learn / study in
order to understand E-Business Suite 11i . The topics mentioned below, which you should
read in order to become apps DBA or as part of your Oracle Apps DBA training will include
roles & responsibilities of oracle Apps DBA.
1. Apps Architecture
This is key topic & you should be very clear about Oracle Applications/E-Business Suite
11i components & Architecture. This is base of your knowledge & if you are not clear about
various components & uses it will be quite difficult in learning Apps.
Where to find Oracle Applications 11i architecture in Ocean of oracle Application
technical documentation. Well I agree with you go straight to http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/11iconcepts.pdf and go through chapter 1 (Page 13 to Page 32 Just 20 Pages)
2. Installing Apps 11i
Next point in apps dba training is Oracle Apps 11i Install using Rapid Install preferably on Linux/Unix
Where to find Rapid Install 11i Oracle Apps Guide This is guide by Oracle http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/r115102ins.pdf for a start Chapter 1 & 2 are enough page 13 to p 63 is enough to understand Installation)
Where to find Discs / software for Oracle Apps 11i E-Business Suite : You can download it via http://edelivery.oracle.com or order it via your Metalink account . Once you got CD , please do install Apps atleast once in order to understand & to familiarize your self with Oracle Applications
3. Apps 11i File System/Software
Once you installed applications 11i using above guide on Unix/Windows/Linux software then login as Operating System User & check directories while going through document
http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/11iconcepts.pdf Chapter 2 Applications File System (P39- 48) very important in understanding Database Server & Application Server Tier & various tops like DATA_TOP, ORA_TOP, APPL_TOP, COMN_TOP, AD_TOP....
If you know your applications 11i File system you know where to find particular component files & logs .
I think this is enough for keep you going for 10-15 days , pay as much attention you can on these basics as these are building blocks of your careers as Apps DBA. For remaining tips on how & from what to prepare next like AD Utility(patching, adsplice,..), Cloning ... I'll update you tomorrow .
Now you can raise your doubts/questions/issue in forum at http://teachmeoracle.com/forum (Dedicated to Apps DBA's)
Atul Kumar
http://teachmeoracle.com/interview.html |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 2:28 PM
|
|
|
|
| Patching Commonly asked questions |
| Tuesday, August 15, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Where can I find patch log files ? ( Check http://becomeappsdba.blogspot.com/2006/08/oracle-apps-patch-basics-ii.html)
What are different type of patches ?
http://becomeappsdba.blogspot.com/2006/08/oracle-apps-patch-basics.html
How to check if a patch is applied ?
Check table ad_bugs (bug_number ) or ad_applied_patches table .
What two tables adpatch creates when you apply or run adpatch session ?
FND_INSTALL_PROCESSES , AD_DEFERRED_JOBS
Is uninstalling apps patch applied using adpatch supported ?
No (Supported version is to restore from backup )
How to apply a patch when adpatch is running & you come to know that a patch needs to be applied before that patch ?
Broad level steps are Shutdown workers using adctrl, backup above two tables, backup .rf9 files, Drop these two table mentioned above, apply patch which you were suppose to apply , restore .rf9 files , restore two tables which you backed up earlier & restart patch again .
Whats defaults file ?
This is to apply patch non interactively more Coming soon ( i 'll post on this soon )
Few methods to reduce patch timing ?
Use defaults file, merge patches & apply as single patch, use high batch size depneding on your system resource, select carefully number of workers while running patching, if upgrade use staged appl_top ( more coming on this in future, please note staged appl_top is different from shared appl_top )
How to control workers ?
using adctrl .
If you encounter any questions related to adpatch and not clear about it, please mail it to me & I will get back to you with in 48 hours . Mail me at atul_iiit@yahoo.com
To know more about Oracle apps 11i Webserver visit my site http://teachmeoracle.com/apc.html
Oracle Apps DBA |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 9:51 PM
|
|
|
|
| ADPATH Options |
| Saturday, August 12, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Now since you know basics of patch (If not read my previous posts, its quite important to know patch basics before starting to apply patch )
By now you might know that you use utility adpatch to apply oracle apps patch and adadmin, admrgpch, adctrl to manage/control your patch . Depending on you AD version (i.e. AD.H or AD.I.1 .. AD.I.4) you will have different options available with adpatch . Otherwise you can use interactive option to apply/see basic options (Interactive means adpatch will ask you required field values by displaying some suggestions to you)
First lets discover some major options available with adpatch.
adpatch option=[option1,option2, ....optionN]
Below is option value with explanation
options=noautoconfig If you are applying number of patches out of which 4-5 patches run autoconfig then use this option & run autoconfig in last patch or manually (This will save your patching timing , first patch performance tip )
compiledb(def) or nocompiledb Use no compiledb if you have multiple patch then compile database objects in last patch
compilejsp(def) or nocompilejsp Use no compilejsp if you have multiple patch then compile jsp in last patch
copyportion Tells adpatch whether to run commands normally found in a copy driver.
databaseporion Tells adpatch whether to run commands normally found in a database driver.
generateportion Tells adpatch whether to run commands normally found in a generate driver
hotpatch Tells AutoPatch to apply a patch regardless of whether the Oracle Applications system is in maintenance mode.
integrity Tells adpatch whether to perform patch integrity checking, which verifies that the version of each file referenced in a copy action matches the version present in the patch (There are overheads with this)
maintainmrc Tells adpatch whether to automatically maintain the MRC schema after running actions normally found in the database driver. The MRC schema is only maintained if the MRC feature is enabled
prereq Tells adpatch whether to perform prerequisite patch checking prior to running patch driver files that contain actions normally found in the copy driver. (With lateset AD patch , default behaviour is changed from prereq to noprereq)
forcecopy The forcecopy command copies the files in a patch to the Applications file system without comparing the version number of the patch files with existing files
Since you know basics of apps patch & options available Next I will tell how to apply patch & fix errors if any .
If you want to read about Concurrent Managers in Oracle Applications visit my Site at
http://teachemeoracle.com/cm.html
Oracle Apps DBA
Happy Learning
Happy Apps Learning |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 2:57 PM
|
|
|
|
| Oracle Apps PATCH Basics II |
| Friday, August 11, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
As Oracle Apps DBA patching is quite basic thing you do regularly so lets continue with basics . If you have not gone through my previous posts please do so now as its quite important to through basics .
Apps patches are buldled somthing like p123456_11i_Unix.zip where p menas patch next few digit are patch number Unix is platform or OS on which this patch can be applied.
When you unzip a patch you will see some files types which I am explaining here
readme.txt - This file contain steps to spply patches, List of Prerequisite patch should be there on apps Instance (If not apply that patch )
cXXXXXXX.drv c stand for copy driver file , this copies patch content to respective patch location , driver is like bus driver which provides instruction on work adpatch need to perform.
dXXXXXXX.drv d stand for Database driver & contain content related to database like creating packages, tables, adding column....
gXXXXXXX.drv This contain files related to forms , reports, graphis or messages
uXXXXXXX.drv Sometime these three types of files are bundled together into single driver file called Unified driver file
So now you know which type of driver file to apply where ? its common sense if this is d driver you just need to apply once on concurrent manager tier and c & g on all tiers as database is single & if you run it once its enough . If you applied it again by mistake its no harm & will not cause any issues . Similary c & g you need to apply from all tiers , because c will copy your content & g will generate message files.
If you are not sure where to apply what just apply it on all tiers & depending on your context file in APPL_TOP/admin/SID_hostname.xml it will apply where to install what by checking xml tag TIER_ADFORMS , TIER_ADWEB , TIER_ADADMIN open your xml file & see these parameters are there or not ( For xml file your system should be Autoconfig enabled ) all system after 11.5.8 by default are autoconfig enabled . For more info on Autoconfig check
http://atul-oracle.blogspot.com/2006/07/autoconfig-in-nutshellwhich-is-most.html
Happy Learning
Oracle Apps DBA |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 2:27 PM
|
|
|
|
| Oracle Apps Patch Basics |
| Thursday, August 10, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Lot of you asked me about patch basics & even I myself was confused with Apps Patches terminology initially as I used to hear family pack, mink pack, maintenance pack, patchset, security patch and lot many other type of patches so I thought of introducing you with patching terminology & all these buzz words oracle uses to impress people like you & me.
But before that if you have reached to this post first time & haven't read all my previous post I'll recommend you to go through them as they are basics & very important to understand what I am putting here & in future.
So now lets start with patch basics / terminology
Standalone/Oneoff patches : This is used to define patch created to fix single/particular problem.
Mini Pack : This is group of oneoff patches for a particular product like INV, GL, AP and named like 11i.GL.E ( means this group of patches contain fix for 11i GL product (General Ledger till time E is released ) This is cummutative which means it will include 11i.GL.A, 11i.GL.B ....11iGL.D till 11i.GL.E earlier in 10.7 it used to called as patchset.
Family Pack : Group of mini packs in one family buldeled together is called as family pack. they are usually named as 11i_PF. Few example of falilies are SCM ( 11i.SCM_PF.G ), ATG ( 11i.ATG_PF.H ) _PF indicate Product Family Pack
Maintenance Pack : Group of family pack together is called as maintenance pack. So if you say your Verison is 11.5.10 then its maintenance pack 10 ( 3rd digit is maintenance pack ) so
To wind up things you can say
few one off patch make mini pack , few mini pack related to same family bundeled together as family pack & all family pack fixed till that time are bundeled in Maintenance pack .
Oh wait I forgot to tell about NLS Patch ( When you have more than one language , like english & arabic or french .. ) then apart from normal patch you have to apply patch for specific language Installed in your system called as NLS patch ( What is NLS or MLS coming soon ..)
Next I am going to cover patch basics part II
Don't forget to leave your comment about what else you want to hear about .
Apps Learning
|
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 11:44 AM
|
|
|
|
| AD Utilities for Apps DBA |
| Wednesday, August 09, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
From now to next few sessions I will be discussuing very important product from DBA's prespective i.e. AD also called as Application DBA ( ;-) I think its named AD after Application DBA )
AD_TOP is product in Aplication which is under directory APPL_TOP/ad/11.5.0 ( If you are not familiar with TOP please read my previous post about TOP's )
This top containin Utilities & program code which is very frequently used by DBA's . So where are these utilities or program in file system ? (I think you all know but for begineers its in AD_TOP/bin )
Lets see one line definition of each
AD Utility ?
AD Utilities are a group of tools designed to install, upgrade, maintain, and patch applications.
ADPATCH ?
is a utility that is used to apply individual patches, mini-packs, or maintenance packs to an Oracle Applications instance.
ADADMIN ?
AD Administration (adadmin) is used performs maintenance/administration tasks on an Oracle Appls Instance. Task associated with adadmin are divided into two broad categories database and file system task.
ADCTRL ?
Utility to determine status of worker (started by adpatch , adadmin or other ad utility) and to control ( restart/drop/skip) workers.
ADRELINK ?
Used to relink apps executables with product libraries , if some library defination is changed or executable is corrupted.
ADMRGPCH ?
To merge different patches & create single patch . This is helpful when you have too many patches , you can merge them & apply in one shot.
ADCLONE ?
Utility to clone Insatnce from Test to Prod , Vice Versa
ADCONFIG ?
To configure different components in Aplications like changing port number or domainname or incresing number of JVM's
ADIDENT ?
utility to find version of a file in oracle applications (Identification )
ADLICMGR ?
To license a product in applications , you might have license to use only 10 products initially then later decided to use 5 more so license them first by this utility
ADSPLICE ?
You add a product in application, by default you might have 90-105 ( may be more ) products like AP, GL, AR and now oracle released one more product so add this product using this utility .
This is overview & usages of each application DBA Utility , now in next topic I will start with patching & how these utilities are used & options available with them . If you are amazed/confused whats this patching donot worry I will explain in deatil but if you are a DBA you might already be knowing patching & might have applied coupel of database patches using opatch now lets use ADPATCH to apply application or apps patches.
Donot forget to leave your comment & feedback .
Oracle Apps DBA / Apps training |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 2:36 PM
|
|
|
|
| Apps Architecture |
| Tuesday, August 08, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
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 |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 9:29 PM
|
|
|
|
| Install Oracle Apps |
| Monday, August 07, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
 This Post will Contain broad level steps of Oarcle apps Installation , this is just for Overview or High level step for Installing Apps. For details & exact commands refer to Oracle Installation Guide mentioned at bottom of this post .
Pre Instalaltion Steps
Check System requirement:
Software Requirenet : like ar, ld, make, gcc, make, Xdisplay - (Unix), MS C++, MKS
Toolkit (Windows)
CPU : It depends on Size, no. of Users ... ( For Test Installation don't worry)
Memory : SGA, Concurrent Users ( Usually 2GB should be enough for testing)
Disk Space : 26 GB Application Tier and for database Tier (35GB Production DB,
65 GB for Vision DB )
Once prechecks are done create User ( Single User or Two user ), with Single user will install both application tier and database tier and for Two user user1(oramgr) will install & own Database tier & user2(appmgr) will install & own Application Tier. (If you don't knwo what is application or database tier please go through my previous post).
Install MS XML Parser 3.0 Service pack 4 (Only if you are installing Apps in Windows)
Start Apps Installation
go to nstallation software ( either mounted on filessystem or Via CD ) & run rapidwiz ( For windows its rapidwiz.cmd)
Use rapidwiz -restart (If your Installation fails anytime in between , Good feature which Oracle incorporated quite late ;-) lucky you are that this option is there ) Installer will ask you some questions regarding system answer them
For Installation Step by Step screens refer Guide mentioned at bottom of this post , chapter 2 page 30 to 57 ( Just 27 pages , Hope its not too much :) )
Post Installation ( Though these are not required for Testing How apps Installation work)
few things which you might want to do after Installation
Update PL/SQL Log and Out directory
Configure DB Init parameter
Login to Apps
Download jinitiator on client PC ( It will automatically prompt to install on client machine when accessing forms)
For full Installation steps please refer guide at http://download-east.oracle.com/docs/cd/B25516_08/current/acrobat/r115102ins.pdf So this sums up your Apps Installation , If you have any queries / doubts please leave comments or drop a mail at teachmeoracle@yahoo.com Apps Installation Training
|
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 2:32 PM
|
|
|
|
| What's Different TOP's in Application 11i |
| Friday, August 04, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
 If you want to learn apps dba or want training in apps dba and going through this documentation you might be confused to see again & again that everybody is talking about & its quite difficult to unserstand any topic without knowing what the hell is different tops like APPL_TOP , COMMON_TOP or what eaxctly is TOP ?
For me TOP is nothing but top level directory & preceded by related software . So TOP is top level directory in file system or oracle 11i software .
If you have done 11i or oracle application Installation by now ( if not please go though my training for apps dba in my previous posts) Oracle Installer Installs Apps 11i in DB Tier & Application Tier : so lets take Application Tier you will see three directories under your base Installation directory, these diretories are APPL, ORA & COMN (Check pic. at left top of this page) so directory APPL is called as APPL_TOP i.e. top appl directory where files & directories related to different Application ( like GL General Ledger, PO Purchase Order..) exists. If You are DBA you can correlate it with your Oracle database software installation (I know after reading this example you will say its weird but believe me thats how understood it initially , ORACLE_HOME can be called as ORA_TOP , network directory you can say TNS_TOP )
Under ( ORA_TOP ) you will see diretcory related to oracle home , there are two oracle HOME's in Application Tier 8.0.6 for Forms & Reports , iAS for 9iAS acting as web server)
COMN_TOP will contain files & directories which will be used commonly by all components ( Isn't this simple to understand )
similarly
IAS_TOP is top files/directory under ORA_TOP/iAS I hope it might be clear to you now if not donot worry it will be more clear once you start working as Apps DBA.
I am attaching few screenshot of other mount points ( Courtsey oracle 11i concepts guide , below is location if you want to read .
http://download-uk.oracle.com/
docs/cd/B25516_08/current/
acrobat/11iconcepts.pdf ( Add these three lines before putting in to browser , I have not put it in single line as it breaks my page layout )
So In this guide you will find few more screenshot of different TOP's , Go through Chapter 2 , Just 13 Pages ( 13 unlucky number for someone but if understand this chapter , it can be very lucky for you in your Apps DBA Career.
So here I conclude my TOP's Section , Please don't forget to leave feedback & what you want hear next.
You can find some comanies on right side or top of this page who might be looking for Apps DBA , visit them by clicking & go to Career section to look for Apps DBA opportunity.
Happy Learning
Learn Oracle Apps DBA
Free Apps DBA Training |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 7:05 PM
|
|
|
|
| Startup Shutdown Apps Services |
| Wednesday, August 02, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Startup / Shutdown Apps
In our next topic in learning Oracle Apps DBA , this post covers startup & shutdown of Oracle Application DBA
As you are aware by now there is Database Tier ( Database & DB Listener ) and Application Tier ( WebServer, Forms, Reports, Concurrent Manager, Discoverer, Apps Listener, OnetoOne Fullfillment Server )
Order of StartUp of Services Should be
First DB Listener, Database & then Application Tier Services
Order of ShutDown of Services Should be
First Application Tier Services then Database & DB Listener
Database Startup/Shutdown Scripts
Depending on your AD Version these will be in ORACLE_HOME / appsutil/scripts /SID_hostname
addbctl.sh database startup shutdown script
addlnctl.sh database listener Script
Where
AD is for Application DBA
DB is for database
DLN is database listener
CTL is control
Isn't this easy to remeber ( Thanks to Oracle for naming convention)
-----
Application Tier Startup/Shutdown Scripts
Depending on your AD Version these will be in
OAD_TOP/admin/scripts/ SID_hostname
adalnctl.sh Apps Listener Control Script
adapcctl.sh Apache/Web Server Control Script
adcmctl.sh Concurrent Manager Control Script
addisctl.sh Discoverer Control Script
adfrmctl.sh Forms server Control Script
adrepctl.sh Report Server Control Script
adstpall.sh Stop All Middle/Application Tier
adstrtall.sh Start All Middle/Application Tier
Where AD & CTL you already know now :) isn't it
adl stand for Apps Listener
apc stand for Apache
cm Concurrent Manager
dis Discoverer
frm forms
rep report
Do you know whats Use of Apps Listener ? Check else I will post it in future post .
Check what Advertisers has to say on your right side of page .
Learn Oracle Apps DBA
Free Apps DBA Training |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 8:59 PM
|
|
|
|
| Oracle Applications Request Flow |
| Tuesday, August 01, 2006 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Now since you know Basic Overview of Oracle Applications / apps 11i and Installation (If not read my previous posts) . When user makes a request how request flow across different component in E-Business Suite or Oracle applications .
By now you might be aware of different Services/Component in Oracle apps I repeat them here these are ,
1. Oracle Web Server ( Apache, Jserv, plssql ) IAS_ORACLE_HOME 9iAS, Ver. 10222
2. Forms Server ( 8.0.6 ) ORACLE_HOME
3. Report Server ( in side 8.0.6 ORACLE_HOME)
4. Concurrent Manager for Batch or Individual Job Processing
5. Admin Server ( These are used for application dba job like patching , cloning & lot more )
6. Database Server
A) So when User makes a request from browser by typing URL like http:// hostname : port so port number they mention is WebServer Port, request hit to Oracle WebServer ( these requests are recorded in logs where wait for next post )
B) Webserver checks that with http request there is no cookie attached (Cookie is message given by WebServer to Web Browser to identify client) so user is new & it passes login page to User .
C) User types his Username Password in login window & clicks submit button
D) Webserver checks that username and passwords need to authenticate against database FND_USER table , so it needs first some user to check client's username password in database . Guess which username password it uses ?? ( GUEST/ORACLE have you ever noticed why this user is there , Hope you know it now it Uses Guest User to autenticate your user in database )
E) Once user is authenticated its check against FND_RESPONSBILITY..(Confirm again , not sure table name) for Authorization about users responsibilities & assigned responsibilities are presented back to user.
F) Now these responsibilities are of two type Self Services(served by Jserv/Servlets) or Core Applications Server by Forms Server .
G) If this is Core responsibility , Apache transfers request to Forms Listener (Listening on Forms port, I will cover how to check Forms Port in my coming posts ), From here request is on Sockets (May be on forms servelets depending on forms config. ) which is persistense connection. From here onwards Client talks directly with Forms Server in forms session and if Client requested some data, forms server makes database connection ( How ?? using tnsnames.ora in 806 HOME or using dbc Database Connector file in FND_SECURE_TOP or wdbsvr.apps in Apache/modplsql/cfg ?) Post your answer in comment section, you can do it as anonymous user without login as well
H) If User selected Self Service Responsibility like iProcurement, iRecruitement.., Apache forwards request to mod_jserv and request is fullfilled by jserv_component.
Have you ever noticed why webserver donot ask client to login again until session timeout ??( I know you know answer now its because of cookies as User have valid cookies , try deleting cookies from browser & see Oracle Apache asks you to relogin .
I) When your webserver tries to connect to database for plsql or any other type of connection it asks mod_pls to fulfill request but where is this connection information stored ? ( dbc file or wdbsvr.app file or somthing else ? )
J) Users submits his requests for batch processing or somthing else ( Gather Stats done by Sysadmins or Apps DBA's) these kind of requests are fullfilled by Concurrent Manager ( More about CM, including CM tuning still to come in future )
G) When user want to see reports of all these things request is being forwarded to Reports Server .
You as Sysadmin or Oracle Apps DBA need not to worry how this request transmission happens from one service to another , this is transparent to you me or User . ( Let Oracle do this behind the scene ) You should know request flow as this is most crucial during Troubleshooting (I'll cover in future posts ) to pinpoint in which compnent issue is & where to look for .
If you like this post please tell it to your other Apps DBA friends & Other budding Oracle Apps DBA's . Please don't forget to leave comment & for Advanced Apps DBA , WebServer configuration file system & configuration files look my post at http://atul-oracle.blogspot.com
Learn Oracle Apps DBA
Free Apps DBA TrainingLabels: apps |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 8:32 PM
|
|
|
|
|
|
