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.
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.
|Domain||The domain where the Host resides.|
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.|
The most recent time a successful connection was made to the instance. Look at this value in conjunction with Status.
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.
|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.|
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 connect to the cluster, even if one or more instances do not have a status of OK.|
|Cancel||Do not connect to the cluster.|