Spotlight on Oracle 11.0 - Getting Started Guide

Create / Modify / Delete connections to Spotlight on Oracle RAC.

Setup Spotlight Users and complete the Oracle User Wizard.

Spotlight alerts you to problems with your system by issuing an alarm. You can configure Spotlight in the level of severity that constitutes an alarm, to disable an alarm, and the actions Spotlight takes on raising the alarm.

Select the name (the SQL*Net alias) of the Oracle RAC instance that you wish to connect to.

Notes:

• The database name is defined within SQL*Net configuration utilities.
• While this can be the name of any instance in the Oracle RAC cluster, we recommend using the name of the load-balanced instance – the instance whose TNSNAMES entry includes the option (LOAD_BALANCE = yes)
• When selected, the Connection name field resets to this value. You can then edit the Connection name field if required.

Enter the Spotlight user name.

Note: (Oracle 12c) As per Oracle guidelines, the Spotlight Oracle user needs to be of the form “c##<username>” when connecting to an Oracle 12c Container database.

Enter the connection string required to link to the ASM database instance that is used for storage management by this Oracle database.

Note: The TNSNAMES entry for the ASM instance must include the option (UR = A) for the Spotlight connection to work properly.

Select to monitor the operating system on the database server.

Note: Clear this option if the database is running on an operating system NOT supported by Spotlight on Oracle RAC. If you leave this option selected and Spotlight is unable to collect statistics from the server operating system, you may experience errors.

Enter the name of the server.

Tip: Use a period “.” to monitor the local database.

Select the type of operating system.

• Windows
• Unix(REXEC)
• Unix(SSH)
• Unix(SSH using Public/Private Keys)

If you select one of the Unix systems, make sure the SSH or REXEC daemon is running on the database server and is configured to receive remote connections.

Note: Spotlight supports both SSH1 and SSH2 protocols; public-key encryption is supported under SSH2 only.

Enter the port number for SSH (secure shell) connection to the database servercluster. The default value is 22.

Note: Applicable when OS Type is Unix (SSH) or Unix (SSH using Public/Private Keys).

Type the user name to login to the database servercluster.

Notes:

• Spotlight will connect successfully to all nodes in the cluster only if every node employs the SAME username and password.
• If the username — and password if required — are not completed, you will not be able to view the operating system performance statistics for the database servercluster.
• When OS Type is Windows:
  • Not required if your login details have been assigned remote access to the registry of the nodes in the database servercluster.
  • If your login details have NOT been set up on the database .servercluster, you must enter a username and password that has access to the registry of each node.

Choose the type of key to use when making the Spotlight connection: RSA or DSA.

Note: Applicable when OS Type is Unix (SSH using Public/Private Keys).

Locate the filename that contains the private key for the Spotlight connection.

Hint: Use the "..." button.

Note: Applicable when OS Type is Unix (SSH using Public/Private Keys).

Type the passphrase used to decrypt the private key.

Note: Applicable when OS Type is Unix (SSH using Public/Private Keys).

The current status of the instance.

The name of the instance.

If a separate TNS entry exists for an instance within the relevant TNSNAMES.ORA file, you can choose to use that entry.

Click the TNS Entry field. Select the desired value from the list. (Alternatively, type the connection name.)

If a TNS Entry is NOT identified, then a connection string is constructed dynamically from the Host, Domain and Port values.

If a TNS Entry is identified, these columns will be populated from the TNS Entry when you test the connection.

The name of the host machine (node) for the instance.

Note: If you have selected a TNS Entry this may contain an IP address instead.

The logical port that is used to access each instance in the cluster.

Note: If Spotlight cannot obtain this information from TNSNAMES.ORA it will use the default port 1521.

Select to open this dialog every time you open the Oracle RAC cluster.

When not selected, this dialog opens when Spotlight encounters a problem opening the Oracle RAC cluster.

Use if an instance is no longer part of this Oracle RAC cluster.

Select the instance and click Remove.

Removing the instance stops Spotlight raising an alarm when it attempts unsuccessfully to connect to the instance.

Click to

• Delete the history of recent connections and connection tests
• Revert to the original connection settings