About

Martin Klier

usn-it.de

Oracle dbms_workload_repository awr_global_report_text fails with ORA-06553 PLS-307

My last post was about generating AWR reports from SQL – not a very complicated case. “But” – little word, big meaning. And suddenly we get a strange error message. In my example, I was especially interested in a Real Application Cluster’s “global” report. The subprogram call for that purpose is dbms_workload_repository.awr_global_report_text(), accepting the DBID, begin […]

read more

Martin Klier in DOAG.tv Interview: Oracle Standard Edition

A while ago, DOAG.tv interviewed me about Oracle’s Standard Edition and database system migrations. The material was published just recently, so I’d like to share it. Enjoy, and if there are questions, just let me know! http://www.doag.org/home/aktuelle-news/article/oracle-database-standard-edition-versus-enterprise-edition.html I have to add a corrigenda: SE RAC is not – at least not at the moment – limited […]

read more

DOAG Presentation: Oracle Standard Edition RAC

Wednesday last week, I had a presentation for my regional Oracle Users Group (DOAG Regio Nürnberg). The month before I was asked to display the difference between Enterprise Edition and Standard Edition RACs. Here comes the presentation (German), for questions and suggestions just let me know. Stay highly available Martin Klier […]

read more

Upgrading Oracle Clusterware: [INS-40406] The installer detects no existing Oracle Grid Infrastructure software on the system

Upgrading Oracle Grid Infrastructure 11.2 (it’s just another marketing name for the Oracle Clusterware, formerly known as Cluster Ready Services CRS) usually is easy: The runInstaller offers an upgrade mode, and discovers nodes and versions without further effort. But what, if not? The message will be “[INS-40406] The installer detects no existing Oracle Grid Infrastructure […]

read more

Oracle Clusterware 11.2: ASM crashes at startup

These days, a customer’s Oracle Clusterware (2 nodes) crashed one ASM instance at every startup. More Facts: It was not possible to start it manually, too. The CSSD was running. For obvious reasons, CRSD did not start. The other ASM instance in the cluster recognized CLUSTER RECONFIGURATION for a short period of time. The ASM […]

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