set mid.property.ssh.use_snc = true to address the dmidecode issue
Changed glide.required.attribute.enabled to false to ignore the mandatory fields
Restart Mid-Sever

2

Probes

Image Removed

...

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)*

Patterns

Image Removed

...

Application patterns:

Oracle DB On Windows Pattern
Oracle DB on UNIX Pattern

This shared library pattern used by the Linux Server pattern:

UNIX Cluster - ORACLE Clusterware

Note: This shared library pattern is triggered if the crsd.bin process is running on the Oracle database server.

Oracle Discovery Data Collections

Data collected on UNIX machines

...

From the output of the ORA_HOME/bin/sqlplus /NOLOG command
From the output of the ORA_HOME/bin/lsnrctl status command
From the path of ORA_HOME

...

oracle_home/dbs/spfileSID.ora
oracle_home/dbs/spfile.ora
oracle_home/dbs/initSID.ora

...

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. https://yalesandbox.service-now.com/$sn_pattern_designer.do?authoring_mode=modify&sys_id=28d607dbfead4be3887c843814455105&sysparm_view=&sysparm_record_target=&sysparm_record_row=1&sysparm_record_list=nameCONTAINSoracle%5EORDERBYname&sysparm_record_rows=14 Image Added
2	important		Image Added 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. Image Added
4			Oracle = Listener Details Image Added 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 \| 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
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

Image Added

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)*

Patterns

Image Added

Oracle Patterns
Application patterns: Oracle DB On Windows Pattern Oracle DB on UNIX Pattern This shared library pattern used by the Linux Server pattern: UNIX Cluster - ORACLE Clusterware Note: This shared library pattern is triggered if the `crsd.bin` process is running on the Oracle database server.

Oracle Discovery Data Collections

Data collected on UNIX machines

Label	Field name	Additional information
SID	sid	Obtained from the name of the process that starts with `ora_pmon_`
Install directory	install_directory	Obtained from the path of ORA_HOME
Version	version	Obtained in this order: From the output of the `ORA_HOME/bin/sqlplus /NOLOG` command From the output of the `ORA_HOME/bin/lsnrctl` status command From the path of ORA_HOME
Parameter file	pfile	The following locations are explored for the location of the System Parameter File. If this file does not exist in one of the explored locations, Discovery does not find the file and reports an error. oracle_home/dbs/spfileSID.ora oracle_home/dbs/spfile.ora oracle_home/dbs/initSID.ora
Oracle Home	oracle_home	Obtained from the ORATAB file.
Edition	edition

Data collected on Windows machines

Label	Field name	Additional information
SID	sid	Obtained from the process parameter that is passed to the oracle.exe process.
Install directory	install_directory
Version	version	Obtained from the output of the ORA_HOME/bin/sqlplus.exe -V command.
Parameter file	pfile	The following locations are explored for the location of the System Parameter File. If this file does not exist in one of the explored locations, Discovery does not find the file and reports an error. oracle_home\database\spfileSID.ora oracle_home\database\spfile.ora oracle_home\database\initSID.ora
Oracle Home	oracle_home	Parsed from the path of oracle.exe
Edition	edition

cmdb_ci_db_ora_instance Data attributes

u_ = added fields

x_pd_integration_pagerduty_webhookString Userrunning_process_parameters65,000u_secondary_supportReference User32u_accessibility_contactUseruothercontractual_informationString10assetReference Asset32checkedinu_last_tac_approvalDateregulated_info25532 commandcommandmonitor40pfileString8,000recoverytimeobjective_rto40javascript:GlideDBObjectManager.get().ge...512

MandatorySort in ascending order	TypeSort in ascending order	ReferenceSort in ascending order	Max lengthSort in ascending order	Default valueSort in ascending order	DisplaySort in ascending order
Host Environment	u_host_environment	true	String	(empty)	40		false
Lifecycle Classification	u_lifecycle_classification	true	String	(empty)	40		false
University Sponsor Leader	u_univ_sponsor_lead	true	Reference	User	32		false
University Areas	u_university_areas	true	List	University Area	1,024		false
Sys ID	sys_id	true	Sys ID (GUID)	(empty)	32		false
Used by	u_used_by	true	List	Applications Used By	1,024		false
Package Type	u_package_type	true	String	(empty)	40		false
Name	name	true	String	(empty)	255		true
Host Type	u_host_type	true	Reference	Host Type	32		false
Operational status	operational_status	true	Integer	(empty)	100	1	false
Description	short_description	true	String	(empty)	1,000		false
Can Print	can_print	false	True/False	(empty)	40	false	false
Skip sync	skip_sync	false	True/False	(empty)	40	false	false
Most recent discovery	last_discovered	false	Date/Time	(empty)	40		false
Lifecycle Date	u_lifecycle_date	false	Date	(empty)	40		false
Configuration directory	config_directory	false	String	(empty)	255		false
Classifier	classifier	false	Reference	Process Classification	32		false
Business Value Score	u_business_value_score	false	Choice	(empty)	40		false
Operational Controls	u_operational_controls	false	String	(empty)	40		false
Clustered	u_clustered	false	True/False	(empty)	40		false
Other High Risk	u_other_high_risk	false	String	(empty)	200		false
Fault count	fault_count	false	Integer	(empty)	40	0	false
Functional Contact	managed_by	false	Reference	User	32		false
Decommission Date	u_decommission_date	false	Date	(empty)	40		false
GL account	gl_account	false	String	(empty)	40		false
PID	pid	false	Integer	(empty)	40		false	PagerDuty webhook
Last SDR Approval Date	u_last_sdr_approval_date	false
Date	(empty)	40		false	Updated by	sys_updated_by	false	String	(empty)	40	false
Recovery Tier Justification	u_recovery_tier_justificationFuture Platform Components	u_future_platform_components	false	List Recovery Tier Justification	Platform Component	1,024		false
SOX Cost	u_soxcost	falseTrue/False	Floating Point Number	(empty)	40		false
Requires verification	unverifiedPO number	po_number	false	True/False String	(empty)	40		false
Recovery Tier Cost currency	ucost_recovery_tiercc	false	String	(empty)	340	USD	false
Quickbase Application ID Is a Disaster Recovery Plan Required?	u_quickbasedr_plan_idrequired	false	String	(empty)	40	No	false
Configuration file Order received	configdelivery_filedate	falseString	Date/Time	(empty)	25540		false
Status Domain	installsys_statusdomain	falseInteger	Domain ID	(empty)	4032	global	false
Supported by	supported_byPrimary Support	u_primary_support	false	Reference	User	32		false
Start date Notes	startu_datenotes	false	Date/Time Journal	(empty)	404,000		false
Data Sensitivity programming ver exp	u_dataprogramming_ver_classificationexp	false	String	(empty)	40		false
Created by Environment	sysu_created_byenvironment	false	String	(empty)	40		false
Maintenance schedule	maintenance_schedule	false	Reference	Schedule	32	false

Application Scope	u_application_scope
Category	category	false	String	(empty)	40
false
Owned by	owned_byjavascript:gs.include("CMDBItem");var it...	false
Support Vendor	u_support_vendor	false	Reference
Company	32		false	Running process parameters
Platform Components	u_platform_components	false
String	(empty)
List	Platform Component	1,024		false	Secondary Support
TCP port(s)	tcp_port	false
String
(empty)
255		false	Accessibility Contact
Manufacturer	manufacturer	false	Reference
Company	32		falseRegulated Information
Class
sys_
class_
name	false
System Class Name	(empty)
80	javascript:current.getTableName();	false	Asset
Used for	used_for	false	String
(empty)
40
Production	falseChecked in
Installed
install_
date	false	Date/Time	(empty)	40		false	Last TAC Approval Date
PagerDuty service	x_pd_integration_pagerduty_service	false
String	(empty)	40		falseExternal Obligations
Accessibility Support Group	u_
false	List	Regulated Information	4,000	false
Support group	accessibility_support_group	false	Reference	Group	32	b0dea7a56f1771007ee2abcf9f3ee477	false
DR Plan ID #	u_dr_plan_idCredentialless Discovery Port	cl_port	false	String Integer	(empty)	40		false
DNS Domain	dns_domainPagerDuty webhook	x_pd_integration_pagerduty_webhook	false	String	(empty)	25540		false
Purchased	purchase_dateUpdated by	sys_updated_by	false	Date String	(empty)	40		false
Listener name	listener_nameRecovery Tier Justification	u_recovery_tier_justification	false	String	(empty)	List	Recovery Tier Justification	1,024		false
Ordered SOX	orderu_datesox	false	DateTrue/TimeFalse	(empty)	40		false
Serial number	serial_numberRequires verification	unverified	falseString	True/False	(empty)	25540		false
Display name Recovery Tier	u_displayrecovery_nametier	false	String	(empty)	25540		false
Vendor	vendorQuickbase Application ID	u_quickbase_id	false	Reference String Company	(empty)	3240		false
Company	companyConfiguration file	config_file	false	Reference String Company	(empty)	32255		false
Running process key parameters	running_process_key_parametersStatus	install_status	false	String Integer	(empty)	65,00040		false
Lease contract Supported by	leasesupported_idby	false	String Reference	(empty)User	4032		false
Third Party Support	u_third_party_supportStart date	start_date	false	Reference	Company	Date/Time	(empty)	40		false
Pfile/ Spfile Data Sensitivity	u_pfilespfiledata_classification	false	String	(empty)	40		false
Latest Risk Assessment	u_risk_assessment_idCreated by	sys_created_by	false	String	(empty)	40		false
Asset tag Maintenance schedule	assetmaintenance_tagschedule	false	String Reference	(empty)Schedule	4032		false
Production Start Date Application Scope	u_productionapplication_datescope	false	Date String	(empty)	40		false
License Count Owned by	uowned_license_countby	false	String Reference	(empty)User	4032		false
Target Decommissioning Date	u_target_decommissioning_date	false	Date	(empty)	40	false	Running process
parameters	running_process_
parameters	false	String	(empty)	65,000		false	Monitor
Secondary Support	u_secondary_support	false
True/False	(empty)
Reference	User	32		false
false

Pfile
Accessibility Contact	u_accessibility_contact	false
Reference
(empty)
User	32		falseRecovery Time Objective (RTO)
Regulated Information	u_
other_
contractual_
information	false	String	(empty)
10		false
Asset	asset	false	Reference	Asset	32		false
sys_class_path	sys_class_pathChecked in	checked_in	falseSystem Class path	Date/Time	(empty)	255	40		false
Technology Fit Score Last TAC Approval Date	u_technologylast_fittac_scoreapproval	false	Choice Date	(empty)	40		false
Correlation ID	correlation_idExternal Obligations	u_regulated_info	false	String	(empty)	List	Regulated Information	4,000		false
Version	versionSupport group	support_group	false	String Reference	(empty)Group	25532		false

License Type


DR Plan ID #	u_

license

dr_plan_

type

id

false

String

(empty)

40

false

SDR #

DNS Domain

u_last_sdr_number

dns_domain

false

Integer

String

(empty)

40

255

false

Justification

Purchased

justification

purchase_date

false

String

Date

(empty)

80

40

false

Oracle Home

Listener name

oracle

listener_

home

name

false

String

(empty)

255

false

Functional Owning Organization

Ordered

u_functional_owning_org

order_date

false

String

Date/Time

(empty)

40

false

Editionedition


Serial number	serial_number	false	String	(empty)

100

255

false

Hosting


Display name	u_

hosting

display_name

false

String

(empty)

40

	255		false
Vendor	vendor	false	Reference	Company	32		false

Assigned toassigned_to


Company	company	false	Reference

Useru_target_cloud_deployment

Company

32

false

Target Cloud Deployment

Running process key parameters

running_process_key_parameters

false

String

(empty)

40

65,000

false

DR Plan Next Testing Dateu_dr_plan_next_test


Lease contract	lease_id	false

Date

String

(empty)

40

false

DR Plan Next Approval Date


Third Party Support	u_

dr

third_

plan

party_

next_approval

support

false

Date

Reference

(empty)

Company

40

32

false

Subcategorysubcategoryassigned


Pfile/ Spfile	u_pfilespfile	false	String	(empty)	40		false

Assigned

Latest Risk Assessment

u_risk_assessment_id

false

Date/Time

String

(empty)

40

false

Invoice number

Asset tag

invoice

asset_

number

tag

false

String

(empty)

40

false

Data Types


Production Start Date	u_

data

production_

security_classification1,024

date

false

List Data Security Classification Type

Date

(empty)

40

false

SIDsidsys_created_on


License Count	u_license_count	false	String	(empty)	40		false

Created

Target Decommissioning Date

u_target_decommissioning_date

false

Date

/Time

(empty)

40

false

Project Number and Nameu_project_number_and_name


Running process command	running_process_command	false	String	(empty)

40checked_out

65,000

false

Checked out

Monitor

monitor

false

Date

True/

TimeAttributesattributesfalse

False

(empty)

40

false

Running processrunning_processfalseReference Running Process32false

false
Pfile	pfile	false	String	(empty)

65sys_domain_path

8,000

false

Domain Path

Recovery Time Objective (RTO)

u_recovery_time_objective_rto

false

(empty)

String

(empty)

255

40

false

Updated


sys_class_path	sys_

updated

class_

on

path

false

Date/Time Business Criticalityu_business_criticalityfalseString

System Class path

(empty)

40false

255	javascript:GlideDBObjectManager.get().ge...	false
Technology Fit Score	u_technology_fit_score	false	Choice	(empty)	40		false

Model

Correlation ID

model32

correlation_id

false

Reference Product Model

String

(empty)

512

false

Other Moderate Risku_other_moderate_risk


Version	version	false	String	(empty)

200

255

false

instancefuturehostenvironment_monitoringTrue/Falseis_clusteredTrue/Falserp_command_hash255ip_addressString255locationReference Location32software_install32first_discoveredDate/Timewarranty_expirationmodel_number255u_future_host_typ32uplatformQuickbase Platforms40assignment_groupReference32u_dr_plan_last_testDate40due_inStringcomments4,000costcenterCost Centeralias100dueDate/Timeprogramminglang1,024sys_mod_countIntegermacaddressString(empty)40ureference_1bac72b5137130200f212cc028e41f1b8rp_key_parameters_hashdr_plan_last_approvalDatediscovery_sourcedepartment32uapplication_ismeChoiceu_accessibility40scheduleReference Schedule32

Instance
License Type	u_license_type	false	String	(empty)	40		false
SDR Information#	u_last_sdr_informationnumber	false	String Integer	(empty)	40		false
Recovery Point Objective (RPO)	u_recovery_point_objective_rpoJustification	justification	false	String	(empty)	4080		false
Approval group Oracle Home	changeoracle_controlhome	false	Reference String Group	(empty)	32255		false
Installation directory	install_directoryFunctional Owning Organization	u_functional_owning_org	false	String	(empty)	25540		false
Fully qualified domain name	fqdnEdition	edition	false	String	(empty)	255100		false
Risk Classification Hosting	u_risk_levelhosting	false	String	(empty)	40		false
Future Host Environment Assigned to	assigned_to	false	Reference	User	32		false
Target Cloud Deployment	u_
target_
cloud_
deployment	false	String	(empty)	40		falseMonitoring
DR Plan Next Testing Date	u
_dr_plan_next_test	false
Date	(empty)	40		false	Is clustered
DR Plan Next Approval Date	u_dr_plan_next_approval	false
Date	(empty)	40		false	Running process command hash
Subcategory	subcategory	false	String	(empty)
40		false	Management IP Address
Assigned	assigned	false
Date/Time	(empty)
40		false	Location
Invoice number	invoice_number	false
String
(empty)
40		false	Software Install
Data Types	u_data_security_classification	false
Reference	Software Installation
List	Data Security Classification Type	1,024		false	First discovered
SID	sid	false
String	(empty)	40		false	Warranty expiration
Created	sys_created_on	false	Date/Time	(empty)	40		false	Model number
Project Number and Name	u_project_number_and_name	false	String	(empty)
40		false	Future Host Type
Checked out	checked_out	false
Reference	Host Type
Date/Time	(empty)	40		falsePlatform
Running process
running_
process	false	Reference
Running Process
32		false	Assignment group
Attributes	attributes	false
String
Group
(empty)	65,000		false	DR Plan Last Tested Date
Domain Path	sys_domain_path	false
(empty)	(empty)
255		false	Due in
Updated	sys_updated_on	false
Date/Time	(empty)	40		false	Comments
Business Criticality	u_business_criticality	false	String	(empty)
40		falseCost center
Model ID
model_
id	false	Reference
Product Model	32		falseAlias
Other Moderate Risk	u_
other_moderate_risk	false	String	(empty)
200		falseDue
Instance
instance	false
String	(empty)	40		falseProgramming Lang
SDR Information	u_
sdr_
information	false
List	Programming Language
String	(empty)	40		false	Updates
Recovery Point Objective (RPO)	u_recovery_point_objective_rpo	false
String	(empty)	40		falseMAC Address
Approval group
change_
control	false
Reference
Group
32		falseData Center
Installation directory
install_
directory	false
Reference	Data Center	32
String	(empty)	255		false	Running process key parameters hash
Fully qualified domain name	fqdn	false	String	(empty)	255		falseDR Plan Last Approved
Risk Classification	u_
risk_level	false
String	(empty)	40		false	Discovery source
Future Host Environment	u_future_host_environment	false	String	(empty)	40		falseDepartment
Monitoring
u_monitoring	false
Reference	Department
True/False	(empty)	40		falseApplication ISME
Is clustered
is_
clustered	false
True/False	(empty)	40		false	Accessibility
Running process command hash	rp_command_hash	false	String	(empty)
255		false	Schedule
Management IP Address	ip_address	false
String
(empty)
255		false	Service Name	u_service_name	false	String	(empty)	40	false

User Interface

Main Form

...

Location	location	false	Reference	Location	32		false
Software Install	software_install	false	Reference	Software Installation	32		false
First discovered	first_discovered	false	Date/Time	(empty)	40		false
Warranty expiration	warranty_expiration	false	Date	(empty)	40		false
Model number	model_number	false	String	(empty)	255		false
Future Host Type	u_future_host_typ	false	Reference	Host Type	32		false
Platform	u_platform	false	Reference	Quickbase Platforms	40		false
Assignment group	assignment_group	false	Reference	Group	32		false
DR Plan Last Tested Date	u_dr_plan_last_test	false	Date	(empty)	40		false
Due in	due_in	false	String	(empty)	40		false
Comments	comments	false	String	(empty)	4,000		false
Cost center	cost_center	false	Reference	Cost Center	32		false
Alias	u_alias	false	String	(empty)	100		false
Due	due	false	Date/Time	(empty)	40		false
Programming Lang	u_programming_lang	false	List	Programming Language	1,024		false
Updates	sys_mod_count	false	Integer	(empty)	40		false
MAC Address	mac_address	false	String	(empty)	40		false
Data Center	u_reference_1	false	Reference	Data Center	32	bac72b5137130200f212cc028e41f1b8	false
Running process key parameters hash	rp_key_parameters_hash	false	String	(empty)	255		false
DR Plan Last Approved	u_dr_plan_last_approval	false	Date	(empty)	40		false
Discovery source	discovery_source	false	String	(empty)	40		false
Department	department	false	Reference	Department	32		false
Application ISME	u_application_isme	false	Choice	(empty)	40		false
Accessibility	u_accessibility	false	String	(empty)	40		false
Schedule	schedule	false	Reference	Schedule	32		false
Service Name	u_service_name	false	String	(empty)	40		false

User Interface

Main Form

Image Added

User Interface Requirement

Currently discovery process is not getting them Security Patch Level. This is really important for them. He just wants to capture the top row (latest security patch) brought back through the command. Please let me know if this is doable. If it is doable we can add the data attribute to the UI. Right now it is maintained manually in spreadsheets (not always up-to-date).

Having it is Important because Oracle team have to follow ISO requirement of keeping Oracle Databases with up to date with all the security vulnerabilities out there and only way to do is - by applying the patches that comes out quarterly.

Relationships

Tracked Configuration Files

Dependency View

Relationships

Validation Steps

Step	Description	Verdict

Open Questions

Question	Answer	Date Answered

Versions Compared

Old Version 13

New Version Current

Key

Report Metrics

Technical Requirements

cmdb_ci_db_ora_instance Data attributes

Probes

Patterns

Oracle Discovery Data Collections

Data collected on UNIX machines

Probes

Patterns

Oracle Discovery Data Collections

Data collected on UNIX machines

cmdb_ci_db_ora_instance Data attributes

User Interface

Main Form

User Interface

Main Form

User Interface Requirement

Relationships

Tracked Configuration Files

Dependency View

Relationships

Validation Steps

Open Questions

Out of Scope

Page Comparison

Versions Compared

Old Version 13

New Version Current

Key

Report Metrics

Technical Requirements

cmdb_ci_db_ora_instance Data attributes

Probes

Patterns

Oracle Discovery Data Collections

Data collected on UNIX machines

Probes

Patterns

Oracle Discovery Data Collections

Data collected on UNIX machines

cmdb_ci_db_ora_instance Data attributes

User Interface

Main Form

User Interface

Main Form

User Interface Requirement

Relationships

Tracked Configuration Files

Dependency View

Relationships

Validation Steps

Open Questions

Out of Scope