Oracle HTTP Server 11G 32 bit Installation Issue on 64 bit OS Linux

Oracle HTTP Server 11G 32 bit Installation Issue 64 bit

Installing Oracle HTTP server 11g 32 bit on 64bit OS is not supported, But With a work around we can install it , But this is not certified method.

Perform the below on Linux 64bit OS:

           Create gcc file to install 32bit HTTP server on 64bit OS.

                mv /usr/bin/gcc /usr/bin/gcc.orig
                vi /usr/bin/gcc41

                #!/bin/sh
                exec /usr/bin/gcc.orig  -m32 -static-libgcc -B /usr/lib/gcc/i686-redhat-linux/4.4.4/ $*

                chmod 755 /usr/bin/gcc41
                ln -s -f /usr/bin/gcc41 /usr/bin/gcc


Note: Replace  /usr/lib/gcc/i686-redhat-linux/4.4.4 with exact 32bit gcc path in your server.

Fusion Application Installation - Part 1

Fusion Applications 11.1.6 Installation Hardware Sizing:

Fusion applications has below modules:

1)SCM
2)CRM
3)Financial
4)Procurement
5)Incentive
6)HCM
7)BI
8)Projects

You can install on single node or Multinode, But the memory requirement should match.

Ideally, suggested to install minimum on two nodes, where IDM and IDM database on one node and Fusion Applications and Database on another Node.

Note: The below is NOT official Oracle documentation - this is a rough  calculation for a Fusion Applications installation, For actual customer implementation contact Oracle support to get the sizing info.

Hard Disk:
-----------
Harddisk size can be of 500GB for initial installation, Later based on the transactions volume need to add as required.


Memory/RAM:
-----------
Fusion Applications is memory intensive applications as there will be many managed and Admin servers for each Module.

Each module requires specific amount memory to be able to successfully install and run the FA.


The below outlines the memory requirement for each module. 
---------------------------------------------------------

If you are planning to Install:

only SCM   - 80GB of RAM required
only HCM   - 70GB of RAM required
HCM+IC     - 80GB of RAM required
CRM     - 80GB of RAM required
CRM+IC     - 90GB of RAM required
Finance+SCM+HCM - 125 GB of RAM required

Note: FA DB,IDM and IDM DB is not included in the above. Additional memory required for them

If you are planning to Install Complete Fusion Applications Modules:
***********************************************************

For All the Modules of Fusion Applications - 150 GB RAM is Required

Below are commonly required RAM sizes irrespective of the modules installed.

Fusion Applications DB  - 15 GB RAM is Required
IDM Applications           - 20 GB RAM is Required
IDM Database                - 10 GB RAM is Required


Watch this space for installation Pre-requisites to Install on Linux and procedure of Fusion Applications.

Internet Explorer crashing on launching the forms for Oracle Applications 11i (11.5.10)

Internet Explorer crashing on launching while launching the forms for Oracle Applications 11i (11.5.10)

We see many a times IE crashes when you try to launch the Jinitiator Forms using IE.

Now IE is not supported, We can not use  Jinitiator to launch forms for 11i, Only JRE is supported.

But we can fix this issue by tweaking the jvm.dll file in the jinitiator directory.


Copy the jvm.dll to c:\Program FilesOracle\JInitiator <Version of Jinit>\bin\hotspot

Click here to download the jvm.dll file  https://docs.google.com/file/d/0BwQ_NVbOr4hwb0ZkTGdlbndZWjg/edit?usp=sharing


Restart IE, and check the issue.

Enable DDL auditing in 11GR2 Database:

Found intresting audit parameter in 11Gr2, enable_ddl_logging will allow the tracking of all ddl's in the alert log using the following:

Enable it by using the below command.

ALTER SYSTEM SET enable_ddl_logging=TRUE

All the DDL commands executed against the database will be recorded in the alert<SID>.log

More details of the DDL of the command executed can be found in the XML file in the alert directory

RMAN DUPLICATE DATABASE WITHOUT CONNECTING TO TARGET DATABASE

Have come across a requirement to clone a database using RMAN from from PROD to TEST in the same server

The only way you can clone a database from PROD to TEST (Different SID) in the same server is using RMAN duplicate command.

Usually RMAN duplicate command uses auxilary database and connect to target(PROD) database while creating the TEST.

We have a new feature in 11GR2, Which allows to clone using RMAN duplicate command without connecting to source PROD database.

It will only access the backup piecies and clones database.

This method works in cloning the database in the same server or different server

Source : PROD
Target : TEST

Steps:

1) Copy the Oracle home from source PROD to target TEST and create the parameter file for TEST database

2) Copy the backupsets to TEST server (If the clone is in the same server, This step is not required)

3)If you are cloning the database in the same server as PROD,Modify the below two parameters in the TEST (target instance),

This step is very importent step to mention the different directory structure for TEST datafiles if you are restoring on the same server as PROD.

db_file_name_convert=('/oradata/PROD' '/oradata/TEST')
log_file_name_convert=('/oradata/PROD' '/oradata/TEST')

4) Start the TEST Instance (This is called as auxilarary database)
$ sqlplus "/ as sysdba"
SQL> startup nomount;

5) Run the RMAN duplicate command from
rman auxiliary /
RMAN> DUPLICATE DATABASE TO NEWDB BACKUP LOCATION '/RMAN_Backup_Location/';