Chat now with support
Chat with Support

Spotlight on Oracle 10.7 - Release Notes

Verify Cluster Connection Details Dialog

Spotlight opens the Verify Cluster Connection Details dialog automatically when it encounters an error connecting to an Oracle RAC cluster. Use the dialog to test and modify connection settings to instances in the Oracle RAC cluster.

Connection Details for Instances in the Cluster

Each row in the grid represents an identified instance in the cluster, even if that instance is no longer part of the cluster.

Column Description
Status

The current status of the instance.

Value Description
Untested The connection details have been neither tested nor used successfully since they were last modified or created. Click Test to investigate.
OK The connection details have been tested successfully.
Failed

The connection details are missing or faulty.

  • Refer to Test Results for the related error message.
  • If Last Successful shows the most recent date that Spotlight successfully connected to the instance then there may be a problem with the cluster.
  • If Last Successful is empty then the connection details may be invalid.
No status The connection has not been tested or you have reset the connection details. Click Test to investigate.
Instance Name

The name of the instance.

TNS Entry

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.

Host

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.

Domain The domain where the Host resides.
Port

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.

OS User The name used to log on to the host.
OS Password The password used to log on to the host.
Test results The error message returned when you click Test and the test fails.
Last successful

The most recent time a successful connection was made to the instance. Look at this value in conjunction with Status.

Service Name

This is the SERVICE_NAME of the cluster. Connections to instances that do not have a specified TNS Entry will use this as their SERVICE_NAME when constructing a dynamic connection string.

Dialog Actions

Action Description
Display this dialog for the current connection

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.

Test Click to test all the connection details. Use to ensure connections to the cluster instances will succeed, and that you have not entered duplicated (but otherwise correct) information.
Remove

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.

Reset

Click to

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

OK

 Click to connect to the cluster, even if one or more instances do not have a status of OK.
Cancel Do not connect to the cluster.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating