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!

Didier Durand · 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

rePost-User-1211029 · Answer

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

This is required for pluggable databases.

gokul_guna · 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

Add your answer

Relevant content