Monthly Archives: May 2010

EBS R12 nugget: The difference between adopmnctl.sh and opmnctl

23 May 2010 – 11:15

An illustration of the difference between running opmnctl and adopmnctl.sh in EBS R12

By jpiwowar | Posted in EBS | Tagged | Comments (0)

Old PLAN_TABLE in EBS Vision

21 May 2010 – 22:50

I went digging into a problem with EXPLAIN PLAN in and R12 Vision instance, and dug deep enough to find an antique.

By jpiwowar | Posted in EBS | Tagged , , | Comments (0)

Logging for non-existent listeners

16 May 2010 – 20:32

Trying to start a database listener that doesn’t exist generates log files. In older versions of the database, it’s just one file, but what about in 11g, with its fancy Automatic DIagnostic Repository?

By jpiwowar | Posted in Oracle RDBMS | Tagged , | Comments (0)

Resolving ORA-4023 during a 10gR2->11gR1 upgrade

13 May 2010 – 1:08

Sometimes, even on the 3rd or 4th run-through of a database upgrade test, it’s possible to miss something. Practice makes perfect.

By jpiwowar | Posted in Oracle RDBMS | Tagged , , | Comments (1)