Oracle Apps Administration

In this post we will how to update database tier to latest code. Updating database tier nodes with the latest code, by performing the following steps: Steps to create appsutil.zip on appsTier to update database tier to latest code. On the application tier (login as the applmgr user): Source the run edition environment file. UNIX: … Read more

Run autoconfig on db tier and apps tier| Basically autoconfig is tool to reconfigure your Oracle Application configuration files using context (XML file) and template files. Best steps to Run autoconfig on db tier and apps tier. To run autoconfig in ebs R12.*.*. We need to follow the below steps to run autoconfig on DB Tier and Middle … Read more

Errors while applying 12 2 5 RUP Patch| Recently EBS system got hanged while applying 12.2.5 RUP Patch (19676458) and adop exits with the errors.   Errors while applying 12 2 5 RUP Patch   $adop phase=apply apply_mode=downtime patches=19676458 abandon=no restart=yes   Enter the APPS password:   Enter the SYSTEM password:   Enter the WLSADMIN … Read more

Introduction:- Ora 24816 expanded non long bind data supplied After Actual Long Or Lob Column| In this post we will fix ora 24816 while applying patch in ebs r12. Ora 24816 expanded non long bind data supplied Error:-    ATTENTION: All workers either have failed or are waiting:              FAILED: … Read more

While apply the missing patches in ebs during upgrading below error coming.| Opatch apply cannot set up oui inventory session error . ERROR: OPatch failed because of Inventory problem.     opatch apply cannot set up oui inventory session error   $opatch apply   Error:-    OPATCH_JAVA_ERROR=OUI Version: 11.1.0.11.0 OPATCH_JAVA_ERROR=OUI Version: 11.1.0.11.0 OPatch requires OUI … Read more

RunInstaller checking operating system version failed: must be redhat-2.1AS, redhat-3 or redhat-4 Failed| We are facing this error while executing runInstaller. Here we will fix this error in very simple way. RunInstaller checking operating system version While executing runInstaller below error coming.    [applmgr@test install]$ ./runInstaller   Starting Oracle Universal Installer…   Checking installer requirements… … Read more

Introduction:- The Technology Codelevel Checker (ETCC) utility provides two shell scripts (checkDBpatch.sh & checkMTpatch.sh) to ensure all the necessary database and application tier patches are installed on a 12.2 system.   Is it mandatory to Run The EBS Technology Code Level Checker?   Oracle strongly recommends the use of this utility to ensure that all … Read more

Introduction: – Here we are discussing ‘How to create physical standby database using rman backup restore’ in oracle database. We will follow the simple steps to create standby database. Steps to create physical standby database. Step 1:- Connect to primary database and check recovery area.   SQL> show parameter db_recovery;   NAMETYPEVALUE ———————————— ———– —————————— … Read more

To create directory in oracle we can use ‘create directory‘ statement (CREATE OR REPLACE DIRECTORY <directory_name> AS ‘<operating_system_path>’;). In this article, we will learn how to create directory in oracle. The following statement will create directory oracle database object that points to a directory on the server: How to create directory in oracle. Syntax: – … Read more