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 Oracle Applications Web Server Version ?
Q: How to find Version of Apache used with oracle apps 11i ?
Log to Application tier as Operating System Usually called as APPLMGR ;
go to location $IAS_ORACLE_HOME/Apache/Apache/bin and run command
./httpd -version
You will see output like
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Dec 6 2005 14:59:13 (iAS 1.0.2.2.2 rollup 5)
Which means you are on iAS Version 1.0.2.2.2 with patchset rollup 5 with Apache
Version 1.3.19
Server version: Oracle-Application-Server-10g/10.1.2.0.2 Oracle-HTTP-Server
Above is output If you have installed 10g Application Server with 11i
 
Q: How to find Jinitiator Version ?
Check for file like appsweb_SID_HOSTNAME.cfg under $OA_HTML/bin defined by environment variable
FORMS60_WEB_CONFIG_FILE & search for entry like jinit_ver_name , you will see entry like
jinit_ver_name=Version=1,3,1,23
which means Jinitiator version is 1.3.1.23 ; if your version is 1.3.1.18 you will
see entry like 1,3,1,18
 
Q: How to find Forms Version in 11i ?
Login to forms from frontend , on top menu bar of forms click on "Help" & Select
"About Oracle Applications" go to "Forms Server " section. You should see entry like below
depending on your forms version
Oracle Forms Version : 6.0.8.26.0
Which mean you are on forms version 6.0.8.26 . If you want to know whats your forms
patchset level then subtract 9 from fourth digit which means for above case form patchset
17 is applied.
 
Q: How to find Forms Version in Apps from command Line ?
Enter "f60gen" on Forms Server and check for first line in output like
Forms 6.0 (Form Compiler) Version 6.0.8.26.0 (Production)
This confirms that you are on forms server version 6.0.8.26.0 and patch set 17.
( Patch Set = Fourth Digit - 9)
To know more about database, operating system Version or bit click Next
 
 
|
|
Next
|