Posts

Showing posts from April, 2015

ORA-47401: Realm violation for CREATE TABLE on SYSTEM.SYS_EXPORT_SCHEMA_07

When trying to export any user using system the below error appeared

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing optio
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYSTEM.SYS_EXPORT_SCHEMA_07"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1020
ORA-47401: Realm violation for CREATE TABLE on SYSTEM.SYS_EXPORT_SCHEMA_07


The above error related because the system user is not allow to access data Dictionary files.

Run the below command
SQL>
BEGIN
DVSYS.DBMS_MACADM.ADD_AUTH_TO_REALM(
realm_name => 'Oracle Data Dictionary',
grantee => 'SYSTEM');
END;
/
PL/SQL procedure successfully completed.

Or you can use the GUI in Database vault and under Data Dictionray real…

connection to database cannot be established - DBCA

Environment :-

Oracle Grid Infrastructure 11.2.0.4
Nodes # : 4
Operating system : Redhat 6.6

When trying to configure enterprise manager the following error appeared :-

Connection to the database cannot be established because the listener could be down. Please make sure that the service is registered with a listener and the listener is up.

The listener is up, VIP is working on all nodes without any issue when check dbca logs looking for more details i found this error :-

dbca trace in $ORACLE_BASE/cfgtoollogs/dbca.

ORA-1017: invalid username/password

Both was correct, because of this i recreate password file on all nodes and restart my operation it's working without any issue this time.

Thanks
Osama Mustafa

OTN EMEA Tour 2015

Image
For second time i will be glad to Join OTN EMEA Tour 2015 with others oracle experts who consume much time in the Oracle Community.


We will cover the following country :-

Portugal.Jordan - AmmanJohannesburg
date                        location May 21st 2015Lisbon, Portugal May 23rd 2015Amman, Jordan May 26th 2015Johannesburg, South Africa
All the information you can find it here.
Please if you will join us in any country sign up.
Thanks Osama Mustafa

Oracle AutoVue Installation and SSO

This document will show steps how to install oracle Autovue and configure SSO for Oracle AutoVue.

For about Oracle Autovue from here.


The Document from here.


Thank you
Osama Mustafa

mkdir No such file or directory Solaris 11.2

Image
root@TT:/#mkdir –/u01/app/oracle/product/TimesTen/
mkdir: Failed to make directory "/u01/app/oracle/product/TimesTen/"; No such file or directory


simply this error related to auto_master all you have to do is to remove the entry /home from the auto_master
vi /etc/auto_master


and remove the entry  Try again.
Thank You  Osama Mustafa

Install Oracle Solaris 11.2 Using GUI

This Document describe how to install oracle Solaris 11.2 step by step.

View the document here.


Thank you
Osama Mustafa

Jordan Amman Oracle User Group

Image
It's almost here, 09/04/2015 I published before about first event for JAOUG, I am so excited, organizing the event not easy needs a lot of work , commitment and dedication. finally we are here.

Since this is the first event before the biggest one, it's only introduction for the group and to introduce the local people and let them know about the group.

We prepare the poster today and seems perfect.



Thanks for the amazing Volunteer and PSUT to make this dream come true.
Osama Mustafa

Jordan Amman Oracle User Group First Event

Image
as most of you know that i created new oracle group in Jordan to allow people involve in oracle community and teach them more about oracle, this step was huge for me and the group established in 2014

Now it's Officially, the first event will be organized 09/April/2015 as introduction to this group, the volunteers working so hard, the second event will be surprise since it will be the biggest one in Jordan i will be announce about it soon. we still working on the logo but this is the initial one.


Thank you  Osama Mustafa