Skip to main content

Oracle_InstanceNameIssues Job

The Oracle_InstanceNameIssues Job discovers if names used for Oracle database instances conform to Oracle recommended best practices. The job also checks to see if Oracle SIDs conform to DISA STIG V-61413 – Oracle instance name or SID should not contain Oracle version numbers.

Analysis Tasks for the Oracle_InstanceNameIssues Job​

Navigate to the Jobs > Databases > Oracle > 4.Configuration > Oracle_InstanceNameIssues > Configure node and select Analysis to view the analysis tasks.

CAUTION: Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Selection

The default analysis tasks are:

  • Find Weak Instance Names – Checks SID names for default names and version numbers. Creates the SA_Oracle_WeakInstanceNames_Details table accessible under the job’s Results node.
  • Summarize Number of Weak Instance Names – Counts the number of weak instance names in all instances. Creates the SA_Oracle_WeakInstanceNames_Summary table accessible under the job’s Results node.

In addition to the tables and views created by the analysis task, the Oracle_InstanceNameIssues Job produces the following pre-configured report.

ReportDescriptionDefault TagsReport Elements
Instance Name IssuesThis report highlights default instance names or those containing version numbers.NoneThis report is comprised of two elements: - Pie Chart – Displays percentage of instance names with issues - Table – Provides details of instance issues