Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Oracle Apps Administration categories is related to EBS issues and solutions.
In this post we will learn how to fix “internal manager does-not start-status actual 1 target 0′ issue in EBS. Some time Internal Manager not started properly due to this issue it shows actual 1 and target 0. In this scenario we will learn how to fix this issue. First of all we need … Read more
In alert log file error ORA-609 TNS-12537 and TNS-12547 or TNS-12170 reported. We are going to resolve this error after change parameter in sqlnet.ora file. TNS-12537: TNS:connection closed ERROR:- Alert log shows below error. Fatal NI connect error 12537, connecting to: (LOCAL=NO) Thu Oct 29 11:14:13 2020 Thu Oct 29 11:14:13 2020 … Read more
Introduction: – In this article, we will discuss how to fix ‘ ORA 1116 ORA 1110 and ORA-27092 Errors in oracle database’. Enter Password: REP-1401: ‘cf_policyformula’: Fatal PL/SQL error occurred. ORA-01116: error in opening database file 95. In alert log file below error are reported. ERROR:- Check the current status of ulimit. #ulimit -Sa core file size … Read more
Introduction:- We are Taking Oracle Database Rman backup Daily on our Production Instance. In this post we will learn how to configure RMAN backup jobs in Windows Servers. Follow the below given steps to create backup script and batch file to schedule task. 👉How to configure RMAN backup jobs? Here i will cover full steps … Read more
In this article, we will see How to create and use alias command in linux . An alias is a short cut command for long command. We may type short alias name to run a longer command or sql. An alias is a short cut command for long command. We may type short alias … Read more
In this article, we will learn how to transfer file using SCP . SCP stand for secure copy protocol. Its network protocol based on ssh (secure shell) that allow to transfer file/directory from remote local,local to remote host and remote to remote host. Additionally, you can use scp command in batch file or shell … 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