| Page Properties | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
| # | Requirement | User Story | Importance | Challenge | Notes | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | security patch Level |
To capture the attribute security patch level. We will need to use 'OPatch' and 'lsinventory' commands which lists all the patches applied to the oracle db and then parse the latest patch that has been applied. You will have to add a 'extension section' to the oracle pattern, to add extra steps to run this command, and then parse the output, to extract the value you want to put in the attribute/ field of the CI. Here is the pattern.
| ||||||||
| 2 | important |
glide.required.attribute.enabled Set to false | ||||||||
| 3 | Proposed View modification that we would like to see which includes the latest security patches applied to that Instance as well – that is one of the most important piece of information we would like to see on this form/view. | |||||||||
| 4 | Oracle = Listner Listener Details
| 5 |
Oracel listener.sh value: get_instances() { VERSION ORA_HOME=$1 LISTENER=$2 TNS_ADMIN="/ora_admin/tns_admin" FAILED=0 ERR="" get_config() { CONFIG_PATH="${TNS_ADMIN}/listener.ora" FAILED=`sudo cat $CONFIG_PATH 1> /dev/null 2>&1; echo $?` [ "$FAILED" != 0 ] && ERR="Could not read listener.ora: $CONFIG_PATH. $ERR" && return echo "snc_listener.ora_contents=" sudo cat $CONFIG_PATH } get_instances() { ORACLE_HOME=$ORA_HOME export ORACLE_HOME INSTANCES=`${ORA_HOME}/bin/lsnrctl status $LISTENER 2>&1 | grep Version | sed -ne 's/ .*: Version Instance "\( [0-9. ]*\) .", status READY.*/\1/p' | tr -d ' ' | uniq | tr '\n' ' '` [ " $VERSION$INSTANCES" != "" ] && echo "snc_ora_ versioninstances= $VERSION$INSTANCES" && return VERSION=`echo $ORA_HOME | sed -ne FAILED=1 ERR="Unable to accurately determine listener<->instance relationships. $ERR" } get_version() { VERSION=`${ORA_HOME}/bin/lsnrctl status 2>&1 | grep Version | sed -ne 's/.* \/: Version \([0-9.]*\) \/ .*/\1/p'` [ "$VERSION" != "" ] && echo "snc_ora_version=$VERSION" && return FAILED=1ERR="Could VERSION=`echo $ORA_HOME | sed -ne 's/.*\/\([0-9.]*\)\/.*/\1/p'` [ "$VERSION" != "" ] && echo "snc_ora_version=$VERSION" && return FAILED=1 ERR="Could not determine Oracle listener version. $ERR" } get_version get_instances get_config [ "$FAILED" != 0 ] && echo "snc_error=$ERR" exit 0 | |||||||
| 5 | ||||||||||
| 6 | set glide.required.attribute.enabled to false | |||||||||
| 7 | SID | The solution for this issue is to make sure the identification section "Identification for Oracle DB entry point type(s) - no instance" . executes before "dentification for Oracle DB entry point type(s) - no instance on Solaris" - So i have changed the order on the pattern for the correct identification section to be executed first. - To confirm the issue has been resolved, i ran a discovery on vm-ktkdevdb-01 (172.18.24.33) . See DIS0010142 Now the SID is updated on the oracle instances https://yalesandbox.service-now.com/cmdb_ci_db_ora_instance.do?sys_id=8973fd411bf1005493463153cd4bcb26&sysparm_view= https://yalesandbox.service-now.com/cmdb_ci_db_ora_instance.do?sys_id=bad41982db7d48107150132968961938&sysparm_view= | ||||||||
| 8 | security Patch Level |
Probes
| Oracle Probes |
|---|
Oracle Instance
|
...