Find the OS Version and Kernel on Linux

 Type the following command to find Linux kernel version: uname -r.

[oracle@testmachine1 Oracle]$ uname -r
3.10.0-1160.81.1.el7.x86_64

 

Type any one of the following command to find os name and version in Linux: cat /etc/os-release. ...

[oracle@testmachine Oracle]$ cat /etc/os-release
NAME="Red Hat Enterprise Linux Server"
VERSION="7.9 (Maipo)"
ID="rhel"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="7.9"
PRETTY_NAME="Red Hat Enterprise Linux"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:redhat:enterprise_linux:7.9:GA:server"
HOME_URL="https://www.redhat.com/"
BUG_REPORT_URL="https://bugzilla.redhat.com/"

REDHAT_BUGZILLA_PRODUCT="Red Hat Enterprise Linux 7"
REDHAT_BUGZILLA_PRODUCT_VERSION=7.9
REDHAT_SUPPORT_PRODUCT="Red Hat Enterprise Linux"
REDHAT_SUPPORT_PRODUCT_VERSION="7.9"

SQL Query to get failed provisioning tasks for an application in OIM

SQL Query to get failed provisioning tasks for an application in OIM

SELECT
    USR.USR_LOGIN,
    OSI.SCH_KEY,
    SCH.SCH_STATUS,
    STA.STA_BUCKET,
    MIL.MIL_NAME,
    OST.OST_STATUS
FROM
    OSI
JOIN SCH ON OSI.SCH_KEY = SCH.SCH_KEY
JOIN STA ON STA.STA_STATUS = SCH.SCH_STATUS
JOIN MIL ON OSI.MIL_KEY = MIL.MIL_KEY
JOIN TOS ON MIL.TOS_KEY = TOS.TOS_KEY
JOIN PKG ON TOS.PKG_KEY = PKG.PKG_KEY
JOIN OIU ON OSI.ORC_KEY = OIU.ORC_KEY
JOIN USR ON OIU.USR_KEY = USR.USR_KEY
JOIN OST ON OIU.OST_KEY = OST.OST_KEY
JOIN OBJ ON OST.OBJ_KEY = OBJ.OBJ_KEY
WHERE
    OBJ.OBJ_NAME = 'AD User'
    AND OST.OST_STATUS = 'Provisioning'
    AND STA.STA_BUCKET in ('Pending','Rejected')
    AND PKG.PKG_NAME = 'AD User';
    AND MIL.MIL_NAME = 'System Validation';