Steps to Recover Apps Password in EBS R12

Here we will discuss about useful Steps to recover APPS password in EBS R12. Suppose someone forgot to remember the APPS and SYSADMIN password, just follow the below steps to recover the same password. To recover APPS password:-  create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,in_chr_encrypted_pin IN VARCHAR2) RETURN VARCHAR2 AS LANGUAGE JAVA NAME ‘oracle.apps.fnd.security.WebSessionMa nagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’;/ … Read more

R12 Autoconfig failed on jtfictx.sh INSTE8_PRF 1 – ORA-29874

Introduction: – In this post we will know how to resolve R12 Autoconfig failed on jtfictx.sh INSTE8_PRF 1 – ORA-29874: warning in the execution of ODCIINDEXALTER routine. How to R12 Autoconfig failed on jtfictx.sh INSTE8_PRF 1?   During EBS clone I faced the following error while try to run adcfgclone.pl on appsTier then autoconfig failed … Read more

ORA-ERROR which every DBA facing

ORA- 12514,ORA-12537,ORA-00600/ORA-07445,  ORA-12154     ORA- 12514: TNS:listener does not currently know of service requested in connect descriptor.          Cause: – The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) … Read more

ORA Error ! Oracle database symptoms (ORA Error)

In this post we will fix ORA Error in oracle database. Oracle database symptoms ORA Error :-            1. Symptoms   Memory heap error ORA-7445[kssrem] and ORA-7445[kggchk] is reported in the alert.log and PMON terminates.   ORA-07445: exception encountered: core dump [kssrem()+176] [SIGSEGV] [Address not mapped to object] [0x000000008] [] [] ORA-07445: … Read more

ORA 1691 unable to extend lobsegment APPLSYS.SYS_LOB in tablespace APPLSYSD

Recently I have faced and resolved the ora 1691 unable to extend lobsegment APPLSYS.SYS_LOB in tablespace APPLSYSD in our production environment. How to fix ora 1691 unable to extend lobsegment. Error: ORA-1691: unable to extend lobsegment APPLSYS.SYS_LOB0000255030C00040$$ by 1574805 in tablespace APPLSYSD Analysis and Solution: Step1: Verify Free space in tablespace & Check data file … Read more

Resolving Shutdown Immediate Hang Situations 11g,12c,18c & 19c

Resolving Shutdown Immediate Hang Situations | Sometimes we are facing the situation were shutting down the instance with shutdown immediate seems to take infinite time and database look like that the session is hung. In most of the cases this is not a hang. Hang can be defined as a scenario when few sessions/processes are … Read more

Steps to recover Applications context file if it is corrupted or deleted.

Here is ‘steps to recover Applications context file if it is corrupted or deleted’. If the Oracle Applications Context file is corrupted or deleted, then we need to follow the below steps to recover the Context file as well. To retrieve/recover Applications context file. Run the adclonectx.pl as shown below. perl /clone/bin/adclonectx.pl retrieve On being prompted … Read more

How to configure Isupplier on External node in R12

Introduction:- In this post we will discuss how to configure Isupplier on external node on shared file system. Steps to Add Node to a Shared Application Tier File System for Oracle E-Business Suite R12 Configuration in a DMZ: Here we will know ‘how to configure isupplier (dmz) in oracle apps in r12‘. Internal Server:- 192.168.11.15 External Server:- 192.168.11.10 … Read more