This discussion is archived
1 Reply Latest reply: Jun 28, 2013 8:39 AM by stevencallan RSS

Problem register downstream integrated extract

user228312 Newbie
Currently Being Moderated


I have a 11.2.0.3 source on linux and a 11.2.0.3 downstream database on linux and

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

 

I get the following error trying to register an extract:

GGSCI 4> REGISTER EXTRACT e_his DATABASE

2013-06-25 07:59:28  ERROR   OGG-01755  Cannot register or unregister EXTRACT E_HIS because of the following SQL error: OCI Error 26,665. See Extract user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide.

 

The following privileges have been granted:

grant dba,connect to goldengate identified by password;

GRANT SELECT ON V_$DATABASE TO goldengate;

EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE(grantee => 'GOLDENGATE', privilege_type => 'CAPTURE',  grant_select_privileges=> true, do_grants => TRUE);

 

Some ideas how to solve this?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points