OraNA :: Oracle News Aggregator

How to bypass the login banners?
There is actually more than one banner to bypass. One of the them is the message of the day banner, commonly located in /etc/motd. Typically friendly, example in AIX
****************************************************…

During a recent Exadata install for an e-dba customer, I had the chance to examine closely the Griddisk creation process. I must say it did throw up one surprise that you’ll see later.
Installing an Exadata
Once a new Exadata has been racked by Oracl…

  APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM Error: ===== APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not…

Today is the first day of the rest of our lives. Make it a good day … Just logged on to the new My Oracle Support at https://supporthtml.oracle.com using Firefox 9.0.1 and Chrome 16. … So far so interesting. As compared to my response to the Fl…

I’ve been asked and agreed to contribute to “AllThingsOracle.com”, a service set up by RedGate software for Oracle users.I’ll publish there complete articles not found on my blog and also sometimes just links to my blog. Furthermore I also plan to cont…

You might think from the title that this little note is going to be about the index hash join – you would be half right, it’s also about how the optimizer seems to make a complete hash of dealing with index hash joins.
Let’s set up a simple data …

to post something on the internet about the US of A – don't. And if you do, be sure to use plain English, or slang, that is understood by Homeland Security.Read what could happen to you!

Lately I’ve been reading a lot more than writing as is evident by my low-frequency blogging. Here is some of the material I’ve been going through:

White Paper: Deploying Oracle Database Applications on EMC VNX Unified Storage
Maximum Performance a…

I just started using the New My Oracle Support User Interface
It is a zero-flash interface with more capabilities than the “html” interface we used the previous years. It still provides about the same browser experience as the flash one.
Have a …

One of the tasks I am performing quite regularly is to deploy Oracle software in form of an RPM. In a previous post I described how this proces could work, based on a post by Frits Hoogland.
Employing the same method, I ran into problems with Oracle 11…

Hi everyone,A very quick update about my upcoming webinar on 9th Feb 2012 titled 'Upgrading to 11gR2 – a case study' where I will be sharing all my experience, tips and techniques of a successful 11gR2 upgrade project. The upgrade project gave …

Create GLOBALS file in GG_HOME:

> cat GLOBALS
— Specifies the name of the schema that contains the database objects that support DDL
— synchronization for Oracle
GGSCHEMA gguser
– Specifies a default checkpoint table
CHECKPOINTTABLE ggs_che…

January 30, 2012 As we have seen in the past, TKPROF output sometimes lies, and in a recent OTN thread I was reminded of another case or two where TKPROF output may be misleading.  In the OTN thread, the original poster (OP) started the thread by ask…

A customer of mine who deploys Oracle Forms 10g  on the wild wild internet, ran into a little problem.

They don’t have control over the java plugin being installed on the client machine and with the latest java 1.7 update

they encountered the f…

Whenever we do an Incomplete Recovery (recovery until CANCEL or until a specific SCN/CHANGE#, SEQUENCE# or TIME), we have to OPEN the database with a RESETLOGS.RESETLOGS_TIME has to be indicated by Oracle if we were to query the database later. This i…

I always found Oracle Enterprise Manager (EM) to be an interesting tool for different reasons. The only thing I missed was an easy way to create my own alerts.
It is very simple to create a KSH, Perl, etc script to do some customised monitoring and not…

9 Şubat ‘da TROUG ve Oracle Türkiye ‘nin desteği ile Tom Kye ile birlikte iki önemli performans iyileştirme uzmanı İstanbul ‘da olacak, katılım TROUG üyelerine ücretsiz, detay bilgilere http://www.troug.org ‘dan ulaşabilirsiniz. Fer…

Rename SQL Tuning Set‎( STS )We can use SQL Performance Analyzer (SPA) to evaluate impact on SQLs of 11g R2 database upgrade from 10.2 .So created some demo , example ( with full code ). EM was very good option , but still preferred sql,pl-sql, comm…

While I was performing a three day seminar recently in Switzerland I came across this new option in cluvfy.
Normally you’d run cluvfy in preparation of the installation of Grid Infrastructure or a set of RAC binaries to ensure everything is ready for…

My last blog was comparison of DataGuard, GoldenGate, Streams and RAC.  While writing my previous blog , the idea of comparing Hints , Outlines, SQL Profiles &  SQL Plan Management stuck me.  I am kind of in a compare-maniac mode and here   go…