I recently developed a procedure to upgrade an Oracle 11.1 single instance database to Oracle 11.2 RAC. I remembered to add new redo threads, undo tablespaces, modify initialization parameters and to add the new database to the OCR. However, I forgot to run $ORACLE_HOME/rdbms/admin/catclust.sql which caused some errors in Enterprise Manager.
We are currently running failover tests on a three node Linux x86-84 cluster running Oracle 18.104.22.168 with the 22.214.171.124.2 PSU. As part of this process we have been examining how each failure is recorded in the log files. One of the log files we have been monitoring is /var/log/messages.
When a node is shutdown messages similar to the follow appear in /var/log/messages:
Just a few random notes. Oracle Mix have the Oracle OpenWorld 2011 Suggest-A-Session again this year with lots of good presentations as always. Follow the link to vote for my Q & A session on Oracle Indexing. Jonathan Lewis has an interesting quiz on Oracle Indexes in answer to a question from the OTN forums: “If I delete [...]
I’m sharing this in the hope that it will provide others with all the relevant information to understand this behaviour, should they hit it, rather than have to spend time searching MOS and performing their own tests. The information is there on MOS, but it took me a little time to find it (note IDs listed later).
“AWR is broken! We don’t have any snapshots over the weekend.”
Fri Jun 17 02:20:26 2011
System State dumped to trace file
Killing enqueue blocker (pid=191) on resource
CF-00000000-00000000 by killing session 56.1
What’s the best way to make a presentation on Agile practices? Practice Agile practices.
You could write a presentation “big bang” style, delivering version 1.0 in front of your big audience of 200+ people at Kscope 2011 before anybody has seen it. Of course, if you do it that way, you build a lot of risk into your product. But what else can you do?
There is a set of recorded tutorials available from the oracle maximum availability architecture team, that cover a range of topics.
The tutorials can be accessed at Oracle Exadata Best Practices Series
The topics include implementing Ebs, Siebel and Peoplesoft, resource manager, migration, DBFS, monitoring, backup and recovery, troubleshooting, patching and healthcheck.
Lots and Lots of great information.
It’s official – I’m writing a new book for Apress.
The working title is: “A look at the internal mechanics of the important bits of Oracle for people who aren’t planning to become rocket scientists but who do want to do a little more than just push buttons in OEM”. (I’m still working on making the title a little more catchy.)
Target publication time – some time in November.
Yesterday, I saw a Twitter post regarding the speaker evaluation results from SQL Rally 2011 in Orlando, FL last May. I was surprised to see that my session was in the top 3 best sessions of the conference. I dug up the Excel spreadsheet containing my session evaluation results and began to read. I found one comment very fascinating (the only evaluation where I got very low scores) as the response pertains to the speaker’s knowledge of the subject.