Friday, June 26, 2015

OTech Magazine – Summer 2015


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

Sunday, June 14, 2015

My Days As an Oracle ACED : BGOUG

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 had 2 presentation there about Fusion middleware and like usual i organized RAC ATTACK On Saturday, The audience was really amazing and asking very good questions. 

I had so much fun in Bulgaria and one of the best events i attended, simply it's really Green every where you look it's green, and I learned some Bulgarian dance  because i knew everyone in Bulgaria should dance :) Even Tom Kyte was dancing,Svetoslav and Heli as well so why not ? 

It's really nice to meet old friends and meeting new one  :) 








Cheers
Osama Mustafa 


Monday, June 8, 2015

ORA-12638: Credential retrieval failed



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

Tuesday, June 2, 2015

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