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

The Cost of Mediocre

Over the years I've written tons of scripts to monitor all sorts of things on the database.  Some of those scripts turned out to be helpful on an ongoing basis and some ended up dying on the vine when new features of Oracle came out. One of my scripts looks at the top processes in a database from the CPU's perspective.  In other words, how much time did the process use on the CPU over it's

Upgrading to Oracle 11gR2

I am about half way through upgrading all my dbs to Oracle 11gR2 from various versions of 10gR2.  Out of all the upgrades I've performed from 7.0 up to 10gR2, the 10g to 11g upgrade is by far the most hassle free of all. I have abandoned the GUI upgrade tool this time.  The GUI tool is fine, but internal issues prevented me from running the GUI remotely.  This meant that somebody had to be

From Oracle Newbie to Oracle ACE…

When I started this blog over 5 years ago, I never imagined that it would take me on a journey from an Oracle Newbie, to a Director of UKOUG and onto an Oracle ACE (even if I did go via some strange evenings in some strange pubs in Birmingham and (more...)

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.

Removing OLAP from 10g

There is a metalink note that describes how to remove the OLAP option if it was installed in your database incorrectly.  See ML Note 739032.1 for details.  Also know that the described procedure doesn't fully remove your OLAP object and that you have to drop some manually according to Note 1060023.1.

Environment Variables from database table – Oracle E-Business Suite

Are you running Oracle E-Business Suite (EBS) / Applications and want to get an operating system level environment variable value from a database table, for example for use in PL/SQL? Or perhaps to default a concurrent program parameter? Didn't think environment variables were stored in the database?

Try out out this query that shows you $FND_TOP:

select value
from   fnd_env_context
where  variable_name = 'FND_TOP'
and    concurrent_process_id = 
      ( select max(concurrent_process_id) from fnd_env_context );


Or did you want to find out the Product "TOP" directories e.g the full directory path values from fnd_appl_tops under APPL_TOP?


Job Market

The job market must be getting a little better. In the last weeks I've had three recruiter calls and they actually had jobs to fill.

Upgrading to R12.1.2, Tip #1

While applying patch 7303033 on top of a 12.1.0 R12 installation, I got the following error in one of my workers: FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/afscursp.lct @JTF:patch/115/import/US/jtfdiagresp.ldt - Connecting to APPS......Connected successfully. Calling FNDLOAD function. Returned from FNDLOAD function. Log file: /r12u/apps/apps_st/appl/admin/UPG/log/

Oracle EBS Release 12.1 Released: Top 8 New ATG Features

Oracle has announced the availability of Release 12.1, plenty of buzz around on this and Beehive updates.

Update: Oracle Application Management / Change Management Pack 3.0 also released! See Patch 8333939

Let's take a look at the Top Eight R12.1 new ATG (Applications Technology) features from my perspective.

  1. Out of the box Techstack Upgrades. New R12.1.1 installations are Database, Java 6, Application Server (Java/OAF)/JDeveloper Runtime, Application Server (Forms/Reports)
  2. OAF: Record History. R12.1.1 OAF allows viewing Row/Blame or Row/Who information similar (more...)

Search Engine Plugins for Firefox to get directly to specific Oracle Patches, Metalink Notes, Bugs

Revisited again 30-NOV-2010: Following the ARU change I've updated the Patch search engine (file orapatch.xml)

Update: The Note and Bug search engines (files oranote.xml and orabug.xml) have been updated post upgrade to My Oracle Support (MOS).

Navigating directly to a specific Oracle Patch, Metalink Note or Bug is a bit of a chore. Not to mention Metalink / My Oracle Support (MOS) could do with a mobile interface to speed things up & sidestep that Flash! Cut'n'pasting from my text file with the URL templates was getting tedious. So with inspiration from Eddie Awad's posts, I've (more...)

Don’t Cramp My (SQL) Style … Musings from an Oracle DBA

This post was inspired by a Twitter thread that took place on October 31st between myself, @oraclenerd, @dtseiler (maybe I only included Don for his tongue in cheek, playground banter), and @surfsearcher :
@oraclenerd: "besides commas at the start of a line (sql, plsql), I also hate mixed case sql and plsql"

@oraclenerd: "@piontekdd come on! it's just plain ugly...besides, I've gotta have have at least a little something to bitch about now and again. :) "

@piontekdd: "@oraclenerd life is too short to get upset about personal style :)"