UnsatisfiedLinkError exception loading native library: njni11

UnsatisfiedLinkError exception loading native library: njni11 while running Autoconfig on DB Node

After upgrading database to 11GR2, This issue can occur.

While running autoconfig on the DB node this error occured.

java.lang.UnsatisfiedLinkError: /u01/CRP1/db/tech_st/11.2.0/lib/libnjni11.so: /u01/2CRP1/db/tech_st/11.2.0/lib/libnjni11.so: wrong ELF class: ELFCLASS64 (Possible cause: architecture word width mismatch)


FiX
---

To fix this issue, Edit the database node xml as below and re-run the autoconfig.

From
----
<          <JDK_TOP oa_var="s_jdktop">/u01/CRP1/db/tech_st/11.2.0/appsutil/jre</JDK_TOP>
<          <JRE_TOP oa_var="s_jretop">/u01/R12CRP1/db/tech_st/11.2.0/appsutil/jre</JRE_TOP>

To
---
>          <JDK_TOP oa_var="s_jdktop">/u01/CRP1/db/tech_st/11.2.0/jdk/jre</JDK_TOP>
>          <JRE_TOP oa_var="s_jretop">/u01/CRP1/db/tech_st/11.2.0/jdk/jre</JRE_TOP>



Note:
----
From 11gR2 DB version onwards AutoConfig on DB node uses the JRE from <Oracle_Home>/jdk/jre where as earlier versions of DB uses JRE from $ORACLE_HOME/appsutil/jre  Ref Note 1467892.1

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