Determine the OS version of a Linux Release/Kernel and Oracle Apps/DB
[oracle@uswjusvr115 scripts]$ cat /proc/version
Linux version 2.6.39-400.17.1.el6uek.x86_64 (mockbuild@ca-build44.us.oracle.com) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-3) (GCC) ) #1 SMP Fri Feb 22 18:16:18 PST 2013
*NOTE: uek = Unbreakable Enterprise Kernel
[oracle@uswjusvr115 scripts]$ getconf LONG_BIT
64
[oracle@uswjusvr115 scripts]$ uname -a
Linux uswjusvr115.affiniagroup.net 2.6.39-400.17.1.el6uek.x86_64 #1 SMP Fri Feb 22 18:16:18 PST 2013 x86_64 x86_64 x86_64 GNU/Linux
[oracle@uswjusvr115 scripts]$ uname -mrs
Linux 2.6.39-400.17.1.el6uek.x86_64 x86_64
[oracle@uswjusvr115 scripts]$ cat /etc/issue
Oracle Linux Server release 6.6
Kernel \r on an \m
SQL Command:
[oracle@uswjusvr115 scripts]$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 27 10:15:01 2015
SQL> select banner from v$version;
BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
PL/SQL Release 11.2.0.3.0 – Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 – Production
NLSRTL Version 11.2.0.3.0 – Production
SQL> SELECT INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME,VERSION FROM gv$instance;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION
1 ebsprd uswodsvr115.affiniagroup.net 11.2.0.3.0
SQL> conn apps/apps
Connected.
SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
————————————————–
12.1.3