Decrypt Oracle and database link passwords

At Derbycon 3.0, László Tóth and Ferenc Spala  gave a a new presentation “What’s common in Oracle and Samsung? They tried to think differently… ” (Video). The main focus of the presentation was the Samsung encryption and a new framework called sandy but there was also a small (more...)

BI Mobile HD App

Finally got around to writing my long overdue post on the new BI Mobile HD app. To get on with it, without much ado, not to loiter, and all that... here goes.

The new BI Mobile HD app, version, can be downloaded from (more...)

Creating your first app with the BI Mobile App Designer

While creating sophisticated mobile apps that provide a rich feature set takes time, expectedly, what is wonderful about the recently launched Oracle Business Intelligence Mobile App Designer is the fact that you can be up and running without requiring a week-long training and a Master's degree in Computer Engineering.

Here's (more...)

Introduction to the BI Mobile App Designer

Oracle launched a brand new addition to its Business Intelligence Mobile solution - BI Mobile App Designer, which lets you create stunning, interactive mobile apps, literally within minutes. Apps created run on mobile devices running a reasonably modern mobile browser - that can handle HTML5 and jQuery - and are (more...)

White spaces and Map Views

When working with Map Views, you can choose to collapse the map formats panel on the left.

When you do that, the panel is hidden, but white space is displayed on either side of the map view, where the panel used to be.

Currently there is no option to remove (more...)

Fix for oradebug disable auditing available (

2 days ago I gave a presentation “Oracle 12c from the attackers perspective” at the DOAG SIG Security. I learned some interesting things, especially that a fix for the Oracle oradebug “disable auditing” problem is available since 9 months.

Oradebug allows to run OS commands and to enable/disable Oracle SYSDBA (more...)

portmap: unrecognized service on RHEL6

Original Post can be viewed at portmap: unrecognized service on RHEL6

Quick note for people using NFS for shared storage on RAC database. Till RHEL5 we had to ensure nfs,nfslock and portmap service has to be running. These services are required otherwise you will get following errors while mounting database


cursor: pin S wait on X

Original Post can be viewed at cursor: pin S wait on X

Few weeks back thread came up on oracle-l freelist regarding ”cursor: pin S wait on X” event . Tanel Poder replied to this thread with excellent explanation. You can read full thread here


This wait happens when your (more...)

Oracle Database Gateways 11g R2 (11.2) Installation and Configuration for heterogeneous connection from Oracle to Microsoft SQL database


Install the Oracle Database Gateways 11g R2 (11.2). See the screen snapshots of the installation here.


  • During the installation, the following+ default initialization parameter file is created:
dg4msql = Database gateway for Microsoft SQL Server. 
If you choose a different database option, use the appropriate path name.
  • Copy initdg4msql.ora to a new file init[MSSQL].ora.
[MSSQL] can be any meaningful name easier to refer to,  (more...)

Oracle SQL Developer Data Modeler 3.3 now available

Attention all data modellers - we are pleased to announce the release of SQL Developer Data Modeler 3.3. This release includes a new search, reports can be generated from search results, extended Excel import and export capabilities and more control and flexibility in generating your (more...)

Finally here: Oracle Instant Client 11gR2 for OS X

See the blog post over at Oracle for details, and be sure to send Christopher Jones an email (via the address in his post) stating you're an active user of the client. As Christopher mentions in his post,

You can really help us justify resources for the OS X bundle if you email me letting me know you are a fan. Since Instant Client is a free download, it is tricky for us to know how widely it gets used.

Jump to OTN to download, but please remember to email Christopher as well, if you're interested in seeing the client (more...)

11.2 AQ – Messages stuck in PROCESESED,WAIT State

Original Post can be viewed at 11.2 AQ – Messages stuck in PROCESESED,WAIT State

I had been working today on AQ issue where messages were not moving from WAIT to READY State.This was on database running on RHEL5u6(64 bit). I thought of quickly documenting it for easy reference When you enqueue record, you can specify delay after which record should be ready for dequeue. During this time, MSG_STATE [...] Weblog

Build an 11gR2 RAC cluster in VirtualBox in 1 Hour using OVM templates

[I originally posted this over at the Pythian blog. If you're not following it, you should! Way more content, by far smarter people than lil ol' me.]

After reviewing my blog post about running EBS OVM templates in VirtualBox, two of my teammates suggested that I work on something with potentially broader appeal. Their basic message was, "This is really cool for us EBS nerds, but what about the Core DBAs?"

So how does "11gR2 RAC in an hour" sound? :-) In this post, I'll demonstrate how to deploy the pre-built Oracle VM templates to create a two-node (more...)

Customize/Personalize Oracle APEX Workspace Environment

When you have multiple Oracle APEX environments, e.g., development, test, UAT and production, and for multiple groups, one of the confusing things is that sometimes developers are lost on which environment they’re working on. Most of technically proficient developers can make a distinction easily from the URLs they’re currently using. However, most of less technically proficient (e.g., business users) sometimes cannot.

A quick and simple solution here is to make a (more...)

Tailoring Fusion CRM

The journey for the Fusion CRM development team has been a long one. What a great feeling for all of us when Fusion Applications was officially released this year as Generally Available. During his keynote speech at this year's Oracle OpenWorld Steve Miranda reiterates that statement. Also during his session (more...)

11g Gotcha

Something I discovered recently is that the DEFAULT profile for Oracle 11g sets the PASSWORD_LIFE_TIME to 180 instead of UNLIMTED by default.  Applications will encounter an "ORA-28002: the password will expire within X days" error message if you keep the default value. To change the PASSWORD_LIFE_TIME, you: ALTER PROFILE default LIMIT password_life_time UNLIMITED; One thing to keep in mind is

What’s old is new again

We had a fair number of problems related to bind variable peeking in our and dbs.  In fact, the plans became so erratic that we decided to just turn bind variable peeking off by setting _optim_peek_user_binds=false in all the init.ora files. Flash forward to Oracle 11g ( and the optimizer has been enhanced to use bind variable peeking much better.  After converting to

My first 11g show stopper: Purging the Recyclebin

I've run into my first issue with  After one of my dbs was upgraded, every time I try to purge the recyclebin, I get an ORA-00600 error: SQL> purge dba_recyclebin; purge dba_recyclebin * ERROR at line 1: ORA-00600: internal error code, arguments: [ktcdso-1], [], [], [], [], [], [], [], [], [], [], [] It doesn't matter if the recyclebin is on or off. I have done about six upgrades and

Listener Logging in 11g

By default, the listener logging is not turned on in 11r2.  You have to turn it on by specifying: LOGGING_listener_name=ON in your listener.ora file.

Something Interesting about the 11g Client

If you're just beginning to implement Oracle 11g, you need to be aware of the Automatic Diagnostic Repository (ADR).  It has nothing to do with AWR, ADDM, ASM, ASSM, or any of the other acronyms Oracle has come up with over the last two releases. In terms of the database, ADR could be a great thing.  It's integration with Enterprise Manager is probably one of the best parts about the feature.