Monthly Archives: October 2024

Issue faced: Sudden Power shutdown of EBS 12.2 Application Server / Machine cd $ADMIN_SCRIPTS_HOME./adapcctl.sh status Noticed that the http service shows STOP SOLUTION: cd /u01/ebiz_APRIL_2018/fs1/FMW_Home/webtier/instances/web_GEAPROD_OHS1/config/OPMN/opmn/states ls -lrta -rw-r—–. 1 applprod dba 14 Oct 26 10:58 .locale-rw-r—–. 1 applprod dba 579 … Continue reading →

Symptoms/Problem Details : Unable to connect apps user from a Recently cloned and EBS RUP 12.2.12 applied Application nodesqlplus apps/*****ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.[oracle@clone admin]$ sqlplus apps/****SQL*Plus: Release 10.1.0.5.0 – Production on Mon … Continue reading →

ISSUE: In this Blog we are going to learn about How To Find a Particular Database Session ID From the SQLID.One of my customer informed me I have query running since 10 hours and Healready confirmed with Business user that … Continue reading →