Purpose: Usually a Privilege can be treated as unused privilege if this is not being used by user or pre-running programs at database level. During new application development phase or…
Read MoreLogin to AWS Management Console Then Navigate to EC2 Click Launch Instance Choose an AMI Choose Instance Type Configure Security Group Launch the instance Create…
Read MoreDescription : 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 MoreThe 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 MoreThis 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 More1. 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 More1. 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 MoreRename 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 MoreIntroduction: 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 MoreData 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