Tuesday, July 7, 2015

/usr/ccs/bin/as: not found/No such file or directory on Solaris 11.2

While trying to install Oracle Database 12c on Solaris 11.2 the i faced the following the errors in the logs and dbca was unable to start :-


INFO: sh[2]: /usr/ccs/bin/as: not found [No such file or directory]
INFO: make: Fatal error:
INFO: *** Error code 127


The package developer/assembler comes with default installation, But  Solaris 11 package developer/assembler is not installed.

To install it: -

pkg install developer/assembler


and try again.

Cheers
Osama 

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

Wednesday, May 27, 2015

OID is Down For Ambiguous Reasons

Today one of the customer called complaining about accessing to the system and how its not working ? Since everything is configured as single sign on (SSO) first thing to check was OID or oracle internet Directory.

The logs indicate to the below error :-

[2015-05-01T07:00:18+03:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: MOAPRDOID1] [pid: 5244] [tid: 0] Guardian: [oidmon]: Unable to connect to database,
will retry again after 10 sec

[2015-05-01T07:00:28+03:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: MOAPRDOID1] [pid: 5244] [tid: 0] Guardian: Connecting to database, connect string is oiddb

[2015-05-01T07:00:28+03:00] [OID] [NOTIFICATION:16] [] [OIDMON] [host: MOAPRDOID1] [pid: 5244] [tid: 0] Guardian: [gsdsiConnect] ORA-12514, ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

from the above error the OID is unable to connect to database server i checked database and listener everything is up without any issue and all the other application working without any issues.

after investigation I checked the sqlnet.ora and add the following :-


SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES)

Restart the services and everything is working.

maybe this solution will not lead or help in so many cases i am working to know why this will effect on OID since it's was working without any issues for 1 year

Thanks
Osama 

Monday, May 18, 2015

Enable Database Vault Using chopt Command

I post before how to enable oracle database vault using make command, in this post i will talk about how to enable database vault but using chopt command which easier and faster.


Common Syntax :-
chopt [enable | disable] db_option

Value
Description
dm
Oracle Data Mining Database Files
dv
Oracle Database Vault
lbac
Oracle Label Security
olap
Oracle OLAP
partitioning
Oracle Partitioning
rat
Oracle Real Application Testing
ode_net
Oracle Database Extensions for .NET 1.x
ode_net_2
Oracle Database Extensions for .NET 2.0


Like the other way you need to shutdown database, listener and dbconsole

cd $ORACLE_HOME/bin
chopt enable lbac


and Start database, listener, and dbconsole , Enterprise should be configured to access database vault.


Cheers
osama