MOS KB articles for July 27, 2011

Checking recent articles I noticed that there are lots of Master Note type of notes
appeared on MyOracleSupport that come like aggregation of different links
related to topics. Exadata, RAC, Data Guard, Data Warehousing, etc..

It might be very useful when problems appeared or when knowledge
about the technology should be gotten. I wish those topics had RSS
feeds that can keep you informed about changes in notes.

And regular review of the Hot Topics e-mails made my life easier today
when I got a ticket about failure of backup of RAC 11.2.0.2 database.
I immediately recalled the note
RAC BACKUP FAILS WITH ORA-00245: CONTROL FILE BACKUP OPERATION FAILED [ID 1268725.1]
where location of snapshot controlfile should be on a shared storage

So I hope the change of snapshot controlfile location to ASM will
help to resolve the issue, we'll see tomorrow...


Another note that attracted my attention is
RACcheck - RAC Configuration Audit Tool [ID 1268927.1]
The utility simplifies the audit process of RAC configuration and allows not to forget
all important bits and pieces of complex architecture.


Have a good day!

MOS KB articles for July 20, 2011

During search in knowledge base on My Oracle Support site noticed
that now list of prompts appears based on typed letters, words.

It can be helpful despite results of search do not even have the same
phrase which were selected from suggested list.

Another observation - combination "ORA-" does not show any match,
might be because of too long list of similarities?

Today's Hot Topics e-mail got list of articles related to patchsets,
their avalability and known issues. For instance, note about 11.2.0.2
patchset 11.2.0.2 Patch Set - Availability and Known Issues [ID 1179474.1]
(as well as other notes about patchsets) has a list of issues
introduced in the release and their Bug ID.
Although they are not fixed, information about problems can be helpful
especially in case of upgrades and patching.

And finally - July 2011 CPU patches came for oracle products yesterday.
Happy patching!

Have a good day!

MOS KB articles for July 19, 2011

Several articles in Hot Topics e-mails drew my attention today:

10.2.0.5.5 Grid Control Patch Set Update (PSU) [ID 1335690.1]
good to know that PSU5 as well as PSU4 are OMS pathes only.

"hcheck.sql" script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g [ID 136697.1]
script creates a package under SYS schema that checks data dictionary for common dictionary problems.

Master Note For Oracle Database Server Installation [ID 1156586.1]
it is helpful that the document has links to silent installation notes as well.

11g Grid Control: Overview of the EMCTL Options Available for Managing the OMS [ID 1188803.1] that article might be valuable for those who spends lots of time managing Grid Control.


Have a good day!

MOS KB articles for July 17, 2011

There are things that being executed fast and some of them are:

Exadata queries and... vacation. Looks like I have not had it,

but that's it and I am back to winter Sydney from Russian summer.

But back to business...

Reviewing recent Oracle Support Hot Topics e-mails I noticed that

from July 10th format of the table with bugs had been updated

and now there are names of bugs already shown.

Great job MyOracleSupport!

I hope to see information about version and OS there in the table soon.

There is only one article in the e-mail for Sunday related to database server:

RAC One -- Changes in 11.2.0.2 [ID 1232802.1]

It contains information about major changes related to

RAC One in 11.2.0.2 and that now OUI, DBCA, srvctl,

DataGuard Broker are aware of RAC One database type.

Have a good day!