Oracle EBS R12: Install, Patch and Maintain Applications [1Z0-238]

This new exam is required as part of earning the new Oracle EBS R12 Applications Database Administrator Certified Professional certification.

By participating in this beta exam, you have the opportunity to provide the Oracle Certification program with feedback about exam content which is integral to the process of exam development. We depend on the contributions of experienced professionals and developers as we continually improve exam content and maintain the value of Oracle certifications.

There are a limited number of seats available for the beta exam. The beta version of the exam is only available for a limited period as well.

Note: You will be given 3-3.5 hours to complete the beta exam. Please plan accordingly

Testing is held at Prometric testing centers worldwide, although this exam may not be available in all countries. You must register at least 24 hours prior to taking the exam. Contact your exam provider for seat availability.

Registration begins:
December 13, 2007

Beta exam period runs:
January 03 – April 04, 2008

Click here for more info.

This mail has been published by Oracle.

posted by Jaswinder Singh @ 10:52 PM 0 comments

Do You Know About Oracle Certifications!!!!!!!

Wednesday, December 12, 2007

Oracle is a leading provider of Relational Database Management (RDBMS) solutions to organizations worldwide. Oracle Database 11g is Oracle’s largest introduction of new functionality and is Oracle’s most innovative release, leading the database industry into new ground in clustering, automation, high availability and more. Oracle Database 11g extends Oracle's unique ability to deliver the benefits of grid computing with more self-management and automation. Oracle Database 11g Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industry’s most advanced database management system.

Benefits of Oracle Certifications • Oracle certifications demonstrates a solid understanding of the skills required for a given job role related to Oracle technologies.
• An Oracle certified professional gets more opportunity for career growth and higher pay.
• An Oracle certified professional can use the Oracle Certified Professional logo for endorsement of his skills.
• Oracle certified professionals have access to technical and other information from the OCP members-only web site.
• Oracle certified professionals get special discounts and offers from selected companies

Oracle Certifications Structure
In Database Oracle offers three levels of certifications
• Associate (Oracle 11g DBA OCA)
• Professional (Oracle 11g DBA OCP)
• Master (Oracle 11g DBA OCM)

In Middleware Oracle Offers two level of certifications
• Associate (Oracle 10g AS Administrator OCA)
• Professional (Oracle 10g AS Administrator OCP)

In Linux Oracle offers Specialization Expert (Oracle 10g: Managing Oracle on Linux Certified Expert)

Oracle Certification Registration
To register for Oracle Certifications click Register
Oracle – Download Links
1. Oracle 9i Install How to
2. Oracle Documentations
3. Oracle OCP Admin Exam doc

Some of Popular Forums for Oracle Preparation

• Oracle Forum
• OraFAQ Forum
• Oracle Database Forum
• Oracle - dBforum

posted by Jaswinder Singh @ 8:15 PM 0 comments

Maintenance Mode is a new mode of operation introduced with Release 11.5.10!!!!!!!!

Maintenance Mode is a new mode of operation introduced with Release 11.5.10, in which the Oracle Applications system is made accessible only for patching activities not allowing the users to login to any responsibility. This provides optimal performance for auto patch sessions, and minimizes downtime needed.

We can make the maintenance mode enable or disable either by using Ad utility (adadmin) or OAM(oracle applications Manager)

steps for enabling and disabling maintenance mode (adadmin)

1)Run the consolidated contextname.env file which is available in $APPL_TOP/ usually
file name is like APPS.env
Context name= SID_

2)start adadmin answer the subsequent prompts you can get the main menu of the adadmin utility select 5) change maintenance mode afterthat you will get another menu select 1)enable maintenance mode
3)When you Enable or Disable 'Maintenance Mode', adadmin will execute the script:
$AD_TOP/patch/115/sql/adsetmmd.sql sending the parameter 'ENABLE' or 'DISABLE' :

4)Even you can enable the maintenance mode by calling the scripts in sql prompt
sqlplus /@adsetmmd.sql ENABLE | DISABLE

5)When adsetmmd.sql runs, it sets the Profile Option 'Applications Maintenance Mode' (APPS_MAINTENANCE_MODE) to 'MAINT' to Enable 'Maintenance Mode' and to 'NORMAL' to Disable it.

After the auto patch process we have to disable the maintenance mode by using adadmin

How we know that maintenance mode is enabled ?

We can find out whether maintenance mode is enabled or not by executing the simple query

sqlplus apps/apps
SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

If the query returns MAINT then maintenance mode is enabled .
If the query returns NORMAL then maintenance mode is disabled

Maintenance Mode is only needed for AutoPatch Sessions. Other AD utilities do not require Mainten

posted by Jaswinder Singh @ 8:02 PM 4 comments

Useful Scripts!!!! Once try it .......

1. afimchk.sql Tells the status of the ICM and PMON method

2. afcmstat.sql Lists active manager processes

3. afrqrun.sql Lists all the running, waiting and terminating requests

4. afrqwait.sql Lists requests that are constrained and waiting for the ICM to release them

5. afrqscm.sql Prints log file name of managers that can run a given request. It can be used to check for possible errors when a request stays in pending status. It
requires a request id value.

6. afcmcreq.sql Prints the log file name of the manager that processed the request

7. afrqstat.sql Summary of completed concurrent requests grouped by completion status and execution type. It requires number of days prior to today on which to report parameter.

8. afimlock.sql Lists locks that the ICM is waiting to get

9. afcmrrq.sql Lists managers that currently are running a request

posted by Jaswinder Singh @ 7:50 PM 1 comments

About Me

Name: Jaswinder Singh
Home: Bangalore, Karnataka, India
Certifications: RAC Certified Expert, OCP 9i, 10g & 11i
About Me: I am working as APPSDBA, have hands on experience on DB RAC, HA on OAS 10g and Oracle Applications.
See my complete profile