Become Oracle Apps DBA

Default Forms connection mode in Oracle Applications R12 is "SERVLET" where as in Oracle Apps 11i default form connect mode is "SOCKET" So

What is difference between socket and servlet mode in Forms ?
What are advantages and disadvantages of each ?
Can we change default R12 forms mode from servlet to Socket ?

Oracle Form Servlet Overview in apps R12
------------------------------------------

i) In this mode, Java servlet handles communication between forms client(java based) and Oracle Forms Service (10g).

ii) All connection is via HTTP Server so there is no need to start form server and no need to open form server port on firewall between client machine and application tier.

iii) More secure as compared to Forms Socket Mode.

iv) Network traffic is more as HTTP protocol is more chatty so little bit network bandwidth hungry when compared with SOCKET mode

v) No additional certificate requirement during SSL implementation for application tier, single certificate will handle both forms & web connection.

How to change from default Servlet mode (in apps R12) to Socket mode ?
---------------------------------------------------------------------

Refer to Oracle Metalink Note # 384241.1 Using Forms Socket Mode with Oracle E-Business Suite Release 12

Are there any network overheads of using Forms in Servlet Mode ?
----------------------------------------------------------------

Metalink Note # 311091.1 Understanding the Network Overhead Of Forms Servlet Listener Architecture Compared to Forms Server, covers some interesting points w.r.t. network traffic

Advantage & Disadvantages of Forms Servlet Mode

----------------------------------------------------------
-- Simple SSL Configuration (as no separate ssl configuration is required for Forms as connections are via web/http server)

-- No port need to open to access forms in firewall

-- More secure method of deployment over Internet

-- Result in more network traffic because of HTTP is more chatty than socket (dedicated) so not preferred in WAN implementation.

Related Doc
----------------
http://www.oracle.com/technology//products/forms/pdf/p7listenerservlet.pdf (Oracle Forms Listener Servlet for deployment of Forms on Internet)

Question to readers ....

How will you identify if you are using Forms in Socket or Servlet mode in Oracle Applications 11i or R12 ? (leave your comments )

Labels: forms, r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 11:47 AM 11 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Start-up Shutdown Scripts in Oracle Apps R12

Sunday, June 10, 2007

This Post covers Start-up Shutdown scripts in Oracle Applications Release 12, If you wish to know more about Startup/Shutdown scripts in Oracle Apps 11i click here

Order of Startup Shutdown
--------------------------------------
As in Oracle Apps 11i order for startup is
A) Start Database Tier Services
--Start Database Listener
--Start Database
Then
B) Start Application/Middle Tier Services
-- adstrtal.sh

Order for shutdown in Oracle Apps R12 is
A) Stop Application/Middle Tier Services
-- adstpall.sh
Then
B) Stop Database Tier Services
--Stop Database
--Stop Database Listener

Database Tier Scripts in R12
--------------------------------------
For Database tier you need to start database and database listener. Scripts are located in Database_Install_Dir/db/tech_st/10.2.0/appsutil/scripts/$CONTEXT_NAME

- For Database
Use script addbctl.sh

- For Database Listener
Use script addlnctl.sh

or alternatively you can use
lsnrctl startstop listener_name (For Database Listener)
sqlplus "/as sysdba"
SQL> startup shutdown immediate

Middle/Application Tier Scripts in R12
-------------------------------------------------

Scripts for Application Tier services in R12 are located in "Install_base/inst/apps/$CONTEXT_NAME/admin/scripts"
where CONTEXT_NAME is of format SID_HOSTNAME

i) adstrtal.sh
Master script to start all components/services of middle tier or application tier. This script will use Service Control API to start all services which are enabled after checking them in context file (SID_HOSTNAME.xml or CONTEXT_NAME.xml)

ii) adstpall.sh
Master script to stop all components/services of middle tier or application tier.

iii) adalnctl.sh
Script to start / stop apps listener (FNDFS and FNDFS). This listener will file will be in 10.1.2 ORACLE_HOME (i.e. Forms & Reports Home)
listener.ora file will be in $INST_TOP/apps/$CONTEXT_NAME/ora/10.1.2/network/admin directory
(Mostly similar to one in 11i with only change in ORACLE_HOME i.e. from 8.0.6 to 10.1.2 )

iv) adapcctl.sh
Script to start/stop Web Server or Oracle HTTP Server. This script uses opmn (Oracle Process Manager and Notification Server) with syntax similar to opmnctl [startstop]proc ohs
like opmnctl stopproc ohs .

(In 11i this script directly used to call apachectl executable but now calls opmnctl which in turn calls apachectl. In 11i web server oracle home was 1.0.2.2.2 but in R12 its 10.1.3)

v) adcmctl.sh
Script to start / stop concurrent manager, Similar to one in 11i. (This script in turn calls startmgr.sh )

vi) adformsctl.sh
Script to start / stop Forms OC4J from 10.1.3 Oracle_Home. This script will also use opmnctl to start/stop Forms OC4J like
opmnctl stopproc type=oc4j instancename=forms

vii) adformsrvctl.sh
This script is used only if you wish to start forms in socket mode. Default forms connect method in R12 is servlet.
If started this will start frmsrv executable from 10.1.2 Oracle_Home in Apps R12

viii) adoacorectl.sh
This script will start/stop oacore OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to adapcctl & adformsctl) to start oacore instance of OC4J like
opmnctl startproc type=oc4j instancename=oacore

ix) adoafmctl.sh
This script will start/stop oafm OC4J in 10.1.3 Oracle_Home. This scripts will also use opmnctl (similar to above) to start oacore instance of OC4J like
opmnctl startproc type=oc4j instancename=oafm

x) adopmnctl.sh
This script will start/stop opmn service in 10.1.3 Oracle_Home. opmn will control all services in 10.1.3 Oracle_Home like web server or various oc4j instances. If any services are stopped abnormally opmn will/should start them automatically.

xi) jtffmctl.sh
This script will be used to start/stop one to one fulfilment server.

xii) mwactl.sh
To start / stop mwa telnet server where mwa is mobile application.

Log File Location for Startup Shutdown Services in R12
----------------------------------------------------------------------
Log files for startup/shutdown scripts for application/mid tier in R12 are in $INST_TOP/apps/$CONTEXT_NAME/logs/appl/admin/log
(adalnctl.txt, adapcctl.txt, adcmctl.txt, adformsctl.txt, adoacorectl.txt, adoafmctl.txt, adopmnctl.txt, adstrtal.log, jtffmctl.txt )

--Are you facing any issues in startup/shutdown scripts ?
--Should Oracle Create single script which should start/stop entire application including database ?

Labels: apps, r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 6:27 PM 2 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Unified APPL_TOP : Changed Feature in Oracle Apps R12

Friday, May 18, 2007

In today's post I'll cover on Unified APPL_TOP in Oracle Applications R12 which is different from separate APPL_TOP in Oracle Applications 11i. Unified APPL_TOP make more sense if you are using multi node Oracle Applications R12.

In Oracle Applications 11i , in multi node installation each APPL_TOP have its different name and files in each APPL_TOP will depend on type of Node (i.e. Forms Node will have fmx or forms related files where as APPL_TOP belonging to CM only node will have rdf or files required to run CM node)

Starting from R12, it will use Unified APPL_TOP which means all files required for all middle tier services are included in all nodes of Multi Node installation (irrespective of services running on that node)

What are few changes because of Unified APPL_TOP ?

-- During Cloning of multi node Oracle Application install, only one copy (any one appl_top) of Application Node files need to copied to target instance.
-- During Cloning of Multi Node to Single Node you don't have to merge APPL_TOP's in R12 as required in 11i .
--Services start/stop If you are using adstrtall.sh to start services on a node then it will start services which were configured to start during install on that node (You can still start a specific service even though it was not suppose to configure/start by calling startup script of that specific services).
To explain this better, lets assume you installed multi node R12 instance with Node 1 as Forms & Web Server where as Node 2 was installed with Concurrent Manager. Now on Node1 when you use adstrtall.sh script to start services as expected it will start Forms and Web services but unlike 11i, You can still start Concurrent Manager on Node1 by running adcmctl.sh
--FND_NODES From R12 all nodes will have Y against all services (For multi Node) in FND_NODES table.

More on R12 with upgrade overview and other new features coming soon....

Labels: apps, r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 9:32 PM 0 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Release Update Pack for Oracle Applications R12

Thursday, April 19, 2007

Oracle has released, Release Update Pack 1 (RUP1 / 12.0.1) for Oracle Applications R12 (12.0). Patch Number for this RUP is 5082400 (single driver u5082400.drv) which can be applied using AutoPatch (adpatch) for more information follow read me of patch.

Few things to Note:
1. If you use HR legislation, then update HR legislative data as post
install step of this patch (Follow Note ID# 145837.1)
2. Apply online help patch # 5240400
3. If you have Multiple Language on R12, install translated version of patch for each active language.
4. Following products have patches included in 12.0.1 (RUP1 for R12)
(AD, CRM, Financials, Financial Services, HRMS, Intelligence,
Procurement, Projects, SCM and Application Technology)

If you hit any issues while applying this patch, kindly leave a comment
for solution or How you fix so that this can be useful for others.

Related:
145837.1 Latest HRMS (HR Global) Legislative Data Patch Available

Labels: r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 7:11 PM 0 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Difference between Oracle Apps 11i and R12 (Technical)

Sunday, April 08, 2007

Based on high influx of mail from users requesting difference between Oracle Applications Release 12 and 11i , I decided to dedicate this post to outline few major technical difference.

Database:
Database Version in 11i (11.5.9 & 11.5.10) was 9i Rel 2 where as in Release 12 its 10g R2 (10.2.0.2)

Application Tier:
Tech Stack in Application Tier consist of iAS(1.0.2.2.2) & Developer 6i (Forms & Reports 8.0.6) but in Applications R12 it is build on Fusion Middleware (10g Web Server and 10g Forms & Reports)

Sub component in Application Tier
A) HTTP Server or Web Server in R12 is Version 10.1.3 which is built on Apache version 1.3.34. In apps 11i it is Version 1.0.2.2.2 built on Apache Version 1.3.19
B) Jserv in apps 11i is replaced by OC4J (mod_jserv is replaced by mod_oc4j)
C) Forms Version 6i in Apps 11i is replaced by Forms 10.1.2.0.2 in R12
D) Reports Version 6i in Apps 11i is replaced by Reports 10.1.2.0.2 in R12
E) JDBC version is changed from version 9 in apps 11i to version 10.2.0 in Apps R12
F) modplsql or mod_pls is removed from Apps R12 (What will happen to my mod plsql applications- coming soon* )
G) Java processes use JDK/JRE version 1.5.0 in R12 against JDK version 1.3.1 or 1.4.2 in Apps 11i
H) For various environment variable changes check below picture

I) New top INSTANCE_TOP added in Release 12 for configuration and log files

http://becomeappsdba.blogspot.com/2007/01/oracle-apps-r12-file-system-changes.html

If you think I missed any Technical changes in Release 12, Kindly leave a comment so that it can be useful to everyone.

Labels: apps, r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 9:50 PM 29 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Install Oracle Apps R12 on Linux VMWare

Monday, March 05, 2007

As promised here comes Oracle Applications R12 Installation on Linux Virtual Machine installed on my Windows Vista (You can try on XP or 2000 as well)

.

I purchased 500 GB USB hard disk from Amazon Western Digital 500GB "My Book" Premium 1C External Hard Drive USB2.0/Firewire - Retail kit and attached with my laptop for staging and installing Oracle Apps R12 .

Create an Staging Area

This step is not required but if you wish to install

Oracle Apps R12 for more than once its better to stage R12 software disk. This will also be helpful as you won't have to insert CD's manually during installation. Follow Page 29 or 1-13 of Oracle R12 Installation Guide to Create Staging Area.

Here is steps for creating staging on Linux
1. Verify you have perl version 5.0053 and higher (perl -v)
2. Run adautostg.pl from $StartHereCD/Disk1/rapidwiz/ (perl /../../.../adautostg.pl)
If you have downloaded Disks from edelivery this script is under zip file B42091-01_3of5.zip on Start Here Disk

For New Oracle Apps R12 Installation there are two options - Express Install & Standard Install (Express - Not much options available & it will do single user single node Install). Choose Standard Install for your customized configuration.
If you have selected Express Install you can't install it from root account , you have to use any other operating system account like oracle

Start Oracle Apps R12 Installation
To start Installation execute rapidwiz from startCD/Disk1/rapidwiz/ either from disk or from staging area if you have created one.

On Next two screen you have to accept license agreement & enter CSI number(type anything) and accept agreement.

In this screen you have option to select new configuration or an existing configuration (If this is a reinstall or from another instance or second node)

You have to select port pool , if this is first install on this machine then select any port pool else make sure ports are not conflicting with any other software. For me 3 is lucky number so I just picked it ;-) and Installation was successful for me)

In this screen enter database related configuration. I had to create base directory manually as it was erroring out for me.

Make sure users & groups you mention in this screen are already created on linux machine which you install (on VMWare).

Enter Application Tier Configuration on this screen . Notice Instance Directory which is new in Oracle Applications R12 which I am going to cover in future.

This screen will show you node information (Database Tier & Application Tier)

On clicking next , all prereq checks are made related to port availability, Host & domain name checks, file space .....

Fix related issues if any check fails .

This completes your setup task for installation & installer will prompt you to confirm Oracle Applications R12 Installation.

If you hit any issues during installation please raise them in forum at http://teachMeOracle.com/forum and Apps DBA Guru's will be there to assist you.

Labels: r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 8:44 PM 27 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Install Oracle Enterprise Linux on VMWare

Sunday, March 04, 2007

In last post at http://becomeappsdba.blogspot.com/2007/03/installing-vmware-linux-for-oracle-apps.html I discussed about Installing VMware on your windows machine which we will use to install virtual Linux machine on your Windows PC or Laptop. On this Virtual Linux machine, We will finally Install Oracle Applications R12 (Note that Oracle Applications R12 is not supported/certified on VMWare but you can install for testing purporse) .

In today's post I will install Oracle Enterprise Linux downloaded from eDelivery . Download first four CD's (32 bit) & unzip them on your windows harddisk. I unzipped them under "c:\Atul\Downloads\Linux" directiry & extracted iso files. Start VMWAre from Start/Programs Menu & select Machine which we installed yesterday. On Menu bar click on
VM -> Settings (Ctrl + D) Select CD-ROM & under Connection select Use ISO Image as mentioned in Picture.

Once you select first iso image & click on "Start This Virtual Machine" , it will start Oracle Enterprise Linux Install on your Virtual Machine.

Select Installation type as Server

You can select Automatic Disk Partitioning but if you want to partition as per your needs you can choose Manual Partition.

Enter Hostname for your machine, I selected my site name i.e. teachMeOracle.com

When it prompts for second CD , From VM -> Settings , click on CD-ROM and change location to second iso file and then for third CD. Make sure installation completes successfully. In next post I am going to cover step by step Oracle Applications R12 Installation on Linux Virtual machine which you installed just now on your windows PC/Laptop. Make sure you have downloaded R12 Disks .

Follow link Prepare for Oracle Apps R12 Installation

Labels: others, r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 9:10 PM 36 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Installing VMware Linux for Oracle Apps R12 Preparation

Saturday, March 03, 2007

In today's post I'll cover on Installing VMware on windows machine after that we will install Linux on windows Virtual Machine. Download VMware from http://www.vmware.com/download/ws and after downloading install it on your windows machine.

Download linux trail version from edelivery http://edelivery.oracle.com/linux

Select product as enterprise linux & Platform as x86 32 bit (almost all PC or laptops are 32 bit) ob 64 bit processor you can install both 32 or 64 bit linux but on 32 bit processor you can install only 32 bit software so select 32 bit . You have to download 4 CD's only.

Installing VMware on windows

Enter location of VMware Installation

This step completes your VMWare Installation on machine. Next lets configure Virtual Machine & later we will install Linux on this Configured Virtual Machine.

Configuring Virtual Machine

Type any name here , Initially I gave machine name as Machine1 which I later changed to TeachMeOracle.com . You can give any sensible name to your Virtual Machine.

I defined 100 GB for Oracle Apps R12 Installation as I am planning to install fresh database (without Vision data)
You can choose 200 if you wish to install Vision Instance of Oracle Applications R12. (Make sure you have that much space available on your hard disk)

This finishes your VMWare Linux configuration , Next step is to Install Linux on this VMware machine which I will cover in next post . In mean time down load 4 CD's Oracle-Linux from location mentioned on top & unzip this 4 disks to create iso files . We will use these iso files to install Linux on this virtual machine.

Labels: others, r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 10:31 PM 30 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Prepare for Oracle Apps R12 Installation

Tuesday, February 20, 2007

In today's post I will discuss on steps you should do/need for Oracle Apps R12 installation. Most of these steps are written w.r.t. to Installation on Linux but I'll try to mention any additional software required for Windows or any other platform.

Where to download Apps R12 Software ?
First thing you need is Oracle Apps R12 which is available at eDelivery (Click here to go to eDelivery) or you can order software DVD's via Metalink. You don't need to download all CD's .

You might have to register initially with Name, Company & email address & try again after 1-2 days (You might not get confirmation, just try after a day)
Select product as E-Business Suite & your platform , For Linux you have to select Part Number B35903-01 (There are total 72 CD's {you don't need all 72 CD's} with total size as 35GB {this is just software size & not actual installation})

In actual you have to download following 64 CD's rest others are for NLS, 10g AS & BI CD's

Oracle Applications Release 12.0 Rapid Install Start Here - Disk 1 (5 CD's)
Oracle Applications Release 12.0 for Linux x86 Rapid Install RDBMS - Disk 1 (3 CD's)
Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 1 (6 CD's)
Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 2 (7 CD's)
Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 3 (7 CD's)
Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 4 (8 CD's)
Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 5 (7 CD's)
Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 6 (2 CD's)
Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 7 (7 CD's)
Oracle Applications Release 12.0 for Linux x86 Rapid Install Databases - Disk 8 (2 CD's)
Oracle Applications Release 12.0 for Linux x86 Rapid Install Tools - Disk 1 (3 CD's)
Oracle Applications Release 12.0 for Linux x86 Rapid Install APPL_TOP - Disk 1 (6 CD's) Oracle Applications Release 12.0 for Linux x86 Rapid Install APPL_TOP - Disk 2 (1 CD)

Oracle Apps R12 Installation Document
Next thing you need is Oracle Apps R12 Installation Guide which is available at http://download-uk.oracle.com/docs/cd/B34956_01/current/acrobat/120oaig.pdf

What should I do if I don't have Linux Operating system as well ?
If you don't have Linux O.S. you can install it on any other operating system (CD's mentioned above are for linux download according to your O.S. ). If you are curious to install it on Linux you can download linux from http://edelivery.oracle.com/linux

Do I need to Install any other software before Oracle Apps R12 Installation ?
On Unix/Linux you don't need to install any other software (You should have all required o.s. packages as mentioned in above installation guide) but as you don't need to install JDK prior to Apps R12 install (with 11i you have to install JDK prior to installing Apps)
For windows you still need other software like mks toolkit (cygwin my recommendation for test server), VC++

User & Mount point/File system
I will recommend two user install (one for database tier & another for middle tier also called as application tier) Though you can install both database tier & application tier under same operating system user. For Vision Instance you need around 161 GB (133GB for database & 28 GB for application tier) space . For instance without dummy data you need 73 GB space (45GB DB & 28GB application tier)

CPU & RAM
For testing Installation you can try as low as single CPU (1.6 GHz) and 1GB RAM (This was spec of my laptop where I installed for testing purpose, You can try with low configuration as well)

Staging Area

Its good idea to create staging area using script adautostg.pl available in Start Here CD. Refer to Page 30 of above Installation Guide. Advantage with staging area is that after start CD you don't have to manually insert CD's and Installer will automatically pick next CD from staging Area. You can pass on configuration setting on first 3-4 screens & once installer starts you can sleep & next day morning you can see complete installation. In case of any failure or subsequent installations (If you have to install more than one Instance its always better to install using Staging Area)

For new Installation features and Step by Step Oracle Apps R12 Installation on Linux VMware on your laptop stay tuned with this blog .

You can now register for subscription to this blog via eMail using right menu bar under E-Mail Subscription.

Labels: r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 11:44 PM 45 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Oracle Apps R12 Installation Guide

Tuesday, January 30, 2007

Oracle E-Business Suite Release 12 Installation Guide is now available at Check R12 Installation Guide

Most of the Installation Steps are still same like Oracle Applications 11i . There are few changes and additional options available during Oracle Applications R12 Installation which I'll cover in my coming posts.

The disk space requirement for R12 is 133 GB for vision database & 28 GB for Application Tier.
If this is fresh Install you need around 45 GB for database & 28 GB for Application Tier.

R12 software CD's to install are available at http://edelivery.oracle.com/

Stay tuned & register for email Notification to get more updates on Oracle Applications 11i & R12

Labels: r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 3:10 PM 9 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Oracle R12 Upgrade from 11i & Database Versions

Thursday, January 25, 2007

As promised in past , here is some information on R12 Upgrade process. This Upgrade post revolves around Database version with Oracle Applications (E-Business Suite)

Key points to note in Oracle Apps R12 upgrade from 11i
-- R 12 upgrade process involve replacing 11i Tech stack (9iAS & 806) to Fusion Middleware (10g Application Server)
-- Basic upgrade process involves Rapid Install & Autopatch
-- Rapid Install involves installing new R12 tech stack as mentioned in first point
-- Auto patch process involves upgrading E-Business Suite database compatible to R12 (Data Model)
-- Final upgrade process is of updating data model using enhanced version of AutoPatch
-- Minimum version from which you can upgrade to R12 is 11.5.7 and higher
-- Minimum database version from which you can upgrade to R12 is 9i
so if your database is still 8i or <>
-- Database must be 10.2.0.2 before or during upgrade process & prior to running AutoPatch which will upgrade datamodel to R12

As per Oracle R12 Upgrade Documentation, Apps 11i Instance is classified in Two Categories based on Apps & DB Version
Category 1 - 11.5.7, 11.5.8, 11.5.9 (CU1), 11.5.10 (CU1)
Category 2 - 11.5.9 (CU2), 11.5.10 (CU2) or 11.5.10.2

For Category 1 , database should be upgraded during R12 upgrade process (Downtime for R12 upgrade process will be more as this involve database upgrade as well) but for Category 2 Database can be upgraded before R12 upgrade .

Why can't I upgrade database to 10.2.0.2 before for category 1 ?
This is because there is no Interoperability patch for above release & 10.2.0.2 was supported for 11.5.9 (CU2) & 11.5.10(CU2) only . (Wish I could be on 11.5.10.2 ;-) )

What are advantages of Upgrading database to 10.2.0.2 before R12 upgrade ?Downtime can be broken down to two small downtimes (one for Database upgrade another one for R12 upgrade) and can be achieved during weekends or long weekends (depending on your system & resources)

Various upgrade paths (mainly 3) revolves around application version & database version (mainly on database version).

Path A for apps R12 Upgrade :
These are for instances where database is not 10.2 & DB is upgraded during R12 Upgrade
Install the R12 Technology Stack and 10.2.0.2 Oracle home
Upgrade the Database to 10.2.0.2
Perform Database Steps
Complete the R12 upgrade

Path B for apps R12 Upgrade :
These are for instances 11.5.9.2 & 11.5.10.2 and database is 10.2
Install the R12 Technology Stack and 10.2.0.2 Oracle home
Perform Database Steps
Complete the R12 upgrade

Path C for apps R12 Upgrade :
These are for instances 11.5.9.2 & 11.5.10.2 and database is NOT 10.2, Here upgrade database first to 10.2.
Upgrade database to 10.2.0.2
Use 11i with 10.2.0.2 DB & then in next downtime window
Perform Database Steps
Complete the R12 upgrade

Related :
For full Steps follow metalink Note # 403339.1 Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12 Upgrade
http://becomeappsdba.blogspot.com/search/label/r12

Labels: apps, r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 4:22 PM 14 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Oracle Apps R12 File System Changes

Thursday, January 18, 2007

Sometime back I discussed about R12 release dates & few major changes at Click here to check R12 release date and few changes in R12 . In today's post I am going to cover File System changes in R12 and talk about new TOP (INSTANCE_TOP) in Application Tier.

If you are familiar with Oracle Apps 11i , you can easily understand picture on your right. This is file system for 11i with various TOP's , APPL_TOP, ORA_TOP, COMMON_TOP, DB_TOP and DATA_TOP. With Multiple Middle Tier configuration came shared APPL_TOP (only APPL_TOP used to be shared ) . After shared APPL_TOP came shared Application Tier (All three TOP's on Application Tier, APPL_TOP, ORA_TOP and COMMON_TOP were shared across servers). With this came challenge of configuration files which are specific to a server mainly iAS & 806 configuration file. If you have configured Shared Application Tier (sharing ORA_TOP as well) in 11i then this problem was overcome by creating conf directory in COMMON_TOP.

In Oracle Apps R12, You can see new TOP called INSTANCE_TOP in Application Tier. This TOP will now hold any configuration files (specific to that server) , Certificates (If SSL is enabled SSL Certificates & any other certificates specific to that server) and related log files or pid files (for Apache or any other process). In diagram tops with <>ST can be shared across servers (Shared Tier) and INSTANCE_TOP will be specific to Server.

Next three pictures are taken from Ivo Dujmovic's presentation at Oracle Open World "Deep Dive: Oracle E-Business Suite Release 12 New Technology Stack". These Pictures are self explanatory & will help you in understanding Oracle Apps R12 File System.

This shows Oracle E-Business Suite Release 12 File System Layout

This shows Directory/File Structure for Instance TOP in R12

This Picture compares file system in 11i with File system in R12

Labels: r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 11:49 AM 23 Comments

We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future

Oracle Applications R 12 Release date announced

Wednesday, January 03, 2007

Much awaited release of Next Oracle Applications (after 11i) / E-Business Suite has been announced by Oracle Click Here for more details . As per Schedule Oracle is releasing Apps R 12 on Jan 31, 2007 .

The key Technology changes as per Steven Chan's update & slides from Ivo Dujmovic presented during Oracle Open World are --

On Middle Tier
--Application Server version 1.0.2.2.2 will change to 10g Application Server i.e. 10.1.3.X
--mod_jserv will be replaced by mod_oc4j
--Apache which is part of Application Server mentioned above will be changed from version 1.3.19 to 1.3.34
-- Biggest change will be in long running Forms & Reports Version 6i (8.0.6) to Forms & Reports Version 10g i.e. 10.1.2.X
-- Java/ JDK version 1.3.X or 1.4.X will be replaced by JDK 1.5.X

On File System
There will still be three ORACLE_HOME , one for Web Server another for Forms & Reports & third one for Database but with New versions i.e. 10g AS for Web Server, 10g AS for forms & reports , 10g R2 for database

There will be new TOP called as Instance TOP (more coming on this in future posts)

There will be new concept called Instance Home V/S Source Home which I will cover in my coming posts.

This is Just an overview of Release 12 , I'll be covering Inside views , new Features, Advantages of new features & upgrade path for Oracle Apps 12.

Stay tuned for all latest information on Oracle Apps R 12 at your inbox, Now you can subscribe notification for this blog to your Mail box , its simple two step procedure.
Step 1 - Enter your email ID in "E-mail Subscription " box on right hand side menu bar
Step 2 - Verify email you received in your box by clicking on link in mail (Don't forget to check Junk folder if you didn't get mail in inbox)

Labels: r12

We have moved to
http://onlineAppsDBA.com
kindly check onLineAppsDBA.com in future

del.icio.us ¦

Digg This ¦ My Yahoo!

My Yahoo ¦ Reddit

Reddit ¦ add to BlinkList

BlinkList ¦ Furl It

Furl It ¦

Email This ¦ Leave Your Comments

posted by Atul Kumar @ 3:01 PM 1 Comments

About Me

Name: Atul Kumar
Home: London, United Kingdom

About Me: I am Independent Oracle consultant. If you wish to hire me on Contract or to Quote on project basis contact me at
atul @ onlineappsdba.com

See my complete profile

E-mail Subscription

Recent Comments