Writing About Our Experiences With Oracle Databases
Thursday September 9th 2010

Latest Topics

Renaming Diskgroup containing Voting Disk and OCR

Recently encountered a issue where we had to rename a diskgroup for 11.2 RAC containing OCR and Voting Disk.At this [Read More]

Effect Of Multiple SHMMAX Settings

Last week I saw a warning message at database startup time saying: WARNING: EINVAL creating segment of size [Read More]

Finding blogging tough? Just copy and do find and replace

Finding blogging tough? Just copy and do find and replace

Well this is motto followed by Guenadi Jilevski for his blog http://gjilevski.wordpress.com and he seems to get result [Read More]

Physical Corruption: ORA-1578 part 3

Recently we encountered a block corruption issue in 10g database on Linux x86 64 bit and using ASM for storing database [Read More]

Cloning RAC Database with RMAN fails with error

Steps for cloning a RAC database  with RMAN is similar to cloning a single instance database. But while using rman [Read More]

Changes To 10g OCA Certification

People planning to appear for  10g OCA Exam will be startled to find that they need to pass additional exam to get the certificate. Starting from December 1, 2008, in addition to the existing exam (Oracle Database 10g: Administration I (1Z0-042)), candidates are also required to pass any one of the four following Oracle SQL exams to earn the certification:

Introduction to Oracle: SQL® and PL/SQL™ (1Z0-001) or,
Introduction to Oracle9i: SQL (1Z0-007) or,
Oracle Database 11g: SQL Fundamentals I (1Z1-051) or,
Oracle Database SQL Expert (1Z0-047)

People who have cleared the IZ0-042 exam before 30 Nov 2008 are not required to give the exam. Below is snapshot from Oracle website detailing new Certification Path. You can find the details here

10g_certification1

  • Share/Bookmark
Related Tags: , ,

5 Comments for “Changes To 10g OCA Certification”

  • Laurent Schneider says:

    Come on, being an Oracle Certified SQL Expert enables you to apply for the OCA certificate? Oracle Education just confuses the customer more and more…

  • Tim Hall says:

    Hi.

    The DBA track should include an SQL component. It always used to, then Oracle removed to reduce the number of exams required to get the OCP. Adding an SQL compnent is necessary as a DBA without SQL is not a DBA in my opinion.

    I agree with Laurent, the SQL expert doesn’t really seem appropriate as a lead in to DBA OCA, but then I guess any proof of SQL skills is fine.

    Cheers

    Tim…

  • Amit says:

    Tim,

    Yeah. I too gave 9i OCP and cleared the SQL exam and then upgraded to 10g. But strangely it was removed from 10g. Now it’s been brought back clearly shows that people thought that it was important subject which should be part of 10g course. Anyways I came across this info on education site while checking pre-requisites for OCM course :)

    Laurent,

    As Tim pointed out, SQL Expert won’t be asked to write in separate exam to showcase his skills while appearing for 10g OCA. We can say that with this a SQL expert need to give only one exam to become OCA instead of writing 2 :)

    Cheers
    Amit

  • Israel says:

    i need past questions for my iz0-047 exams coming up soon. please send it to my mial idusraels@yahoo.com

  • Israel says:

    i need past questions for my iz0-047 exams coming up soon. please send it to my mail idusraels@yahoo.com


Leave a Comment

Recent Comments

Lalit had this to say

Nice article. keep it up buddy. Read the post

Renaming Diskgroup containing Voting Disk/OCR | AskDba.org Weblog had this to say

had done similar activity on 11.2 Single instance having database files (see this post) using renamedg. We tried using Read the post

csk had this to say

In my case the adding Disk to an existing Disk Group failed as the disk was not visible from other RAC node.Now the Read the post

Saurabh Sood had this to say

Hi CSK, In this case, the information is already written into disk header, and to reuse the disk the only option i s Read the post

csk had this to say

Yeah. I have opened SR with Oracle. Once I get solution , I will provide it here. Read the post