...
Report Metrics
Technical Requirements
| # | Requirement |
| User Story |
|
| Importance | Challenge | Notes |
|---|
| 1 |
Mid Server | Update Mid-Server Parameters | set mid.property.ssh.use_snc = true to address the dmidecode issue 2 | Changed glide.required.attribute.enabled to false to ignore the mandatory fields Restart Mid-Sever| 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.
 Image Modified
|
3
|
|
|
|
|
| 2 | important |
|  Image Modified
glide.required.attribute.enabled
Set to false |
4
|
|
|
|
|
| 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.  Image Modified
|
5
|
|
|
|
|
|
| 4 |
|
|
Oracle = Listner Details  Image Modified
|
6 |
|
|
|
|
|
| 5 |
|
|
 Image Modified
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 |
|
|
|
|
|
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)*
|
|
|
|
...