Posts

Showing posts from 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

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 prov…

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

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.

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

Oracle Open World 2015 review

Image
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 …

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 En…

Error : Cannot export Display Linux

Image
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 > X11Check X11 forwarding: [x] Enable X11 forwardingAdd to the “X display location” field: localhost:0.0


Cheers Osama

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

Image
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

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

System is in manitance mode. Please try again later OBIEE

Image
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

Me, Security & Oracle

Image
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 hacke…

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, USAUKOUG 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

sorting algorithm

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



Cheers
Osama

create IPS repository in Solaris 11.2

Image
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     …

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 rebootsudo shutdown -r nowsudo 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/shutdownUsing /etc/sudoers.d instead of modifying /etc/sudoers, you could add the two lines to a new file in…

/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

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

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 w…

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

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

OTN MENA TOUR

Image
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 EditionOracle JDeveloper and Application Development Framework (ADF)Oracle Business Process ManagementOracle SOA SuiteOracle Data IntegratorOracle User Messaging ServiceOracle Enterprise SchedulerOracle Event ProcessingOracle WebCenter SuiteOracle Identity ManagementOracle Forms and ReportsOracle WebTierOracle Application Architecture Foundation Pack…

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

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

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

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

Configure RMAN Backup On Windows

Image
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 :-backupArchivelogControlfileCreate 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…

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

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

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_configsearch for line as follow :-PermitRootLogin yes and change it to -->  PermitRootLogin noSearch for the following lines as well :-DenyUsers root user2 user3Remove the root from Deny UserDenyUsers 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

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

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

[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 --> OracleRemExecRemove the OracleRemExecServicethen try to install Oracle client again
Thank you  Osama Mustafa

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.repoEdit 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

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

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.comUnzip the Patch Folder.Set/export ORACLE_HOME to Jdeveloper hope depend on Operating systemFinally 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

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_…

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 Storageinventory 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 …

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 :…

Oracle Database Patches Information

A number of questions has been asked here and in Oracle Community Forum When/What/Date for Next Database patches ?

in the all way you should have valid account for http://support.oracle.com.

I see it's worth it to post and share the information how to find the desire patch number and how to know next patch release, i will only share MOS document number that will help you understand what i mean.

How to Find Patch ? 



Oracle Recommended Patches -- Oracle Database (Doc ID 756671.1)Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets [1454618.1]Release Schedule of Current Database Releases [742060.1]Introduction to Oracle Recommended Patches [756388.1]Oracle Database Patchset Information, Versions 10.2.0 to 12.1.0 (Doc ID 268895.1)ALERT: Oracle 11g Release 1 (11.1) Support Status and Alerts (Doc ID 454507.1)
The above MOS document will guide you and help you to know the next release of database patch, also as you see i included some document that hel…