Versions Compared

Old Version 26

changes.mady.by.user Allena Kendrick (Unlicensed)

Saved on

compared with

New Version 27

changes.mady.by.user Allena Kendrick (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Page Properties


Platform OwnerDeanna Burns (Unlicensed)
Document status
Status
colourGreen
titleWork in Progress
SN Discovery SMEAllena Kendrick (Unlicensed)
Business Analyst@Vandana Bansal
CI Owner

Harshal Dixit


CMDB ManagerChristopher Abbott (Unlicensed)
PMDavid Swanson (Unlicensed)
SN CMDB LeadVimalpriya Kothandapani (Unlicensed)


...

#Requirement
User Story

ImportanceChallengeNotes
1security 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.

 


 







2important

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 Details







5


Oracel listener.sh value:

get_instances() {
ORACLE_HOME=$ORA_HOME
export ORACLE_HOME
INSTANCES=`${ORA_HOME}/bin/lsnrctl status $LISTENER 2>&1 | sed -ne 's/Instance "\(.*\)", status READY.*/\1/p' | tr -d ' ' | uniq | tr '\n' ' '`
[ "$INSTANCES" != "" ] && echo "snc_ora_instances=$INSTANCES" && return
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
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






6

 set glide.required.attribute.enabled to false




Probes


Oracle Probes

Oracle Instance

  • Horizontal discovery probe: launches patterns
  • Powershell-Oracle - Instance PFile (for Windows)*
  • Powershell-Oracle - Instance Version (for Windows)*
  • SSHCommand-Oracle - Instance Details (for Linux)*



...