Database Blog

Error Running ADOP prepare – [UNEXPECTED]Error calling runSyncFS subroutine.

Description : When triggering ADOP prepare phase on 12.2.8 environment for patching got below error. Error: PROCEDURE] Calling: /RMAN/apps/JAYAN/R12apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl [EVENT] Log: /RMAN/apps/JAYAN/R12apps/fs_ne/EBSapps/log/adop/11/20230804_092808/prepare/Neptune [UNEXPECTED]Error occurred running “perl /RMAN/apps/JAYAN/R12apps/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/RMAN/apps/JAYAN/R12apps/fs2/i nst/apps/JAYAN_Neptune/appl/admin/JAYAN_Neptune.xml -patchcontextfile=/RMAN/apps/JAYAN/R12apps/fs1/inst/apps/JAYAN_Neptune/appl/admin/JAYAN_Neptune.xml…

Read More

Ebs database Custom table columns missing while running a full mode cleanup

The purpose of this blog is to assist DBAs encountering ebs database custom table column missing while running adpatching cycle. The steps shared here will help to identify the table…

Read More

TxkADOP PreparePhaseSynchronize.pl failure in adop fsclone

This blog is intended for DBA’s who have error while running a fsclone phase run patching cycle error, we have solution for fsclone phase error. Issue: We are facing issue…

Read More

Creating Data Source in WebLogic Server

1. Overview This document talks about how to create a data source for java project using Oracle Web logic server. 2. Technologies and Tools Used The following technologies have been…

Read More

Common Search Using MSSQL Server Stored Procedures

1. Overview This document talks about how to use the search operation for all the reports using MSSQL server Stored Procedure. [Note: Steps included in this document will only works…

Read More

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 More

Using DBMS_SQL.RETURN_RESULT in Oracle PL-SQL and C#

Introduction: In this post, we will explain how to use the DBMS_SQL.RETURN_RESULT procedure in Oracle PL/SQL to return a result set from a stored procedure and then consume that result…

Read More

Diagnosing and Repairing Failures with Data Recovery Advisor

Data Recovery Advisor feature helps in diagnosing and repairing data failures. It will automatically diagnose the issue and provides the recommendation for the repair that helps to resolve the data…

Read More

Changing EBS user password failed with error “APP-FND-01564: ORACLE error 3113”

Changing EBS user password failed with error “APP-FND-01564: ORACLE error 3113” Introduction: Recently while changing password for application user in Oracle EBS version 12.2.6 I faced below issue. Tried multiple…

Read More

Lesser Known yet effective software for DBA’s

Introduction: There are numerous tools on the market that can boost productivity and make our jobs easier. Screen is a full-screen window manager that multiplexes a physical terminal between several…

Read More