Right now all the modern apps system are running on Modern R12.2.x version. R11i is fairly obsoleted. These steps will help DBA still working on these legacy system Steps to upgrade 11i Application database to 11gR1 1) Oracle Application Prerequisites patches before upgrade : Interoperability notes for Oracle Applications 11i with 11gR1 – 452783.12) Install […]
Steps to upgrade 11i Application database to 11gR1 Read More »
Sometimes we have different errors in the Oracle system because of duplicate objects in SYS/SYSTEM. This can happen as catalog.sql and catproc.sql were mistakenly run while connected as both users. In most cases, the only objects which should exist are those owned by SYS. The output can help determine which objects should be dropped from the SYSTEM schema. The
How to clean up duplicate objects in SYS/SYSTEM Read More »
To generate and edit the Oracle EPM System Registry report, navigate to your instance’s bin directory and execute the epmsys_registry utility. Running the command without parameters generates an HTML deployment report, while appending flags like updateproperty or viewencryptedproperty allows administrators to safely modify database connections and component configurations from the backend epmsys_registry utility in Hyperion
How to generate epm registry report and edit it Read More »
To determine the Run or Patch file system in current Oracle EBS environments, DBAs can grep for the file_edition_type variable within the CONTEXT_FILE, source the EBSapps.env script, or query the fnd_oam_context_files database table from the backend to extract the active XML parameters. Oracle Apps R12.2 has two filesytem to enable online patching. We can determine
How To Determine Which File System is the Run or Patch File System in R12.2 Read More »
Many times, you might need to update a profile for multiple users. Changing through the form will be a tedious job, we can change using the plsql procedure from the backend. Here is an example to set the Apps Local Login Type to LOCAL for Multiple users SET SERVEROUTPUT ON SIZE 1000000DECLARE cursor user_cur isselect
Script to Update a profile for Multiple Users in EBS Read More »
To execute Oracle SQL from a Linux shell script, configure your environment variables (like ORACLE_SID), invoke sqlplus, and use a Here-Document (<<EOF) to pass queries directly We have learned the basics of shell scripts.Now its time to turn to more useful advanced shell scripting side. Here are the Useful Advanced shell scripting examples for Oracle DBAs
Advanced Shell Scripting Automation for Oracle DBAs Read More »
