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

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

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

How to find the Oracle Developer version ...

It is a very common question to find out the version of the Oracle Developer installed with Oracle Apps .What version , how to find out the version number and how to upgrade it.

This is required if u are planning to upgrade the oracle application database from 9i to 10G. One step is to upgrade the developer version

To find out the developer version ...Set the Apps env and use the following command :

Run $ORACLE_HOME/bin/f60gen help=y to display various component versions

How to upgrade the Oracle Developer version ?

Follow Oracle Metalink note : 125767.1 : Upgrading Developer 6i with Oracle Applications 11i

Quite simple....takes around 30 mins ...

I dedicate this BLOG to the following :

My mentor and my Guru Sandeep Pandya for giving me directions in learning Oracle Application and gave full support during my learning curve as Oracle DBA and Oracle Apps DBA.
While working with him , I learnt not only Oracle but other softskills like ITIL concepts , presentation skills.

My wife Anshul for her support and patience, inspite lot of personal time I spent in Office working late...

My kidsApoorv and Anvi ...

About me;

Vivek is Director of Karma DBA and has over 10 years of experience as an Oracle DBA and 6 years as an Oracle Apps DBA managing a variety of database systems, DBA teams and infrastructure projects. Worked within pan-European organisations in various sectors including Telecoms, top-tier consultancy, retail/marketing and banking.

About Karma DBA

A UK based organisation offering consultancy and remote support services for Oracle Applications and Oracle Technology based systems. Our in-depth experience of managing Oracle technologies and projects will compliment your internal or partner resources to improve productivity, efficiency and reduce cost of ownership. Visit www.karma-dba.co.uk