Verify that the Replication Agent instance has been successfully installed.
isql –Usa –Psa_pass –Smyra
test_connection RS go
Type Connection ---- ---------- RS succeeded (1 row affected)
See the Replication Agent Administration Guide.
test_connection PDS go
Type Connection ---- ---------- PDS succeeded (1 row affected)
Check the tnsnames.ora file and tnsnames configuration values, and manually log in to the primary Oracle database as the configured user to find which property is incorrectly defined.
See "Testing network connectivity" in the Replication Agent Administration Guide.