| Page Properties | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
| # | Requirement | User Story | Importance | Challenge | Notes |
|---|---|---|---|---|---|
| 1 | Mid Server | Update Mid-Server Parameters |
| ||
| 2 |
Probes
| Oracle Probes |
|---|
Oracle Instance
SSHCommand-Oracle - Listener Details
|
| Oracle - Instance Details . | SSHCommand | sh ${file:oracle_instance.sh} ${sid} | Get the details of a specific Oracle ins... | |||
| Oracle - Instance PFile | Powershell | Windows - Oracle PFile | Obtain the PFile for Oracle instance | |||
| Oracle - Instance Version | Powershell | Windows - Oracle Version | Gather Oracle instance version information | |||
| Oracle - Listener Details | SSHCommand | sh ${file:oracle_listener.sh} ${oracle_h... | Get the details of a specific Oracle lis... |
Patterns
| Oracle Patterns |
|---|
Application patterns:
This shared library pattern used by the Linux Server pattern:
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:
|
| 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 | 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 | oracle_home | Parsed from the path of oracle.exe |
| Edition | edition |
cmdb_ci_db_ora_instance Data attributes
...
| License Type | u_license_type | false | String | (empty) | 40 | false | ||
| SDR # | u_last_sdr_number | false | Integer | (empty) | 40 | false | ||
| Justification | justification | false | String | (empty) | 80 | false | ||
| Oracle Home | oracle_home | false | String | (empty) | 255 | false | ||
| Functional Owning Organization | u_functional_owning_org | false | String | (empty) | 40 | false | ||
| Edition | edition | false | String | (empty) | 100 | false | ||
| Hosting | u_hosting | false | String | (empty) | 40 | false | ||
| Assigned to | assigned_to | false | Reference | User | 32 | false | ||
| Target Cloud Deployment | u_target_cloud_deployment | false | String | (empty) | 40 | false | ||
| DR Plan Next Testing Date | u_dr_plan_next_test | false | Date | (empty) | 40 | false | ||
| DR Plan Next Approval Date | u_dr_plan_next_approval | false | Date | (empty) | 40 | false | ||
| Subcategory | subcategory | false | String | (empty) | 40 | false | ||
| Assigned | assigned | false | Date/Time | (empty) | 40 | false | ||
| Invoice number | invoice_number | false | String | (empty) | 40 | false | ||
| Data Types | u_data_security_classification | false | List | Data Security Classification Type | 1,024 | false | ||
| SID | sid | false | String | (empty) | 40 | false | ||
| Created | sys_created_on | false | Date/Time | (empty) | 40 | false | ||
| Project Number and Name | u_project_number_and_name | false | String | (empty) | 40 | false | ||
| Checked out | checked_out | false | Date/Time | (empty) | 40 | false | ||
| Running process | running_process | false | Reference | Running Process | 32 | false | ||
| Attributes | attributes | false | String | (empty) | 65,000 | false | ||
| Domain Path | sys_domain_path | false | (empty) | (empty) | 255 | false | ||
| Updated | sys_updated_on | false | Date/Time | (empty) | 40 | false | ||
| Business Criticality | u_business_criticality | false | String | (empty) | 40 | false | ||
| Model ID | model_id | false | Reference | Product Model | 32 | false | ||
| Other Moderate Risk | u_other_moderate_risk | false | String | (empty) | 200 | false | ||
| Instance | instance | false | String | (empty) | 40 | false | ||
| SDR Information | u_sdr_information | false | String | (empty) | 40 | false | ||
| Recovery Point Objective (RPO) | u_recovery_point_objective_rpo | false | String | (empty) | 40 | false | ||
| Approval group | change_control | false | Reference | Group | 32 | false | ||
| Installation directory | install_directory | false | String | (empty) | 255 | false | ||
| Fully qualified domain name | fqdn | false | String | (empty) | 255 | false | ||
| Risk Classification | u_risk_level | false | String | (empty) | 40 | false | ||
| Future Host Environment | u_future_host_environment | false | String | (empty) | 40 | false | ||
| Monitoring | u_monitoring | false | True/False | (empty) | 40 | false | ||
| Is clustered | is_clustered | false | True/False | (empty) | 40 | false | ||
| Running process command hash | rp_command_hash | false | String | (empty) | 255 | false | ||
| Management IP Address | ip_address | false | String | (empty) | 255 | false | ||
| 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
Relationships
Tracked Configuration Files
Dependency View
Relationships
Validation Steps
| Step | Description | Verdict |
|---|---|---|
...