Database Blog

To generate an email if more than 10 archives are generated in an Hour

SDATE=`date +”%d%b%y %H:%M”`; sqlplus -s ‘/ as sysdba’ @/home/oracle/COOL/archcounthr.sql > /home/oracle/COOL/archcounthr.log; cnt=`cat /home/oracle/COOL/archcounthr.log` if [ $cnt -gt 10 ] then echo “$cnt Archives generated in QTYDB at $SDATE” | mailx…

Read More

Failed to start a managed process after the maximum retry limit

Scenario: ======== We have copied the Ias from different machine and while starting opmn we get the following error: Error : ====== [oracle@doyen ~]$ opmnctl startall opmnctl: starting opmn and…

Read More

The custom manager restarts often by itself

Issue : The custom manager restarts often by itself. Scenario: We have a custom manager XX_Custom_Receiving_mgr which has 3 programs 1. Purchasing     –  Receiving Transaction Processor 2. Ware house   – …

Read More

Active Users concurrent program never completes after clone

Version : 12.1.1 Scenario: ======= Active Users concurrent program never completes after clone: Recently we did a clone (R12). Everything worked as expected, except for Active Users Concurrent program which…

Read More

Error Code 160 With OPatch, Crash In $ORACLE_HOME/jdk/jre/bin/libj9jit23.so (Unhandled Exception )

Error: ====== Error Code 160 With OPatch, Crash In $ORACLE_HOME/jdk/jre/bin/libj9jit23.so (Unhandled Exception ) cskront1(/app/oracle/product/11.1.0/OPatch): ./opatch lsinventory Unhandled exception Type=Segmentation error vmState=0x00000000 J9Generic_Signal_Number=00000004 Signal_Number=0000000b Error_Value=00000000 Signal_Code=00000033 Handler1=09001000A0ABBC78 Handler2=09001000A0AB3538 R0=0000000000000000 R1=0FFFFFFFFFFFB8B0 R2=0000000000000011…

Read More

Error while loading shared libraries: libdb.so.2: cannot open shared object file

Error : ===== Error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory R12.1.1 Installation on Linux 5.4 I was Installing Oracle E-Biz R12.1.1…

Read More

ORA-04062 signature of package APPS.WSH_DELIVERY_DETAILS_INV has been changes

Error message:  =========== APP-WSH-231210 An unexpected Error Occurred for Line .. The Error is ORA-04062 signature of package APPS.WSH_DELIVERY_DETAILS_INV has been changes EBS R12.1.1 DB 11.1.0.7.0 Scenario when the error…

Read More

FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration.

Scenario: After cloning, While launching the forms we get the following error Error : FRM-92101: There was a failure in the Forms Server during startup. This could happen due to…

Read More

Error while loading shared libraries: libdb.so.2: cannot open shared object file

Scenario: While starting Apache after clone we faced the following error. [applmgr@trinity scripts]$ sh adapcctl.sh start You are running adapcctl.sh version 120.7.12010000.2 Starting OPMN managed Oracle HTTP Server (OHS) instance…

Read More

Apps login shows blank page

Problem : R12 AppsLocalLogin shows blank page Check for the following log file cd $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1 vi application.log Go to the end of the file and found the following error Error…

Read More