How to Find Oracle Applications version
Version of a Oracle Applications Form (fmx) or report
strings -a
alternatively you can also use the adident command
Version of a Java class File
To find the version of a java class file $ strings
JAVA version
$ java -version
How to find the Apache version?
Go to the $iAS/Apache/Apache/bin directory and enter the following command:
$ httpd -version
Version Of The OA Framework
To find out the version of your Oracle appplication Framework
http://[host].[domain]:[portnumber]/OA_HTML/OAInfo.jsp
OA Framework Version Information
| OA Framework Version | 11.5.10.K. |
|---|---|
| MDS Version | 9.0.3.8.9 (build 1050) |
| UIX Version | 2.2.13 |
| BC4J Version | 9.0.3.12.53 |
Oracle Application Product Version or Patch Set Level.
select patch_level from fnd_product_installations where patch_level like '%AD%';
WorkFlow Version
select TEXT Version from WF_RESOURCES where TYPE = 'WFTKN' and NAME = 'WF_VERSION';
VERSION
--------------------------------------------------------------------------------
2.6.0
How to find Oracle Database Components version
Oracle RDBMS Version
SELECT * FROM V$VERSION;
Version of OPATCH
$ perl $ORACLE_HOME/OPatch/opatch.pl version
Listener Version
$ lsnrctl version
How to find Operating Systems and Utilities version
Sun Solaris Version
To check the version of you Solaris you can use the following file.
$ cat /etc/release
Solaris 8 2/02 Fujitsu_3 s28s_u7fjsv3wos_04 SPARC
Copyright 2002 Sun Microsystems, Inc. All Rights Reserved.
Assembled 08 December 2002
RedHat Linux Version
You can check the version and release of Linux from the following file
view /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 2)
Perl Version
You can use the perl -v or the perl - version command to find out the version of perl on your environment.
$ perl -version
Java Version
To fine the version of Java used
$ java -version
Version of Installed packages on Solaris
To find the version of the packages on Solaris
$ pkginfo -i|grep perl
Version of Installed packages on Linux
To find the version of the packages on linux
rpm -qa|grep
Kernel Version of Unix
You can find the version of your kernel on UNIX by the following command
uname -a
Bit of Operating System
You can check the bit size of your OS by using the following command
$ isainfo -b
Bit of your Oracle Software
To check if your Oracle Binary is 32 bit or 64 bit you can use the file command on any of the oracle executables like
$ file $ORACLE_HOME/bin/oracle
Finding Oracle data block size
SQL> SHOW PARAMETER DB_BLOCK_SIZE
df -g | grep "block size" (in Solrieas)
