Hello ,
Set up - Source Oracle 11g
Destination Sybase IQ
Using Replication Server to replicate between oracle systems to Sybase IQ .
Before building the Rep Agent while verification I'm getting,
INFORMATION: Completed first pass of verification for resource file <iosRA.rs>. Jan 12, 2018 3:38:57 PM com.sybase.ra.admin.RsRssdVerification verifyRS TRACE: Testing connection to RepServer... Jan 12, 2018 3:38:58 PM com.sybase.ra.admin.RsRssdVerification verifyRSSD TRACE: Testing connection to RSSD... Jan 12, 2018 3:38:58 PM com.sybase.ra.admin.oracle.RAOAdmin verifyPDSConnections TRACE: Testing connection to primary database as SYSDBA user... Jan 12, 2018 3:38:59 PM com.sybase.ra.admin.oracle.OracleAdmin pdsUserExists TRACE: Testing connection to primary database as PDS user... Jan 12, 2018 3:38:59 PM com.sybase.ra.admin.oracle.OracleAdmin hasSufficientPrivileges ERROR: Unable to check privileges for user <RA_USER> because: Exception occurred attempting to verify if user has sufficient privileges to support replication. Exception Message: ORA-00942: table or view does not exist Jan 12, 2018 3:38:59 PM com.sybase.ra.admin.oracle.RAOAdmin verifyPDSConnections ERROR: User ID <RA_USER> for primary database does not have sufficient privileges -- invalid option: initialize_instance=yes
Getting this insufficient privilege error though required permisssions has been provided in Oracle Primary