R12 certified DBA EXAM

R12 Oracle Certified DBA

.Hi Everyone!!




I took my R12 DBA(Oracle E-Business Suite R12: Install, Patch and Maintain Applications) exam today and passed. Here is the information that you may would like to know to become certified R12 DBA. Certification Track diagram

If you are 10g or 11g or 11i OCP then take exam 1z0-238(for both upgrade and new track). you will become R12 Apps DBA Certified Professional. More details on the certification track can be found at oracle website http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=210


Exam preparation can be based on the link http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=1080544&lang=US&p_exam_id=1Z0_238

Some of the questions were easy and some were really made you to think thrice to choose the answer. There were 75 questions and 90 minutes exam duration. If you have ILT material that would help you a lot in preparation of the exam. I have borrowed ILT material for a day from my colleague to skim through.


Hope this helps to make more R12 certified DBAs.

AUTOCONFIG

Converting Autoconfig to Automagic!!!

In the middle of Snow and freezing weather I was thinking about autoconfig.

The word 'automagic' used by Bill, my counterpart in my previous employment with Oracle came into my thought.

Yes, Autoconfig is really a cool tool for apps dba. It manages the entire configuration of application system in a single unified file system, as a $CONTEXT_FILE. But I felt there is little fine tune required on that tool to make it as automagic tool.

In an average, each autoconfig takes less than 3 minutes in database tier and 5-8 minutes in appltop( and again this depends on the system speed). When it comes to production database instances 5-8 minutes are little high for one run of autoconfig. Say in a year if you run autoconfig for 10 times in appltop, its equivalent to more than one hour downtime!!!!

what can be done to reduce the downtime?

--> Run the tasks in parallel - As autoconfig consists of multiple steps INST8, INST8_SETUP etc.. there is a need to clearly segregate which tasks can be done in parallel, and run them against each product in parallel if possible run for all the products in parallel depending the CPU/memory resources available in the customer boxes. - Its likely that system will have enough resources to run the autoconfig tasks as Mid-Tier will be down during the autoconfig run.

--> Autoconfig run can be split up into two - say predownrun(pre downtime run) and downrun(downtime run), during the predownrun autoconfig can instantiate the files(and the tasks that can run when the system is up and running) and can keep it the folder or in DB, and during the downtime autoconfig can take the folder files which are already instantiated and place them as configuration files(simple copy in lieu of searching tokens in template file and replace them), by this way at least 2-3 minutes can be saved in each run. Thus 20-30 minutes in a year!!

These are just few thoughts that may help reduce the production downtime(for one customer of oracle in a year will reduce 20-30 mins downtime approximately. So it can be multiplied by the number of Oracle's customers to calculate the total minutes of downtime can be saved. In multi node environments you will be running autoconfig multiple times!!!

Above said ideas may be implementable or may not be. Only Oracle can gauge them and can come up with new bright ideas to reduce the downtime and make the autoconfig, automagic.

Patchset uitility

Patchset Uitlity to check installed patchsets and Family Packs

Hello Everyone!!!

Here you have a good tool to know.

patchset.sh is quite a good tool to evaluate the currently installed Oracle Applications' patchsets and Family Packs.

Note 139684.1 provides in depth details about this utility.

Here is the simple example, when you need to use this tool.

1) You want to know what is the current AD level of your system.
2) whether your system is at ATG RUP4 or RUP5 or RUP6(yet to be released!!)

Note: Its advised to download the latest version of this tool from
ftp://ftp.oracle.com/support/outgoing/PATCHSET_COMPARE_TOOL/patchsets.sh

If the ftp link is not working, try manual ftp as follows:
NOTE: Put the full path in for the get.

ftp ftp.oracle.com
login as an anonymous user, and then:
get support/outgoing/PATCHSET_COMPARE_TOOL/patchsets.sh

and finally this script works perfectly for 10.7, 11.0.x, 11.5.x, and 12.0.x !!!

Hope this helps you better in many ways!!