Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Here we will cover how to prepare Shell script to File transfer file on remote system using ftp. Below is the procedure to ‘copy file using file transfer protocol (FTP) shell scrip’ an we will see ‘How to Use Linux FTP Command to Transfer Files’. In this shell script(filetoftp.sh) we will receive notification on mail if file … Read more
Introduction:- In this article, we will cover how to create oracle wallet to secure external password store. A wallet is a necessary repository in which you can securely store user certificates and the trust points needed to validate the certificates of peers. Oracle secure external password store:- The following steps provide an overview of the complete … Read more
EBS login Error:- Unable to Authenticate Session in ebs r12.| In this post we will cover how to clear browser cache and history and resolve unable to autothenticate session error in R12. When facing Unable to Authenticate Session in EBS R12? When user try to login to E-Business Suit R12.*.*. with two different instances in … Read more
To compile forms(.fmb) and libraries in R12, we will use frmcmp_batch (form compiler). In earlier EBS version(11i) we were using f60gen to do so. Step 1> Login on application. Step 2> Go to related directory $AU_TOP/forms/US Step 3> Place “.fmb” file under directory. Step 4> Execute the below command to generate “.fmx”. Format:- frmcmp_batch userid=apps/<password> … Read more
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