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, we will learn how to resolve ‘adpreclone pl fails on‘ application node. Follow the steps below give steps to resolve. adpreclone pl fails On Patch File System with following error:- In the Weblogic Console, Edit session is enabled in domain. Hence, adpreclone.pl is unable to complete successfully. Workaround:- Execute the following … Read more
Introduction:-In this post, we will discuss how to resolve socket000445connection rejected filter blocked while trying to access weblogic console in EBS R12. Error Encounterred:- While accessing the weblogc console http://xxxx.xxx-xxx.com:7026/console, we faced theissue as ‘The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 3’. Root cause of the … Read more
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