Monday, July 16, 2007

Good Metalink Notes on Ebiz

1).Note:443699.1 How to check if certain Oracle Applications product/module is implemented?
2).Note:228779.1 How to Merge Patches Using admrgpch
3).Note: 343987.1 How to uninstall backout an Oracle Applications 11i Patch
4).Note:181665.1 Release 11i Adpatch Basics
5).Note:415129.1 How to change IP Address for server with Oracle Applications; Is it supported to use DNS address resolution instead of IP
6).Note:337762.1 How to Remove an Oracle Applications 11i node.
7).Note:400920.1 What Affect Will IP Address Change Have On Oracle Applications?
8).Note:375130.1 How to apply patch without enabling Maintenance Mode
9).Note:Oracle Applications Patching FAQ

Monday, July 9, 2007

How to Check the installed Oracle Software is 32/64 bit ?

You can check the Oracle Bit by 2 methods

Method 1:
Go to ORACLE_HOME/bin
$ file oracle
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped
Method 2:-
Login to sqlplus,
use the following query,
SQL> select metadata from sys.kopm$ ;
-----------------------
METADATA
-----------------------

0000006001240F050B0C030C0C0504050D06090708050F0505050F05050505050A050505050504050607080823472323081123081141B0230083001F07D01300000000000000000000000000000000000000000000000000000000000000000000000000
If the output has 'B023' string then the database is 32 bit else if it is B047 then it is 64 bit