Starting My Blog back again based on my field expeience Since 2008 where I left this blog (Step by Step Oracle Product Implementaton Series )

I am back on my blog and will start writing Step by Step series on Oracle Database 12c,Exadata, Golden Gate, RAC,ASM,EBS R12, Fusion Applications, Fusion Middleware products (IDM/IAM/Web Center/Spaces/SOA), OBIEE/OBIA, Goverance, Risk and Complance GRC/GRCI/CCG/PCG), SSL and many more articles on various Oracle products which can help Oracle Community. Also I am going procure a high end server soon so that I can build Step by Step Oracle Series with Integration of these products which may take some time. I would like to mention here as time allows you will see always step by step instruction to build these enviornments at your home ,office and where you are located. I promise to as detailed as I always use to be in my previous posts." I would highly appreciate if you provide your feedback what you would like to see more on my blog and don't find in other great blogs. Feedback is really appreciated and help me to get going to this long journey. Regards, Ramnik Gupta Author of this Blog and serving Oracle Community by sharing my field experience

Oracle Applicaitons (EBS)11.5.9CU2 upgrade to R12.1.3 includes Platform Migration from HP-UX 11.23 to HP-UX 11.31 and Integration with Portal/SSO/SSL

Oracle Application 11.5.9CU2 upgrade to Oracle application R12.1.3. This upgrade includes upgrade from Portal 3.0.9 , Portal Login server/SSL to Portal 10g/SSO/SSL. Also database upgrade from 9.2.0.7 to 10.2.0.4 patchset. Also I am going to discuss about various paths to upgrade to R12..

The most important aspect of the upgrade to assess you current EBS 11i system techinically and functionally.

Here in the article will be going to cover the technically aspect but will give some guidance on functional aspect.

On Hold.

Step by Step Information on R12 - How to Validate APPS Schema

In day to day activity DBA's encounter issues related to invalid objects. Common solution to the problem is running adadmin utility and utlrp script. In this post we are going to discuss invalid APPS schema not objects.

Now the question must be in your mind in what situations you really needs to validate the APPS Schema.

Here we go....

If face any problem with AD_DDL package at runtime

When patch is applied. You can run this only once even you apply more then one patches at a time.

If you upgraded Oracle applications or applied Maintenance pack

After migration using export/import

After Custom development of APPS Schema

Methods to validate APPS Schema

On Unix:
1. Run system/passowrd @$AD_TOP/admin/sql/advrfapp.sql
2. Using adadmin utility and opt for "1. Validate APPS Schema" under "Maintain Applications Database Entities".

Steps to Validate APPS Schema


1.Run adadmin utility. Select the option "Maintain Applications Database Entities" from main menu of AD Administration.

2.Select "Validate APPS Schema" from sub-menu of "Maintain Applications Database Entities".

3. Now review the output file located at $APPL_TOP/admin/SID/out. The report name will be .lst. Look for any missing or invalid pacakges , synonyms or invalid objects in APPS schema. Also check and verify for table or sequences in APPS and base schema. Follow the instruction in the file to resolve any issues.

Hope this helps.