Replication SQL Server Error 21684 Raised for Oracle Publication

If you already installed Oracle Client software and have an Oracle Login ready to be used as a Replication user. Below is the solution



Go to your SQL installation folder

C":\Program Files\Microsoft SQL Server\MSSQL11.xxxx\MSSQL\Install"

Open "OracleAdmin.sql"

Login Oracle by "SQLPLUS"

Replace "ReplLogin"/"ReplPassword"  as Oracle user/password

Grant these privileges to the user

GRANT CREATE PUBLIC SYNONYM TO &&ReplLogin;
GRANT DROP PUBLIC SYNONYM TO &&ReplLogin;
GRANT CREATE SEQUENCE TO &&ReplLogin;
GRANT CREATE PROCEDURE TO &&ReplLogin;
GRANT CREATE SESSION TO &&ReplLogin;
GRANT CREATE TABLE TO &&ReplLogin;
GRANT CREATE VIEW TO &&ReplLogin;
GRANT CREATE ANY TRIGGER TO &&ReplLogin;

How to check your privileges?

Login Oracle by "SQLPLUS", then type the command

select * from session_privs;

 
 =======================

• Troubleshooting Oracle Publishers

• Configure an Oracle Publisher