We already know the general practice to apply application patches to R12.2 through online patching Adop(Ad online patching utility) explained R12.2 R12.2 Online patching cycle Summary Let’s explore the steps on how to apply database patches , weblogic patches , 10.1.2 patches , web-tier patches to the R12.2 tech stack. We can apply the same …
How to apply the technology patches to EBS R12.2 Read More »
Sometimes Oracle components may start giving strange issues like coredump or the Operating system is patched, In these cases it is always recommended to try oracle relink to resolve the issues.A Oracle relink is also necessary whenever you install a new release or a patchset or when there is a patch or upgrade to the OS …
Relink Oracle: All, Sqlplus, Oracle ,forms, lsnrctl Read More »
This is part of Oracle SQL tutorial and has good examples, explanation on single row functions in Oracle Sql Functions are programs that take zero or more arguments and return a single value. Functions can be single row ,multiple row functions We will be discussing here Single row functions in SQL What is single row …
FNDCPASS FNDCPASS is an important utility in the Oracle EBS application and it is located in $FND_TOP/bin. It is used to change passwords for apps schema, oracle EBS schema password, and application user password change. $FNDCPASS FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS FNDCPASS apps/apps 0 Y system/manager ORACLE FNDCPASS apps/apps 0 Y system/manager USER …
What is vi editor vi editor is a visual text editor in Unix. It is pronounced as V and I editor. Here we would be learning how to use the vi editor, how to exit vi editors. vi shows you part of your file and allows you to enter commands that change something (add new …
Many times Oracle database get hangs due to locks or latching issue and Nobody can login to the system. It becomes critical and And Usually we do shutdown abort to immediately resolve the issue. But it is good to take system state dump/hanganalyze at 1 min interval to analyze the locking or latching issue afterwards …
Hanganalyze ,system state dump,v$wait_chains in Oracle Read More »
