Skip to Content
0
Jan 12, 2018 at 11:59 AM

Replication User Privilege Error while Verification of Rep Agent

105 Views

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