Create a Replication Server connection to the replicate data server.
create connection to OracleSID_name.OracleSID_name using profile rs_oracle_to_oracle;eco set username maintuser set password "password" go
create connection to OracleSID_name.OracleSID_name set error class <error_class> set function string class <function_class> set username <userid> set password <password> set dsi_dataserver_make to 'ora' set dsi_dataserver_type to 'oci' set batch to 'off' set dsi_proc_as_rpc to 'on'
isql –Usa -Psa_pass –SSAMPLE_RS -i my_oracle_create_rs_standby_connection.sql
isql –Usa –Psa-pass –SSAMPLE_RS admin who go
You should see a message returned for the DSI connection {rds}.{rdb}. Verify that the status is “Awaiting Message” or “Awaiting Command.”