Oracle VM Consulting
view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

KScope Day 1

Day 1? Really, is that all? There are so many things going on it feels like day 3.

And I'm not even participating in everything since I'm also coming back to do some family time each day.

Chi Gung

I gave this a go this morning after not being able to find Kent on the first day. It was interesting and there were some good exercises that everyone should consider doing in the morning, though with respect to Kent, for me the woo outweighed a lot of good that can come out of meditation and moving your body.

dbnodeupdate.sh post upgrade step fails on Exadata storage software 12.1.2.1.1

I’ve done several Exadata deployments in the past two months and had to upgrade the Exadata storage software on half of them. Reason for that was because units shipped before May had their Exadata storage software version of 12.1.2.1.0.

The upgrade process of the database nodes ran fine but when I ran dbnodeupdate.sh -c for completing post upgrade steps I got an error that the system wasn’t on the expected Exadata release or kernel:

RMAN - 3 : The DB_UNIQUE_NAME in Backups to the FRA

When you run RMAN Backups to the FRA without using the FORMAT clause, Oracle automatically generates filenames for the BackupPieces.  The folder name is derived from the system date.  But what is the parent folder for backups ?  Is it simply the DB_RECOVERY_FILE_DEST ?  Actuallly, the DB_UNIQUE_NAME comes into play as well.

For example :

[oracle@localhost ~]$ rman target /

Recovery Manager: Release 11.2.0.2.0 - Production on Tue Jun 23 16:57:19 2015

Cloud agent set to DEBUG causing out of memory errors

The following technical detail was put together by a colleague John Evans and have taken it , with his permission, and wrapped some more detail around it as it seemed to be of real value to anybody who might have upgraded an agent to 12.1.0.4

Following an upgrade of the EM agent from 12.1.0.2 (or 12.1.0.3) to 12.1.0.4 after about 90 days of usage we saw a number of agents failing with out of memory errors.

Empty Leaf Blocks After Rollback Part I (Empty Spaces)

There’s been an interesting recent discussion on the OTN Database forum regarding “Index blank blocks after large update that was rolled back“. Setting aside the odd scenario of updating a column that previously had 20 million distinct values to the same value on a 2 billion row table, the key questions raised are why the blank index leaf blocks […]

You never stop learning

My mate Scott Wesley, whose specialty is Apex, is currently at Kscope having the time of his life (well, I hope so ).  He tweeted this picture last night of his conference badge, mainly about the “I love Apex” buttons, but something else struck me.

OCM 11g Preparation – Implement Data Pump export and import jobs for data transfer

Data Pump is one of the most basic things, but it has so many parameters that can transform in a complex thing.
Anyway, this utility is probably the most used tool for any DBA. So, try to focus during you training in the things that are not very common.
Be good exporting at tablespace / schema / database levels. Also, be ready to include or exclude something from backups (there are good DBA views to help you in those parameters as DATABASE_EXPORT_OBJECTS).
So, I would recommend you to study:

OCM 11g Preparation – Administer external tables

Creating an external is not a easy task. Why? Because, at least for me, this is one of the most complexes Oracle syntaxes.
So, the best approach for me in this topic is to go quickly in the documentation place of external tables and use a template.
Practice a bit to be prepared for the exam:

  • Create a SQL Loader external table
  • Test using some preprocessor script
  • Load a Data Pump file using external table
  • Create a Data Pump external table

Path do Documentation:

12c Parallel Execution New Features: 1 SLAVE distribution

When certain SQL features get used in pre-12c versions that force non-parallel evaluation, like using ROWNUM or certain Analytic Functions like LAG/LEAD, then - depending on the overall plan shape - Oracle can start to decompose the parallel execution plan into several so called DFO trees (If you want learn more about DFO trees and DFOs I recommend watching my online tutorial on my Youtube channel).Now having multiple DFO trees in a single parallel execution plan comes with seve

view counter