About

Martin Klier

usn-it.de

R.I.P. Oracle Database 10g: “Oracle depends on humidity”

Or: “Why we should be happy about Adaptive Cursor Sharing” Premier Support for 10g R2 ended in July 2010, and Extended Support will end in July 2013, 11gR2 is widely used, and 12c is on the horizon. Maybe it’s time for writing a kind of obituary for my first Oracle love, and to spread a […]

read more

Oracle srvctl does not remove EONS despite it’s documented (PRKO-2013)

srvctl in Oracle Grid Infrastructure 11g Release 2 has at least one discrepancy between docs and functionality. I saw EONS consuming lots of memory in a non-database grid installation, and wanted to get rid of it. (The eONS is used by Oracle Enterprise Manager to receive notification of change in status of components managed by […]

read more

Oracle Grid Infrastructure 11gR2: How to clean up to repeat root.sh

To clean up a tilted installation of Oracle Grid Infrastructure isn’t that intuitive. I had to do it today, and this is my collection what to do and what to read. It’s made for repeating root.sh, that’s not allowed to run twice or more times without cleaning up in between. So first have a look […]

read more

DOAG Konferenz 2009: Impressions Day 2

As promised, today my impressions of yesterday (confusing, I know). Clarification: This is about Wednesday, November 18th. I’m still at DOAG Conference 2009 in Nuremberg. Wednesday was a silent day for my interests, especially at noon there have been less talks being of interest, but maybe they have done something for my general knowledge… So […]

read more

Oracle 11gR2 ASM / ACFS: A first benchmark (poorly)

Hi folks, since Oracle 11g Release 2 is out now, I had to test one of the most-missed ASM features: the ASM cluster file system ACFS. My Setup: Two VMware nodes with 2 CPUs and 1,5GB of RAM each Oracle Enterprise Linux 5.3 x86_64 Four virtual cluster disks from the ESX server, 10GB in size […]

read more

Oracle 11gR2 ASM: Changed permission policy (ORA-15260)

Did you recently see the new error ‘ORA-15260: permission denied on ASM disk group’ in your ASM administration? Maybe you are still connected as SYSDBA, old habit from 10g? A quick citation from the Oracle Docs: The SYSOPER privilege permits the following subset of the ALTER DISKGROUP operations: diskgroup_availability, rebalance_diskgroup_clause, check_diskgroup_clause (without the REPAIR option). […]

read more