Rename Pluggable Database
Rename Pluggable Database Introduction: This document is intended for DBA’s who need to know how to change the name of the existing PDB in a multitenant database. Oracle’s multitenant architecture…
Read MoreBackup Oracle Database to Oracle Cloud Infrastructure Object Storage
Backup Oracle Database to Oracle Cloud Infrastructure Object Storage Introduction: Oracle databases benefit from continuous backup, providing organizations with crucial protection during disasters. Implementing a backup strategy is complex and…
Read MoreIntegrated SOA Gateway – A Guide
Integrated SOA Gateway – A Guide Introduction to Integrated SOA Gateway Oracle E-Business Suite Integrated SOA Gateway (ISG) is a complete set of service infrastructure to provide, consume, and…
Read MoreAPPS_DDL package issues in fs_clone
APPS_DDL package issues in fs_clone This blog is intended for DBA’s who have issues in completing fs_clone. We applied a critical patch for one of the client and afterwards executed…
Read MoreAC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.
ERROR: While running adcfgclone faced below error, AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora. [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase…
Read MoreHow to update Workflow Administrator Role in Oracle EBS
How to update Workflow Administrator Role in Oracle Applications 1..update wf_resources set text=’&Enter_Admin_Name’ where name=’WF_ADMIN_ROLE’; e.g update wf_resources set text=’FND_RESP|SYSADMIN|SYSTEM_ADMINISTRATOR|STANDARD’ where name=’WF_ADMIN_ROLE’; 2. Change the value of Context file parameter…
Read MoreORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE
Error: ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE Cause: a database link connected to a database with a different name. The connection is rejected. Solution: I checked the GLOBAL_NAMES. SQL> show…
Read MoreVersion Conflicts among development maintained and customized templates encountered; aborting AutoConfig run.
Error: Version Conflicts among development maintained and customized templates encountered; aborting AutoConfig run. Cause: While running autoconfig we faced below issue, Version Conflicts among development maintained and customized templates encountered;…
Read MoreWhile starting database ORA-03113: end-of-file on communication channel
ERROR While starting database ORA-03113: end-of-file on communication channel Problem: On further diagnosis of ADRCI logs, I found disk space size assigned to Flash recovery area falling short Solution: Mount…
Read MoreJServer JAVA Virtual Machine Component Is in Removing state
ERROR: JServer JAVA Virtual Machine Component Is in Removing state CAUSE: SQL> select comp_name, version, status from dba_registry; COMP_NAME VERSION STATUS —————————————- —————————— ———– Oracle Database Catalog Views 12.1.0.2.0 VALID…
Read More