...
Status | ||||
---|---|---|---|---|
|
...
Deanna Burns
Table of Contents |
---|
Report Metrics
Technical Requirements
...
- 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
...
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
...
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
...
- oracle_home\database\spfileSID.ora
- oracle_home\database\spfile.ora
- oracle_home\database\initSID.ora
...
Page Properties | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Table of Contents |
---|
Report Metrics
Technical Requirements
# | Requirement | User Story | Importance | Challenge | Notes |
---|---|---|---|---|---|
1 | |||||
2 |
Probes
Probes |
---|
N/A for Bottom up discovery |
Patterns
Patterns |
---|
N/A for Bottom Up discovery |
Discovery Data Collections
Data collected on UNIX machines
Label | Field name | Additional information |
---|---|---|
N/A | ||
Edition | edition |
cmdb_ci_
...
appl Data attributes
u_ = added fields
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 | ||
Last SDR Approval Date | u_last_sdr_approval_date | false | Date | (empty) | 40 | false | ||
Future Platform Components | u_future_platform_components | false | List | Platform Component | 1,024 | false | ||
Cost | cost | false | Floating Point Number | (empty) | 40 | false | ||
PO number | po_number | false | String | (empty) | 40 | false | ||
Cost currency | cost_cc | false | String | (empty) | 3 | USD | false | |
Is a Disaster Recovery Plan Required? | u_dr_plan_required | false | String | (empty) | 40 | No | false | |
Order received | delivery_date | false | Date/Time | (empty) | 40 | false | ||
Domain | sys_domain | false | Domain ID | (empty) | 32 | global | false | |
Primary Support | u_primary_support | false | Reference | User | 32 | false | ||
Notes | u_notes | false | Journal | (empty) | 4,000 | false | ||
programming ver exp | u_programming_ver_exp | false | String | (empty) | 40 | false | ||
Environment | u_environment | false | String | (empty) | 40 | false | ||
Category | category | false | String | (empty) | 40 | javascript:gs.include("CMDBItem");var it... | false | |
Support Vendor | u_support_vendor | false | Reference | Company | 32 | false | ||
Platform Components | u_platform_components | false | List | Platform Component | 1,024 | false | ||
TCP port(s) | tcp_port | false | String | (empty) | 255 | false | ||
Manufacturer | manufacturer | false | Reference | Company | 32 | false | ||
Class | sys_class_name | false | System Class Name | (empty) | 80 | javascript:current.getTableName(); | false | |
Used for | used_for | false | String | (empty) | 40 | Production | false | |
Installed | install_date | false | Date/Time | (empty) | 40 | false | ||
PagerDuty service | x_pd_integration_pagerduty_service | false | String | (empty) | 40 | false | ||
Accessibility Support Group | u_accessibility_support_group | false | Reference | Group | 32 | b0dea7a56f1771007ee2abcf9f3ee477 | false | |
Credentialless Discovery Port | cl_port | false | Integer | (empty) | 40 | false | ||
PagerDuty webhook | x_pd_integration_pagerduty_webhook | false | String | (empty) | 40 | false | ||
Updated by | sys_updated_by | false | String | (empty) | 40 | false | ||
Recovery Tier Justification | u_recovery_tier_justification | false | List | Recovery Tier Justification | 1,024 | false | ||
SOX | u_sox | false | True/False | (empty) | 40 | false | ||
Requires verification | unverified | false | True/False | (empty) | 40 | false | ||
Recovery Tier | u_recovery_tier | false | String | (empty) | 40 | false | ||
Quickbase Application ID | u_quickbase_id | false | String | (empty) | 40 | false | ||
Configuration file | config_file | false | String | (empty) | 255 | false | ||
Status | install_status | false | Integer | (empty) | 40 | false | ||
Supported by | supported_by | false | Reference | User | 32 | false | ||
Start date | start_date | false | Date/Time | (empty) | 40 | false | ||
Data Sensitivity | u_data_classification | false | String | (empty) | 40 | false | ||
Created by | sys_created_by | false | String | (empty) | 40 | false | ||
Maintenance schedule | maintenance_schedule | false | Reference | Schedule | 32 | false | ||
Application Scope | u_application_scope | false | String | (empty) | 40 | false | ||
Owned by | owned_by | false | Reference | User | 32 | false | ||
Running process parameters | running_process_parameters | false | String | (empty) | 65,000 | false | ||
Secondary Support | u_secondary_support | false | Reference | User | 32 | false | ||
Accessibility Contact | u_accessibility_contact | false | Reference | User | 32 | false | ||
Regulated Information | u_other_contractual_information | false | String | (empty) | 10 | false | ||
Asset | asset | false | Reference | Asset | 32 | false | ||
Checked in | checked_in | false | Date/Time | (empty) | 40 | false | ||
Last TAC Approval Date | u_last_tac_approval | false | Date | (empty) | 40 | false | ||
External Obligations | u_regulated_info | false | List | Regulated Information | 4,000 | false | ||
Support group | support_group | false | Reference | Group | 32 | false | ||
DR Plan ID # | u_dr_plan_id | false | String | (empty) | 40 | false | ||
DNS Domain | dns_domain | false | String | (empty) | 255 | false | ||
Purchased | purchase_date | false | Date | (empty) | 40 | false | ||
Listener name | listener_name | false | String | (empty) | 255 | false | ||
Ordered | order_date | false | Date/Time | (empty) | 40 | false | ||
Serial number | serial_number | false | String | (empty) | 255 | false | ||
Display name | u_display_name | false | String | (empty) | 255 | false | ||
Vendor | vendor | false | Reference | Company | 32 | false | ||
Company | company | false | Reference | Company | 32 | false | ||
Running process key parameters | running_process_key_parameters | false | String | (empty) | 65,000 | false | ||
Lease contract | lease_id | false | String | (empty) | 40 | false | ||
Third Party Support | u_third_party_support | false | Reference | Company | 32 | false | ||
Pfile/ Spfile | u_pfilespfile | false | String | (empty) | 40 | false | ||
Latest Risk Assessment | u_risk_assessment_id | false | String | (empty) | 40 | false | ||
Asset tag | asset_tag | false | String | (empty) | 40 | false | ||
Production Start Date | u_production_date | false | Date | (empty) | 40 | false | ||
License Count | u_license_count | false | String | (empty) | 40 | false | ||
Target Decommissioning Date | u_target_decommissioning_date | false | Date | (empty) | 40 | false | ||
Running process command | running_process_command | false | String | (empty) | 65,000 | false | ||
Monitor | monitor | false | True/False | (empty) | 40 | false | false | |
Pfile | pfile | false | String | (empty) | 8,000 | false | ||
Recovery Time Objective (RTO) | u_recovery_time_objective_rto | false | String | (empty) | 40 | false | ||
sys_class_path | sys_class_path | false | System Class path | (empty) | 255 | javascript:GlideDBObjectManager.get().ge... | false | |
Technology Fit Score | u_technology_fit_score | false | Choice | (empty) | 40 | false | ||
Correlation ID | correlation_id | false | String | (empty) | 512 | false | ||
Version | version | false | String | (empty) | 255 | false |
...