Yearly Archives: 2020

RoCE in Exadata X8M

Oracle Exadata Database Machine X8M is on the way! Building on the Exadata X8 state-of-the-art hardware and software, the Exadata X8M family adopts two new cutting-edge technologies: RDMA over Converged…

Read More

Exadata Cell software components

In this article, let us go through the Exadata Storage Cell Processes (MS, RS and Cellsrv). There are three main Exadata Storage Cell Processes: Cell Services (cellsrv) Cell Services (cellsrv)…

Read More

Unlink a FND_USER user account that is linked to an SSO Account

Unlink a FND_USER user account in Oracle EBusiness Suite that is linked to an SSO Account as follows, $ cd $FND_TOP/patch/115/sql/ $ ls -ltr fndssouu.sql $ sqlplus apps/apps_password @fndssouu.sql ROCHERK

Read More

Add node in R12.2

Steps to add second node to an Application Tier in R12.2. 1. Start the admin server in the run file system of the applications first node and execute txkManageDBConnectionPool.pl script…

Read More

adcfgclone failed with no linkxlc error

adcfgclone.pl failed in the application tier with no linkxlc error as follows, no linkxlC in BASE_PATH/apps/apps_st/comn/clone/bin/../jre/bin /usr/bin /etc /usr/sbin /usr/ucb /home/oracle/bin /usr/bin/X11 /sbin . Solution: Check if linkxlC  is installed…

Read More

Oracle ORA-21561 : OID generation failed

Solution: Then the problem is most likely in the machine hosts file. Check that there is machine full name and short name in the machine hosts file. If these are…

Read More

Cost Manager Concurrent request failed

Cost Manager concurrent request failed with the following errors, APP-FND-01564: ORACLE error 60 in cmlacm() Cause: cmlacm() failed due to ORA-00060: deadlock detected while waiting for resource Solution: – Adding…

Read More

Control Purchasing Period (India Local Purchasing)form was not opening.

In EBS R12.1.3 the “Control Purchasing Period” was not opening for users and the following error was noticed, oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.jbo.InvalidObjAccessException: JBO-25036: An…

Read More

Database spending most of the time in wait event “log file switch (checkpoint incomplete) Waits event”

The wait event “logfile switch checkpoint incomplete” indicates that Oracle needs to reuse a redo log file, but the current checkpoint position is still in that log. In this scenario,…

Read More

Users unable to query in SQL Developer

A user was unable to query data from tables in sql developer, the query worked fine in sqlplus and toad. Upon checking the NLS settings were different in the SQL…

Read More