Writing About Our Experiences With Oracle Databases
Friday July 30th 2010

Latest Topics

DBMS_SCHEDULER jobs not running?

I came across this posting on OTN which lists down things to check in case your scheduler job is not . This is quite [Read More]

‘Metric execution timed out’ error reported by Grid

We use 10.2 Enterprise Manager Grid control  to monitor our oracle database environments . Apart from the normal [Read More]

Downloading Oracle Software directly to Server

Downloading Oracle Software directly to Server

This article is based on Pythian’s aricle DOWNLOADING FROM OTN DIRECTLY TO YOUR DATABASE SERVER. Article [Read More]

11gR2 Silent Install errors with [SEVERE] – Invalid My Oracle Support credentials

While performing  11gR2 RAC Database Software installation with response file (silent mode), I got this error. - [Read More]

opmnctl start fails when ORA_NLS10 parameter is set

I got into this issue , where in while starting Grid Control components, opmnctl command failed with following errors [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

Deepak had this to say

Thanks a lot Amit. Very useful doc. Please update something more like this. Read the post

Amit had this to say

Upload the cookies.txt file in same directory from where you are running the wget command. Did you try downloading Read the post

inoideas had this to say

I tried but got the below error msg wget .load-cookies=cookies.txt --user-agent Mozilla/4.0 Read the post

Richard had this to say

Hello, Great this tip that you sent, you helped me so much. but take care when to use dd command. Regards, Read the post

Ram had this to say

This is very straight forward and clear.It has become easy when compared to referring the looong docs. Read the post

More from category

DBMS_SCHEDULER jobs not running?

I came across this posting on OTN which lists down things to check in case your scheduler job is not . This is quite [Read More]

11gR2 – SysAsm vs SysDba

SYSASM role was introduced in 11gR1 and was designed to administer ASM instances. In 11gR1 , if you connected with [Read More]

ORA-27146 Errors while starting up Database

Short post on a issue faced by me, while starting up a cloned database SQL> startup nomount ORA-24323: value not [Read More]

Don’t blindly implement Blog suggestions on your Production Servers

Don’t blindly implement Blog suggestions on your Production Servers. This post is prompted by a recent issue [Read More]

Oracle Patch Set update (PSU 2) released for 10.2.0.4 and 11.1.0.7

Oracle has recently released Oracle Patch Set update (PSU 2) along with CPU October 2009. As informed earlier , PSU are [Read More]