YET ANOTHER ORACLE DBA

Focus on Oracle DBA (Core/Apps/Fusion) stuffs

Archive for February, 2010

How To Disable Jinitiator Automatic Download

Posted by Jay on February 18, 2010

>

One simple way to disable downloading of Jinitiator is to rename the file $OA_HTML/oajinit.exe (oaj2se for R12). Another way is editing the file $OA_HTML/bin/appsweb.cfg and changing the value of the parameterjinit_name to be different from oajinit.exe; this second method includes changing appsweb.cfg which is managed by AutoConfig, thus any AutoConfig run will overwrite the change. To make it permanent, you will need to edit the template of appsweb.cfg which is $FND_TOP/admin/template/appsweb.cfg

Posted in How to, Uncategorized | Leave a Comment »

How to identify correct Oracle Database software to install on Linux platform

Posted by Jay on February 16, 2010

>If you are planning to install Oracle Database on Linux platform, then you have to ensure that you are downloading/installing the correct software installation kit. Incorrect software installation for your linux platform will cause errors at relink phase of the installation. Correct Oracle Database Software installation kit can be identified based on Linux OS kernel architecture type (from OS command ‘uname -a’ output). Following are the different linux architectures along with examples that help to identify correct oracle database software.

Linux x86: (32-bit OS)

$ uname -a Linux celnx4 2.6.9-34.0.2.ELsmp #1 SMP Fri Jun 30 10:33:58 EDT 2006 i686 i686 i386 GNU/Linux

If Linux kernel architecture contains “i386 or i686 or x86”, then this platform will be referred as “Linux x86”. Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for “Linux x86”.

Linux x86_64: (64-bit OS)
$ uname -a Linux celnx7 2.6.9-55.ELsmp #1 SMP Fri Apr 20 16:36:54 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux

If linux kernel architecture is “x86_64”, then your platform will be referred as “Linux x86_64” (or Linux AMD64 or Linux EM64T or Linux AMD64/EM64T or Linux x86_64(AMD64/EM64T) ). Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for “Linux x86_64”.

Linux Itanium: (64-bit OS)

$ uname -a Linux celia4 2.6.9-42.EL #1 SMP Wed Jul 12 23:25:09 EDT 2006 ia64 ia64 ia64 GNU/Linux

If linux kernel architecture is “ia64”, then your platform will be referred as “Linux Itanium”. Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for “Linux Itanium”.IBM Power Based Linux: (64-bit OS)

$ uname -a Linux stuze22 2.6.9-34.0.1.0.11.EL #1 SMP Mon Dec 4 16:10:42 PST 2006 ppc64 ppc64 ppc64 GNU/Linux

If linux kernel architecture is “ppc64″, then your platform will be referred as ” ‘IBM Power Based Linux’ or ‘Linux on Power’ “. Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for “IBM Power Based Linux” or “Linux on Power”.IBM zSeries Based Linux: (64-bit OS)

$ uname -a
Linux pazxxt12 2.6.16.46-0.12-default #1 SMP Thu May 17 14:00:09 UTC 2007 s390x s390x s390x GNU/Linux

If Linux kernel architecture is “s390x”, then your platform will be referred as “IBM zSeries based Linux” or “zLinux”. Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for “IBM zSeries based Linux” or “zLinux”.

IBM S/390 Based Linux (31-bit): (31-bit OS)

$ uname -a Linux pazxxt10 2.4.21-50.EL #1 SMP Tue May 8 17:10:38 EDT 2007 s390 s390 s390 GNU/Linux

If Linux kernel architecture is “s390” (but not s390x) , then your platform will be referred as “IBM S/390 based Linux (31-bit)”. Please ensure that you are downloading/installing the Oracle Database software installation kit that is released for “IBM S/390 based Linux (31-bit)”. 10gR1 (10.1.0.x) is the last/terminal Oracle Database release for this platform.

Posted in Linux | Leave a Comment »

Is It Required to Recompile Forms/Reports When Connecting to a New Database Instance?

Posted by Jay on February 6, 2010

>It is recommended to recompile all forms and reports when connecting to a new RDBMS.

1) This will act as a health-check to confirm that all dependent RDBMS objects are present andvalid. (Review the compile output for any errors)

2) Timestamps of RDBMS objects may be newer than the depending forms/reports objects.

3) If the new RDBMS uses a different schema to house database objects, the reference in thecompiled forms/reports will no longer be valid, and problems will occur.

4) The recompilation can be done using a batch script, so it is not required to spend timerecompiling each form/report manually

Posted in Apps 11i/R12, Troubleshooting | Leave a Comment »

>Cannot Open Report or Form Within Reports or Forms Builder 10.1.2.3 (MS Windows Vista)

Posted by Jay on February 3, 2010

>Developer Suite has been installed successfully on a MS Windows Vista system.To meet the MS Windows Vista certification this instructions were followed. On trying to open or to compile a reports module file (RDF) in Reports Builder, the Builder crashes.Opening a Forms module file (FMB) in the Forms Builder crashes the Builder.Error(s)Windows Vista complains there has been a problem in Reports Builder and is trying to work it out.But eventually, it states that Reports Builder is going to be closed.

This is because despite applying patchset 10.1.2.3 there are still issues in the 10.1.0.5 DB client causing the crashes.
Apply
Patch 7047034 ORACLE 10G 10.1.0.5 Patch 26 BUG FOR WINDOWS 32 BIT
to the ORACLE_HOME of the Developer Suite installation.

The patch can be downloaded from Metalink’s PATCHES section doing a SIMPLE SEARCH for patch number 7047034 and platform MS Windows (32-bit).
Follow the instructions of the patch readme carefully.


Posted in Uncategorized | Leave a Comment »