Database Blog

OCI DBCS: RESTORE the DB from backup, OPEN command fails, wallet status is found to be CLOSED,

Issue :  OCI DBCS: RESTORE the DB from backup, OPEN command fails, wallet status is found to be CLOSED, Observation :  – Took a complete database backup – Used the…

Read More

OCI Restore fails during Recreate Controlfile step while adding tempfile to PDB

Issue : OCI Restore fails during Recreate Controlfile step while adding tempfile to PDB SYMPTOMS : Create new DB System from backup fails during Recreate Controlfile script execution.   Reason :…

Read More

OCI Restore failure during Tempfile Creation

Issue : OCI Restore failure during Tempfile Creation Trying to create a new DB System from backup in OCI. Restore fails during “Re-Create Control File” step:   Cause for the issue…

Read More

Got the error : ORA-20401: Authorization failed, while listing contents of OCI Object storage using PL/SQL in ADB

Issue : Got the error : ORA-20401: Authorization failed, while listing contents of OCI Object storage using PL/SQL in ADB Error : ERROR at line 1: ORA-20401: Authorization failed for…

Read More

Cannot Install Oracle Database Home / oracle.apps.fnd.txk.config.ProcessStateException: OUI process failed : Exit=255

APPLIES TO: Oracle Applications Manager – Version 12.2 to 12.2 [Release 12.2Cloud] Information in this document applies to any platform. SYMPTOMS: Trying to install 12.2 E-Business Suite on Linux and…

Read More

Rapid Install fails at second node: RW-20004: No Installs found for this host

APPLIES TO: Oracle Applications Manager – Version 12.0 to 12.0.4 [Release 12] Information in this document applies to any platform. This problem can occur on any platform. SYMPTOMS: Error running…

Read More

Synchronization of AD tables FND_NODES, ADOP_VALID_NODES and FND_OAM_CONTEXT_FILES in 12.2 when adop fails

Issue : Autoconfig was failing in EBS R12.2 during cloning Error Faced : Directory: <EBS_BASE>/fs#/FMW_Home/webtier/perl/bin/perl -I <EBS_BASE>/fs#/FMW_Home/webtier/perl/lib/5.10.0 -I <EBS_BASE>/fs#/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I <EBS_BASE>/fs#/EBSapps/appl/au/12.0.0/perl -I <EBS_BASE>/fs#/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /<EBS_BASE>/fs#/inst/apps/<SID_hostname>/admin/install txkGenADOPWrapper.pl INSTE8_APPLY 1 SQL> SQL> Connected.…

Read More

Script To Check The Techstack Component Versions in Unix/Linux Environment

Introduction: In this article, we will find the versions of Technology stack components like Forms, iAS, Framework, JDK, OJSP, Database, etc On Application Tier in Linux: Establish the needed environment…

Read More

User Notification Preference Updated to DISABLED in Workflow

Introduction: User’s notification preferences are being disabled in WF_LOCAL_ROLES table and the administrator is receiving email notification such as following: To SYSADMIN Sent 10-Nov-2011 14:25:32 ID 5208 What happens and…

Read More

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