February 2014 archive

Obtain Database Patchsets

I see this question asked often on the My Oracle Support Communities, so it must not be that obvious as it seems to be. So I figured I would post this on my blog. The question is “how do I obtain the XX patchset for my Oracle database”? Sometimes people post the link to the …

Continue reading

Oracle Interface Changes

I regularly participate in the My Oracle Support Communities and answer lots of questions there. Late last week, Oracle changed the interface and like many people, I haven’t necessarily found it to be better. I am getting used to the new UI. And as I use it more and get past the learning curve, it …

Continue reading

TEMPFILE Offline Physical Standby

I received an alert from Enterprise Manager Cloud Control that a tempfile was offline in my physical standby database. Message=The temporary file /u01/app/oracle/oradata/ncpp/temp/temp01.dbf is OFFLINE. We recently did a restore of the standby, i.e. recreated it from a backup. Surprisingly only 7 of the 8 tempfiles were available. One tempfile was missing. I found this …

Continue reading