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.
Introduction:- In this article, will discuss how to resolve serial number in context file contains lower value than that of database copy. ERROR: InDbCtxFile.uploadCtx() : Exception : Error executing BEGIN. Reproduce error ‘Serial number in context file contains lower value than that of database copy’. This error will occur when the value for s_contextserial in … Read more
Introduction: – Here we are discussing ‘how to create the patch file system in R12.2’. Execute perl adcfgclone.pl appsTier to recreate the patch file system in r12.2. Follow the below steps to create the patch file system in R12.2′. 1) Run adpreclone: On the RUN File-System, source RUN File-System: $ source EBSapps.env run RUN Admin server … Read more
Introduction:- In this article, we will discuss how to resolve Adop Fails With Error: ssh is not enabled for the following nodes. Use the txkRunSSHSetup.pl command to enable SSH. The error message “ssh is not enabled for the following nodes” typically indicates that there’s an issue with SSH connectivity for certain nodes in the context … Read more
Here we will learn, how to find out user id responsibility id and application id in oracle apps . $SQL> select user_id from fnd_user where user_name=’SETUPADMIN’; Steps to find out user id responsibility id and application id. To know about User Id use below Query:- To know about Responsibility id use below Query:- To Know about Application … Read more
Introduction:- In this article, we will learn how to configuring hugepages on linux. Create a file called “hugepages_setting.sh” to Configuring HugePages with the mentatory contents. HugePages:- The operating system keeps each 4 KB of memory as a page. When it allocates pages to the database System Global Area (SGA), the operating system kernel must continually … Read more
In this article, we will know how to enable personalization page link in OAF pages. We will set the some profile in frontend to enable. To Enable Personalization Page link in OAF Pages. We need to be set the below profile for on site or user level. In order to set these profile option Navigate … Read more
In this article, we will know how to find PID by SID in oracle. To know about PID, we need to exucute the sql query to identify. On daily basis we are checking the os pid from sid to check the performance issue. Some time user session got hung or blocked any objects and that … Read more
In this post we will learn how to find SID from Concurrent Request to identify the slowness issue. What is SID in Oracle Database session:- SID is session identifier. Used to identify uniquely for session, after the session is over, this sid can be used for other session. Sid is analogy of pid in OS. … Read more
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