Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 8
Next »
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
- Changed glide.required.attribute.enabled to false to ignore the mandatory fields
- Restart Mid-Sever
|
|
|
2 |
|
|
|
|
|
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)*
|
SSHCommand-Oracle - Listener Details
|
|
Patterns
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 |
cmdb_ci_db_ora_instance Data attributes
u_ = added fields
|
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 |
User Interface
Relationships
Validation Steps
Open Questions
Question | Answer | Date Answered |
---|
| |
|
Out of Scope