Monday, 16 April 2007

Oracle Expert Program

Oracle Education has recently started new concept known "Oracle Expert" in certification which I think is very good as this will help us going for specialization within Oracle.

There are many streams which DBA's or Oracle Apps DBA can go for :
  • Oracle Database 10g: Managing Oracle on Linux Certified Expert
  • Oracle Database 10g: Real Applications Clusters Administrator Certified Expert
  • Oracle 11i Workflow Certified Expert
  • Oracle 11i System Administrator Certified Expert

The first two will be released soon in Beta version but the later ones ( For Oracle Apps DBA) have been released in Production.

For details , Visit Oracle Certification website:

http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=145

Monday, 2 April 2007

Cloning of Oracle Application

This is one of the most usual tasks given to Apps DBA and from my past exp., DBA's spend more than 70% of time in Cloning.

Cloning Oracle Apps 11i is done through a tool given by Oracle known as RAPID CLONE and it is very easy to use but it does not do all the bits....

When u clone the env, there is a ref of the source env in the database in FND_NODES tables , thus after clone if u visit the OAM page , u will see both source nodes and target nodes . Also u will be some concurrent managers which have got ref to source nodes.

If u want to get rid of the source nodes , Do the following :Follow the Rapid clone document (Metalink note : 230672.1)

  • Prepare the Source System ( Pre Clone Steps )
  • Copy the Source System to the Target System
  • Configure the Target System
    o Configure the target system database server
    o After the database is created ,connect as apps and execute the following
    EXEC FND_CONC_CLONE.SETUP_CLEAN;
    Commit;
    o Above cmd will clean the FND_NODES table and does something more than that i.e.

c lear the concurrent manager tables etc.
o Run the autoconfig.sh again on the database tier

And there after follow the doc Metalink note: 230672.1

Sunday, 1 April 2007

Oracle 11i Applications Technology Certification Update

Good news from Oracle for Oracle Apps DBA regrading certification .

Now it is easy to get certification for Oracle Apps DBA if u have 10G OCP or 9i OCP .

After careful review from the beta exams and DBA/customer feedback , the exams 1Z1-231 Implement Oracle Workflow 11i and 1Z1-232 Oracle 11i System Administration have been reapportioned so that the resulting credentials better fit their corresponding job roles.

Now if u have 9i or 10G OCP , u have to appear for one Apps exams to get OCP for Oracle 11i Applications Database Administrator Certified Professional ..

For more details , Please visit Oracle website

http://www.oracle.com/global/us/education/certification/appsdba.html