Step 3. Verify the MRO instance installation

This section describes the required steps to verify an MRO instance:

Update the Rep Server interfaces file with the MRO location
Verify the connection to MRO
Verify the MRO connection to Oracle

To verify the MRO installation

Using dsedit, update the MRO interfaces file to include an entry for the MRO location.

You can use any TDS client utility (isql, isqlApp, or SQLAdvantage) that you prefer.
Verify the connection to MRO:
1. Open a command window in the $SYBASE directory of your MRO installation.
2. Set the environment variables by sourcing the SYBASE.csh file.
3. Use isql to log in to MRO:
```
isql –Usa –P –Smy_mro
```
Verify the MRO connection to Rep Server:
1. Enter the following command:
```
test_connection RS
```
```
go
```
2. The following is displayed:
```
 Type Connection ---- ---------- RS   succeeded(1 row affected)
```
3. If the result indicates a failure, either the server is not responding, or the connection properties (host, port, user, or password) are incorrect.Verify the host and port configuration values, and manually log into the Rep Server as the configured user to determine which property is incorrectly defined.
  
  For additional information, refer to the Mirror Replication Agent Administration Guide, Chapter 2, Setup and Configuration, in the section titled, “Testing network connectivity.”
Verify the MRO connection to the primary Oracle database:
1. Enter the following command:
```
test_connection PDSgo
```
  The following message appears:
```
Type Connection ---- ---------- PDS  succeeded(1 row affected)
```
2. If the result indicates a failure:
  - The server is not responding, or
  - The connection properties; host, port, pds_database_name usually oracle_sid, user, or password are incorrect.
  Check the host and port configuration values, and manually log in to the primary Oracle database as the configured user to find which property is incorrectly defined.
  
  For more information about connection failures, see the Replication Agent Administration Guide section titled, “Testing network connectivity.”