Yearly Archives: 2021

Log file locations in oracle EBS 12.1.3 and 12.2.4

Log file locations in oracle EBS 12.1.3 and 12.2.4 The Log files locations in Oracle EBS Release 12.1.3 and Oracle EBS R 12.2.4 are given below: 1.Instance startup and configuration…

Read More

R12.2 ONLINE PATCHING (ADOP) PARAMETERS/COMMANDS

R12.2 ONLINE PATCHING (ADOP) PARAMETERS/COMMANDS Online patching is the most important new feature in Oracle E-Business Suite Release 12.2. It is the ability to patch a running system without having…

Read More

Difference between Oracle EBS R12.1.3 and Oracle EBS R12.2.4

We have recently upgraded Oracle EBS 12.1.3 to Oracle EBS R12.2.4. There are lot of differences. 1)In R12.2 we have to kind of filesystems fs1(run filesystem) and fs2(patch filesystem) where…

Read More

ORA-29702: error occurred in Cluster Group Service operation

While trying to login in oracle database, after that ORA-29702 error coming. $sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 10 10:29:23 2021 Copyright (c) 1982, 2013,…

Read More

adop prepare phase failing with the error ![UNEXPECTED]Nodes are listed in the ADOP_VALID_NODES table but not in the FND_NODES table.

[applmgr@Doyen ~]$ adop phase=prepare Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing. Run Edition context : /oracle/EBSFS/fs1/inst/apps/TEST_Sunapps/appl/admin/TEST_Sunapps.xml Patch edition context: /oracle/EBSFS/fs2/inst/apps/TEST_Sunapps/appl/admin/TEST_Sunapps.xml Patch file…

Read More

Apex find Error, Session Monitor, Performance Monitor and Trace

In this, Developer can monitor the performance of the Application, session and other Apex page issue error. This is very helpful from developer side . to-find-the-error-in-apex-and-sessiontrace-in-apex

Read More

DBA_HIST_SEG_STAT become invalid

Unpublished Base Bug 3603160 has been fixed in the patchset 10.2.0.3.0 For version 10.1.0.4 and version 10.1.0.5 oneoff patches exists for some platforms. Below is a list of available onoff…

Read More

Install oracle client via yum

CMD for Installation.   yum -y -q install oracle-instantclient18.3-basic.x86_64.

Read More

ORA-00000: normal, successful completion

check correct hostname and ip on /etc/hosts fie or check environment variables.

Read More

expdp throwing ORA-04031 (stream pool) error

increase the memory_max_size to resolve.

Read More