Osama ACE director – Technology Geek

ORA-12638: Credential retrieval failed

Posted on June 8, 2015December 23, 2018 by Osama Mustafa in Database

I found following line in sqlnet.ora file

SQLNET.AUTHENTICATION_SERVICES= (NTS)

Then i modified the above line as below and it started working

SQLNET.AUTHENTICATION_SERVICES= (NONE)

Seems that The Oracle server is not configured to support Windows authentication

Cheers
Osama

ORA-39181: Only partial table data may be exported due to fine grain access control

Posted on June 2, 2015December 23, 2018 by Osama Mustafa in Database

The below error appeared when trying to export the Schema using System User :-

ORA-39181: Only partial table data may be exported due to fine grain access control on “SOAPRD_MDS”.”MDS_DEPL_LINEAGES”
. . exported “SOAPRD_MDS”.”MDS_DEPL_LINEAGES” 5.164 KB 1 rows
ORA-39181: Only partial table data may be exported due to fine grain access control on “SOAPRD_MDS”.”MDS_LABELS”

the weird thing that VPD is not enabled to show this error but once i grant the system the required privileges the error stop appearing in the logs.

grant EXEMPT ACCESS POLICY to System;

Thanks
Osama