DMS: Source End point error. No permissions to access sys.obj$ Endpoint

Question

I am trying to create a source EP for a pluggable database, and I get this error when I do a connection test

"Test Endpoint failed: Application-Status: 1020912, Application-Message: No permissions to access sys.obj$ Endpoint initialization failed "

The permission is there
SQL> SELECT * FROM DBA_TAB_PRIVS where grantee = 'DATAMIG' and table_name ='OBJ$';

GRANTEE                   OWNER                TABLE_NAME                     GRANTOR              PRIVILEGE       GRA HIE COM TYPE
------------------------- -------------------- ------------------------------ -------------------- --------------- --- --- --- ------------------------
DATAMIG                   SYS                  OBJ$                           SYS                  SELECT          NO  NO  NO  TABLE

The Endpoint settings also has

"UseBFile": true,
    "UseLogminerReader": false

and still I get the error, please help!

Accepted Answer

Hi,
You may want to follow section of "Resolve native database errors" of https://repost.aws/knowledge-center/dms-endpoint-connectivity-failures to investigate your issue.

Additionally, your select seems to show that your grantee doesn't have full auth on the db schema to be migrated. I would start by allowing the grantee to do any action on (test) database and then tighten the auths to a minimum set by restricting them incrementally to finally reach the minimum set.

And maybe, before doing that, I would follow best practice: check that I have proper end-to-end connectivity (routing, sec groups) between the vpc on which the DMS replication instance and my source database, which seems to be remote in your use case.

Best,

Didier

Answer

Thanks, I realized was missing 
GRANT SELECT ON V_$CONTAINERS TO db_user;

This is required for pluggable databases.

Answer

Hi, Can you provide all the grants as per this [documentation ](https://repost.aws/knowledge-center/dms-permissions-oracle-source)and test the endpoint

DMS: Source End point error. No permissions to access sys.obj$ Endpoint

相关内容