|
| Oracle R12 Upgrade from 11i & Database Versions |
| Thursday, January 25, 2007 |
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
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/r12Labels: apps, r12 |
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 @ 4:22 PM
  |
|
|
|
| Change Oracle APPS Password : FNDCPASS |
| Tuesday, January 23, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
With Product Family ATG version H Roll Up 3 , Oracle Introduced New Option in FNDCPASS which is ALLORACLE to Change password of all Schema provided by Oracle Application products. These are basically below three category password
--These are mainly schema password for products like AP, GL, AR (These are also termed as of mode ORACLE )
--Password for APPLSYS and APPS (Same password for both schema) . This is also called as Apps Password (used during CM startup)
--Password for account APPLSYSPUB
How to change Oracle Applications Products/Schema Password including APPS ?
As most of you might already be aware that you use FNDCPASS utility on Concurrent Manager Node.
FNDCPASS logon 0 Y system/password mode username new_password
Where MODE is SYSTEM/USER/ORACLE/ALLORACLE (Introduced with patch 4745998)
Will ALLORACLE mode change other schema passwords like CTXSYS, MDSYS, PORTAL..,SYS, SYSTEM, SCOTT, Application User like AtulKumar .... ??
No ALLORACLE mode will change only schemas mentioned in paragraph 1 and will not change passwords for schemas like CTXSYS, MDSYS, SYS, SYSTEM.....
Is previous Mode SYSTEM/USER/ORACLE still available with FNDCPASS ?
Yes
How to get ALLORACLE mode in FNDCPASS ?
Apply Oracle Apps patch 4745998
What files to change after changing Apps Password ?
You use FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME to change Apps Password
--Once you change apps password you need to change apps password stored in file wdbsvr.app at $IAS_ORACLE_HOME/Apache/modplsql/cfg
--In some instances you might have to change in CGIcmd.dat at $ORACLE_HOME/reports60/server
--You also have to change in any custom concurrent manager start up script (If you have any)
Added on 14th August 2007
--If you have configured E-Business Suite with 10g Application Server SSO/OID then after changing APPS password, update provisioning profile with new apps password
oidprovtool operation=modify \
ldap_host={OID Server hostname} ldap_port={OID Server Port} \ ldap_user_dn="cn=orcladmin" ldap_user_password={orcladmin Password} \ application_dn=" {The LDAP distinguished name of the application}" \ interface_connect_info={E-Business Suite connect info of the format, host:port:Sid:username:password}
after changing Apps password bounce Concurrent Managers.
Related
Following Metalink Notes are useful & related to Oracle Applications or Apps Password
--303621.1 How to Change and Which Apps Database Users Passwords Can Be Changed in a Multi-Node Apps Installation?
--159244.1 How To Use FNDCPASS to Change The Oracle Users, APPS, APPLSYS and Application Module Passwords (INV, AR, AP, etc.) For Applications 11.5 in UnixLabels: 11i |
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 @ 12:37 PM
|
|
|
|
| Oracle Apps R12 File System Changes |
| Thursday, January 18, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
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 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:49 AM
|
|
|
|
| Configure SSO for Apex Application |
| Monday, January 08, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Sometime back I discussed about Apex (earlier HTMLDB) Installation, Click Here to know more about apex Installation . Today I am going to cover how to configure Single Sign-On for Apex Applications. If you are new to Oracle SSO (Single Sign-On) and want to know more about Oracle SSO Click Here for Overview of Oracle SSO
There are mainly three major steps in configuring Apex / HTMLDB
--Register Apex as Partner Application in SSO Server
--Install SSO SDK on Apex Server
--Register SSO details on Apex Middle Tier
Assumptions in below configuration
Below configuration is based on following assumptions, You may need to change things as per your apex/sso version.
-- Apex version discussed below is for 2.0.2.0.0 (Change schema name flows_020200 according to your version)
-- Apex is installed on 10g AS , if you don't see ssosdk902.zip then get it from 10g AS middle tier -- You have access to Oracle SSO Server with Admin privileges (orcladmin) account
--You have access to schema under which Apex was installed , In my discussion below database schema name for Apex is "apex"
-- URL to access Apex Application is http: // apex_server_name/pls/apex
Configure Apex as Partner application in Oracle SSO Server
Type URL as http: // ssoserver.com/pls/orasso & login as orcladmin, you will see screen like
 Click on SSO Server Administration & then you will get Administration Screen
Under that click on "Administer Partner Application "
Click on Add Partner Application
You will come to Partner application Login Screen enter following details & click on "OK"
Name : SSO Apex
HOME URL : http: // apex_server_name/pls/apex
Success URL : http: // apex_server_name/pls/apex/wwv_flow_custom_auth_sso.process_success
Log Out URL : http: // apex_server_name/pls/apex/apex
and click on OK, you will get screen with values like ID, Token, Encryption Key, Login URL, Single Sign-Off URL ... Keep a note of these values as these will be used during Apex Registration process in Next Steps
Remaining Steps: Installing SSO SDK in Apex & Registering Apex with SSO Partner Application created above coming in Next Topic ... Labels: apex, sso |
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 @ 4:43 PM
|
|
|
|
| Oracle Applications R 12 Release date announced |
| Wednesday, January 03, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
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 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 @ 3:01 PM
|
|
|
|
|
|
