Monday, December 9, 2013

find ADF and weblogic and OS and database versions in oracle database

Finding ADF version:

$ cd $ORACLE_HOME
$ find . -name adf-share-support.jar -print
./oracle_common/modules/oracle.adf.share_11.1.1/adf-share-support.jar
$ mkdir ~/check-adf
$cp ./oracle_common/modules/oracle.adf.share_11.1.1/adf-share-support.jar ~/check-adf
$cd ~/check-adf
$jar -xf adf-share-support.jar
$ cat META-INF/MANIFEST.MF
Manifest-Version: 1.0
Ant-Version: Apache Ant 1.7.0RC1
Created-By: 17.0-b17 (Sun Microsystems Inc.)
Oracle-Version: 11.1.1.4.37.59.23
Oracle-Label: JDEVADF_11.1.1.4.0_GENERIC_101227.1736.5923
Oracle-Builder: Official Builder
Oracle-BuildSystem: Linux - java - 1.6.0_21-b51
Oracle-BuildTimestamp: 2010-12-27 08:47:35 -0800

Finding Weblogic Version:

When we logging in the weblogic server administration console (front end): (refer the following picture)





Finding OS version

SQL> select dbms_utility.port_string from dual;

PORT_STRING
--------------------
x86_64/Linux 5.5.xx


Finding Database Version, Plsql version, NLSRTL version

SQL> SELECT PRODUCT, VERSION FROM SYS.PRODUCT_COMPONENT_VERSION;

PRODUCT
--------------------------------------------------------------------------------
VERSION
--------------------------------------------------------------------------------
NLSRTL
11.2.0.3.0

Oracle Database 11g Enterprise Edition
11.2.0.3.0

PL/SQL
11.2.0.3.0


PRODUCT
--------------------------------------------------------------------------------
VERSION
--------------------------------------------------------------------------------
TNS for Linux:
11.2.0.3.0

No comments :

Post a Comment