People and Culture Blog

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

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

Query to find ASM Error details.

Description: This script is used for finding ASM error details on ASM disk. script: select io.inst_id , dg.name diskgroup_name , io.disk_number , d.name disk_name –, d.label , d.read_errs , d.write_errs…

Read More

query to find top sort segment usage.

Description: This query belongs to find the top sort segment usage on oracle. Script: col sid format 999999 col spid format a6 col tablespace format a10 col username format a25…

Read More

Diagnostic test to validate the WORKFLOW NOTIFICATION MAILER – Java Mailer Setup

This diagnostic test will validate the WORKFLOW NOTIFICATION MAILER – Java Mailer Setup and do an initial data collection of frequently requested information. 1) Enable STATEMENT Level Logging for the…

Read More