Monthly Archives: September 2020

Determine the version of Berkeley Database in Oracle Unified Directory

Introduction: In this article we will see how to determine the version of Berkeley Database in Oracle Unified Directory (OUD). Ways to determine the version: There are 3 known ways…

Read More

Remote Connections Via the Listener to the Database Fail with TNS-12526, TNS-12527 or TNS-12528

Introduction: Connections via the listener to an instance that is in RESTRICTED status or in NO MOUNT status may fail with TNS-12526, TNS-12527 or TNS-12528 even when supplying the credentials…

Read More

Disabling Language Selection Option In AppsLocalLogin.jsp

Introduction: The below post discusses about disabling language selection option available in AppsLocalLogin.jsp. Method to disable the language selection: Check the version of file AppsLocalLogin.jsp which is under $OA_HTML This…

Read More

Glimpse of External Tables in Oracle Database

  Introduction: In this article, we can see what External Tables are and how to manage those tables within the Oracle Database. About External Tables: External tables are defined as tables…

Read More

Adcfgclone failing with Error: AFTER PASTEBINARY COMMENV.SH FILE IS POPULATED WITH INCORRECT JAVA_HOME PATH in EBS 12.2

Adcfgclone failing with Error: AFTER PASTE BINARY COMMENV.SH FILE IS POPULATED WITH INCORRECT JAVA_HOME PATH in EBS 12.2 Oracle Support notes: ===================== 12.2 E-Business Suite Applications Manager Rapidclone Fails With…

Read More

Steps to Implement Transparent Data Encryption(TDE) using fast offline conversion for Oracle Databases

Prerequisite: Make sure you have applied the patch 23315889(fast offline conversion patch) if you are on Oracle 11g Database or latest CPU patches are applied which already include all the…

Read More

DBCA Configure Database option is greyed out in Oracle

Database Configuration Assistant was not showing the database and Configure Database Options and it was greyed out(disabled). We tried setting up ORACLE_SID and ORACLE_HOME and ran dbca but it was…

Read More

Gather Schema Statistics – Program error with Locks and Duplicate columns

Oracle E-Business Suite Release 12 uses cost–based optimization in order to choose the most efficient execution plan for SQL statements.Gather Schema Statistics is the favourite one among Apps DBA’s and…

Read More

How to open Concurrent Out file in excel format

An *.out file is a compiled executable file created by various source code compilers in Unix-like operating systems, such as Linux and AIX. *.out files are most commonly seen as…

Read More

No Write Permission on ACFS Mount Point

I managed to create the ACFS Mount Point after resolving the issue “ACFS-9459: ASVM/ACFS is not supported on this os version”. But, after creating the ACFS Mount Point, I’m unable…

Read More