Determine the OS version of a Linux Release/Kernel and Oracle Apps/DB

OS Commands:

[oracle@uswjusvr115 scripts]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.6 (Santiago)

[oracle@uswjusvr115 scripts]$ cat /etc/oracle-release
Oracle Linux Server release 6.6

[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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s