Friday, June 24, 2011

Mobile Wireless Applications (MWA) Telnet GUI Client for 11i/R12


To use MWA GUI Client ,The MWA server need to be setup and it must be accessibe from telnet.

The below steps are applicable for both 11i and R12(12.0.X and 12.1.X) Versions, Though the patch is for 11i.

1) Create 2 directories say C:\MWA\lib and C:\MWA\log

2) Extract the patch files from the patch p4205328_11i_GENERIC into C:\MWA\lib

3) Install jdk1.1.8 on your PC

4) Create a batch file say Start_MWA.bat on desktop with the following contents

Open notepad and copy & paste the below content and save it as Start_MWA.bat

set MWA_GUI_TOP=C:\MWA\
set JAVA_TOP=c:\jdk1.1.8
%JAVA_TOP%\bin\java -classpath %JAVA_TOP%\lib\classes.zip;%MWA_GUI_TOP%\lib\j4205328.zip oracle.apps.mwa.awt.client.StartGUI


5) Whenever you run this batch file, you must be able to see the GUI client for MWA

The loging screen will like below.


Tuesday, June 21, 2011

Oracle Applications Database Documentation Resources

Oracle Applications Database Documentation Resources, Release 12
================================================================
 

 Note 396009.1 Database Initialization Parameters for Oracle Applications Release 12
 Note 802875.1 Interoperability Notes E-Business Suite Release 12.1 with Oracle Database 11gR1 (11.1.0)
 Note 1058763.1 Interoperability Notes EBS R12 with Database 11gR2
 Note 735276.1 Interoperability Notes E-Business Suite R12 with Oracle Database 11gR1 (11.1.0)
 Note 782224.1 Interoperability Notes Oracle E-Business Suite Release 12 with 11gR1 (11.1.0.6)
 Note 454750.1 Oracle Apps Release 12 with Oracle Database 10.2.0 interoperability notes
 Note 761570.1 Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade
 Note 728244.1 Database Preparation Guidelines for an E-Business Suite Release 12.0.4 Upgrade
 Note 738556.1 Oracle 11gR1 Database Preparation Guidelines for an E-Business Suite Release 12.0.4 Upgrade
 Note 784374.1 Oracle 11gR1 (11.1.0.6) Database Preparation Guidelines for an E-Business Suite Release 12.0.4 Upgrade
 Note 403339.1 Oracle 10gR2 Database Preparation Guidelines for an E-Business Suite Release 12.0.4 Upgrade
 Note 552973.1 Oracle 10gR2 (10.2.0.3) Database Preparation Guidelines for an E-Business Suite Release 12.0 Upgrade
 Note 467778.1 Oracle 10gR2 (10.2.0.2) Database Preparation Guidelines for an E-Business Suite Release 12.0 Upgrade
 Note 756050.1 Troubleshooting Autoconfig issues with Oracle Applications RAC Databases
 Note 745759.1 Oracle E-Business Suite and Oracle Real Application Clusters Documentation Roadmap
 Note 823587.1 Using Oracle 11g Release 2 Real Application Clusters with Oracle E-Business Suite Release 12
 Note 466649.1 Using Oracle 11g Release 1 (11.1.0.7) Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 12
 Note 783044.1 Using Oracle 11g Release 1 (11.1.0.6) Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 12
 Note 388577.1 Using Oracle 10g Release 2 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 12
 Note 762669.1 Using Oracle EBS R12 with a Database Tier Only Platform on Oracle 11gR1
 Note 456197.1 Using Oracle E-Business Suite Release 12 with a Database Tier Only Platform on Oracle 10g Release 2
 Note 741818.1 Export/Import Process for Oracle E-Business Suite Release 12 Database Instances Using Oracle Database 11g Release 1
 Note 454616.1 Export/Import Process for Oracle E-Business Suite Release 12 Database Instances Using Oracle Database 10g Release 2
 Note 452056.1 Business Continuity for Oracle Applications Release 12 on Database Release 10gR2 - Single Instance and RAC
 Note 859397.1 Integrating Oracle E-Business Suite Release 12 with Oracle Database Vault 11.1.0.7
 Note 566841.1 Integrating Oracle E-Business Suite Release 12 with Oracle Database Vault 10.2.0.4
 Note 744363.1 Integrating Oracle E-Business Suite Release 12 with Oracle Database Vault 10.2.0.3
 Note 732764.1 Using TDE Column Encryption with Oracle E-Business Suite Release 12
 Note  828229.1 Using TDE Tablespace Encryption with Oracle E-Business Suite Release 12
 Note 734763.1 Using Transportable Database to migrate Oracle E-Business Suite R12 using Oracle Database 10g Release 2
 

Oracle Applications Database Documentation Resources, Release 11i
================================================================

 Note 216205.1 Database Initialization Parameters for Oracle Applications Release 11i
 Note 881505.1 Oracle Applications Release 11i with Oracle 11g Release 2
 Note 452783.1 Interoperability Notes Oracle E-Business Suite Release 11i with Oracle Database 11g Release 1 (11.1.0)
 Note 757593.1 Oracle Applications Release 11i with Oracle 11g Release 1 (11.1.0.6)
 Note 362203.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0)
 Note 726982.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0.3)
 Note 423056.1 Oracle Applications Release 11i with Oracle 10g Release 2 (10.2.0.2)
 Note 282038.1 Oracle Applications Release 11i with Oracle Database 10g Release 1 (10.1.0)
 Note 362202.1 Oracle Applications Release 11i with Oracle 10g (10.1.0.4)
 Note 216550.1 Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
 Note 399078.1 Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0.7)
 Note 162091.1 Interoperability Notes Oracle Applications R11i with Oracle9i Release 9.0.1
 Note 148903.1 Interoperability Notes Oracle Applications Release 11i with Release 8.1.7
 Note 359483.1 Upgrading 9.2.0.6 to 10.1.0.4.2 with 11.5.10.2 Applications
 Note 148902.1 Interoperability Notes Oracle Applications Release 11.0 with Release 8.1.7
 Note 148901.1 Interoperability Notes Oracle Applications Release 10.7 with Release 8.1.7
 Note 455398.1 Using Oracle Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 11i and Oracle Database 11g
 Note 757980.1 Using Oracle 11g Release 1 Real Application Clusters and Automatic Storage Management with Oracle E-Business Suite Release 11i (11.1.0.6)
 Note 362135.1 Configuring Oracle Applications Release 11i with Oracle10g Release 2 Real Application Clusters and Automatic Storage Management
 Note 312731.1 Configuring Oracle Applications Release 11i with 10g RAC and 10g ASM
 Note 279956.1 Oracle E-Business Suite Release 11i with 9i RAC Installation and Configuration using AutoConfig
 Note 261924.1 Oracle Applications 11.5.8 with 9i RAC Installation and Configuration
 Note 760637.1 Manually Cloning Oracle Applications Release 11i with 10g or 11g RAC
 Note 946413.1 Using Oracle EBS with a Split Configuration Database Tier on 11gR2
 Note 562983.1 Using Oracle E-Business Suite with a Split Configuration Database Tier on Oracle 11g Release 1
 Note 369693.1 Using Oracle Applications with a Split Configuration Database Tier on Oracle 10g Release 2
 Note 356839.1 Using Oracle Applications with a Split Configuration Database Tier on Oracle 10g Release 1
 Note 304489.1 Using Oracle Applications with a Split Configuration Database Tier on Oracle 9i Release 2
 Note 332977.1 Using Oracle Applications with an HP OpenVMS Alpha Database Server
 Note 204015.1 Export/Import Process for Oracle Applications Release 11i Database Instances
 Note 557738.1 Export/Import Process for Oracle E-Business Suite Release 11i Database 11g
 Note 362205.1 10g Release 2 Export/Import Process for Oracle Applications Release 11i
 Note 331221.1 10g Export/Import Process for Oracle Applications Release 11i
 Note 230627.1 9i Export/Import Process for Oracle Applications Release 11i
 Note 204015.1Export/Import Process for Release 11i Database Instances Using Oracle8i Enterprise Edition
 Note 341437.1 Business Continuity for Oracle Applications Release 11i Using Oracle Real Application Clusters and Physical Standby Database
 Note 859399.1 Integrating Oracle E-Business Suite Release 11i with Oracle Database Vault 11.1.0.7
 Note 403294.1 Using TDE Column Encryption with Oracle E-Business Suite Release 11i
 Note 828223.1 Using TDE Tablespace Encryption with Oracle E-Business Suite Release 11i
 Note 729309.1 Using Transportable Database to migrate Oracle E-Business Suite Release 11i Using Oracle Database 10g Release 2 Enterprise Edition
 Note 285267.1 Oracle E-Business Suite 11i and Database FAQ



Miscellaneous - Oracle Applications Database Documentation Resources
================================================================

Note 216211.1 Nologging in the E-Business Suite
Note 312421.1 PL/SQL Native Compilation of Applications 11i on Oracle Database 10g Release 1 (10.1.0)
Note 554539.1 Using Database Partitioning with Oracle E-Business Suite
 

Monday, June 20, 2011

What is the difference between startup Upgrade and Migrate

What is the difference between startup Upgrade and Migrate:



startup migrate:
---------------

Used to upgrade a database till 9i.


Startup Upgrade ?
---------------

From 10G  we are using startup upgrade to upgrade database.


What happens internally when you use startup upgrade/migrate?
------------------------------------------------------------

It will adjust few database (init) parameters (irrespective of what you have defined) automatically to certain values in order to run upgrade scripts smoothely.

in other way..it will issue few alter statements to set certain parameters which are required to complete the upgrade scripts without any issues.

Oracle E-Business Suite 12.2 is coming soon:

Oracle E-Business Suite 12.2 is coming soon:

Oracle apps 12.2 is coming soon, This version Replacing OC4J with WebLogic Server 11G,It comes with database version 11G,

Please find the below architecture, More details can be found from http://blogs.oracle.com/stevenChan


Sunday, June 19, 2011

Configure Parallel Concurrent Processing For Oracle Applications

Configure Parallel Concurrent Processing (Note ID:362135.1)
NOTE: This section is for UNIX platforms only. Windows users should follow the instructions in Appendix F for configuration of Parallel Concurrent Processing and transaction managers.

a) PCP Prerequisites:
---------------------
It is assumed that you have more than one Concurrent processing tiers in your environment to setup PCP.

If you do not have this refer to Oracle MetaLink Note: 230672.1 for cloning of Applications tier.

b) Set Up PCP:
-------------
   1. Execute AutoConfig by using $COMMON_TOP/admin/scripts/<context_name>/adautocfg.sh on all concurrent nodes.

   2. Source the application environment by using $APPL_TOP/APPSORA.env
   3. Check the configuration files tnsnames.ora and listener.ora located under 8.0.6 ORACLE_HOME at $ORACLE_HOME /network/admin/<context>. Ensure that you         have information of all the other concurrent nodes for FNDSM and FNDFS entries.
   4. Restart the application listener processes on each application node.
   5. Logon to Oracle E-Business Suite Applications using SYSADMIN in login and System Administrator Responsibility. Navigate to Install > Nodes screen             and ensure that each node in the cluster is registered.
 
   6. Verify whether the Internal Monitor for each node is defined properly with correct primary and secondary node specification and work shift details.           Also make sure the Internal Monitor manager is activated by going into Concurrent -> Manager -> Administrator and activate the manager.
      (e.g. Internal Monitor: Host2 must have primary node as host2 and secondary node as host3)

   7. Set the $APPLCSF environment variable on all the CP nodes pointing to a log directory on a shared file system.
   8. Set the $APPLPTMP environment variable on all the CP nodes to the value of the UTL_FILE_DIR entry in init.ora on the database nodes. This value should        be pointing to a directory on a shared file system.
   9. Set profile option ' Concurrent: PCP Instance Check' to OFF if DB instance sensitive failover is not required. By setting it to 'ON' Concurrent               Managers will failover to a secondary middle-tier node when database instance it is connected goes down.