Below you will find commonly asked questions about various
component Version in Oracle Applications & way to find them which might be
helpful in Apps DBA Job. Most of these are for Unix / Linux.
Q. How to find Version of Apps 11i ?
Run following SQL from apps user ;
SQL> select RELEASE_NAME from fnd_product_groups;
You should see output like
RELEASE_NAME
-----------------------
11.5.10.2
Which means you are on Apps Version 11.5.10.2
Q: Can I run 64 bit application on 32 bit Operating system ?
You can run 32 bit application (like oracle application server, web server, all oracle application server are 32 bit )
on both 32 /64 bit operating system but a 64 bit application like 64 bit database can run only on 64 bit operating system.
Q How to find if your database is 32 bit or 64 bit(Useful in applying Patches) ?
execute "file $ORACLE_HOME/bin/oracle" , you should see output like
/u01/db/bin/oracle: ELF 64-bit MSB executable SPARCV9 Version 1
which means you are on 64 bit oracle
If your oracle is 32 bit you should see output like
oracle: ELF 32-bit MSB executable SPARC Version 1
Now you know what should be bit of patch to download
Q How to Discoverer Version installed with Apps ?
Discoverer with Apps installed in ORACLE_HOME same as 806 is usually 3i or 4i. To find Version
login to Application Tier & go to $ORACLE_HOME/discwb4/bin and execute
strings dis4ws | grep -i 'discoverer version'
You should see output like
Discoverer Version:Session 4.1.47.09.00
Which means you are on discoverer 4i version 4.1.47.09
|
Previous Page
|
Next Page
|