Standby Connections Dialog
Use this dialog to manage monitoring of Oracle Data Guard environments.
- Open the Primary Database as a Live Connection in the Spotlight Browser.
-
Click Data Guard.
-
Fill in the details of Standby connections in the Standby connections dialog.
Note: These fields cannot be edited while the status of the Spotlight connection to the Standby is Connected. To Disconnect a connection, close the Standby connections dialog, right click the Standby database in the Spotlight Browser and select Disconnect.
Field Description Monitor Select to monitor this Primary to Standby Oracle Data Guard connection in Spotlight.
DB Name The name of the Standby database. Display Name The name of the Standby database as it is displayed in the Spotlight Browser. By default this is the DB Name.
Connection String The connection string to the Standby database.
This field can be entered in one of the following ways:
TNSNAMES.ORA entry Spotlight populates the Connection String field with all entries from the TNS Names file, if configured, and you can select a database from this drop-down list.
LDAP server If using Oracle names directory services (LDAP or Oracle OID), then type the name of the database into this field. Direct Connect Enter the connection details of the database in the following format: HOST:PORT/SERVICE_NAME. Oracle Username The Oracle Username to the Standby database.
Tip: On a Logical Standby or Physical Standby with Read Only Access use the Spotlight User account used on the Primary. On a Physical Standby without Read Only Access use a SYSDBA Account.
Oracle Password The password to login with the Oracle Username to the Standby database. Connect As The type of login to the Standby database. For example, NORMAL or SYSDBA. Status Is Spotlight connected to the Standby?
If not connected the Status field will indicate the reason for the error.
If you edit the fields the Status field will indicate Untested. Click Test to test the connection. If successful the Status field will change to OK. Click Connect to connect.
Note: If there is an error and you want to close the dialog without fixing the error, deselect the Monitor field.
-
Further actions on the Standby Connections dialog.
Action Description Save password details (for these connections) Select to save the Oracle password(s) entered into this dialog.
Deselect to enter the Oracle password every time
Test Test all standby connections.
Tip: Use when the Status field indicates an error or untested. Fix the error if applicable. Click Test. If the status field changes to OK then click Connect to connect.
Note: Standby connections that are already connected are not tested.
Connect Connect all connections with the Monitor field selected, save all changes and close the dialog.
Save Save all changes and close the dialog.
Tips:
- Use when you want to save changes and close the dialog without initiating a connection.
- If there is an error and you want to close the dialog without fixing the error, deselect the Monitor field.
Cancel Cancel all changes and close the dialog. Help Open this help page.
