Quick tip on how to compile apps schema (or invalid objects in database) in Oracle applications R12
 You can compile invalid objects (or Apps Schema) using below three methods (compiling invalid is not limited to these three methods)
1. From Database Tier
a) Login as database tier user (ovisr12 in my case)
b) Set environment variable (under $INSTALL_DIR/db/tech_st/[10.2.0 or […]

Popularity: 3% [?]

read more from this topic.....

This post is from our Oracle Apps DBA Online Training [Weekend batches only for USD 699 from Home] here , next batch starting on 28th Feb 2010. 
In this post I am going to cover Oracle Apps R12 Installation with link to Oracle Standard Document, Metalink Notes and link to sites including common installation issues
.
Oracle Apps R12 Installation Keypoints
Check Oracle Apps R12 […]

Popularity: 7% [?]

read more from this topic.....

This post covers steps on how to troubleshoot “Unable to call fnd_ldap_wrapper . create_user / update_user” issues. This is similar to issue I discussed here in May 2009
.
Setup - E-Business Suite (11i/R12) integrated with OID/SSO
Issue- Error while creating/updating user in EBS 11i/R12 - Unable to call fnd_ldap_wrapper . create_user | update_user
.
This error could be because […]

Popularity: 12% [?]

read more from this topic.....

Let suppose below is the read me file of one patch says:
This patch contains one or more driver files to be applied with AutoPatch.
Please apply the driver files in the following order (if they exist) :
c3196140.drv (This is the copy driver)
d3196140.drv (This is the database driver)
g3196140.drv (This is the generate driver)
How can I identify that […]

Popularity: 8% [?]

read more from this topic.....

On popular request from newbie I am posting few more Apps DBA Interview Questions (around Installation). If you are new to Oracle Apps and prefer book then you can order one from Amazon written by Joyjeet Banerjee - Cracking the Oracle Apps DBA Interview: 325 Frequently Asked Questions 
Q1. Which user you use to install Oracle Apps 11i/R12 on Unix/Linux ?
A: […]

Popularity: 10% [?]

read more from this topic.....

[Preliminary Note: Please do not try it on PRODUCTION Instance until you have applied it on TEST]
During working on 12.0.6 running on Linux environment I received a complain from the user that:
“Their XML reports (.rtf) are taking too much time in running and ending in Warning status”.
Following is the message I saw in all the […]

Popularity: 8% [?]

read more from this topic.....

Patching : is process of Bug Fix, adding new Functionality or enhancements. Depending on component (database, apps, forms/report) there are different tools to apply patches.

adpatch - is utility to apply Oracle Apps Patches (This utility usually updates files under $APPL_TOP, $JAVA_TOP and Database objects)
opatch - is utility to apply database and application server (10gR3 for forms, reports and web […]

Popularity: 8% [?]

read more from this topic.....