Posts

Showing posts from June, 2015

OTech Magazine – Summer 2015

Image
OTech Magazine - Summer 2015 OTech Magazine issue Summer 2015 is the eighth issue of OTech Magazine – the independent Oracle technology magazine – . Our contributors are the best of the best of the Oracle atmosphere.


Osama Mustafa – Database Link From Oracle to MySQL
Read the full version of magazine here.
Thanks Douwe Pieter  for this amazing efforts.

Cheers Osama Mustafa

My Days As an Oracle ACED : BGOUG

Image
12 - 14 June save the date because it's Bulgarian Oracle User group Events, this is my first time in Bulgaria and my first time as an oracle ACE director in any events :).

My Trip Planned to be from Jordan to Bulgaria - Sofia  and as usual i need to stop in one of world airport to reach my destinations first which i really hate because it's wasting of time and tiring me.
my stop was in Frankfurt airport and to be there i had to spent 5-6 hours in the plane to reach there and then wait another 5 hours in the airport and reach Sofia 3 hours in the plane. but lucky me the plane is delayed in Jordan and i waited for 2 hours only :).
I reach Sofia but i was really exhaust and tired from traveling because my trip started early morning and it's took us 2 hours to reach the hotel from the airport but even with this i have to thanks one of the best organizer i ever seen Milena Gerova She organized everything very well the hotels, the taxi, the appreciation events & sessions.
I…

ORA-12638: Credential retrieval failed

Image
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

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