oracle

Upgrading Oracle database from 12.1.0.2 to 19.20 using AutoUpgrade tool

This blog aims to support DBAs upgrading databases from 12.1.0.2 to 19.20 using the new AutoUpgrade tool. Oracle Database AutoUpgrade is the supported and recommended method for upgrading Oracle database.…

Read More

Deploying plugin on OEM

                              Deploying plugin on Oracle Enterprise Manager (OEM 13c) Introduction Greetings! This blog is all about deploying Oracle E-business suite (EBS) plugins on OEM and is your go-to guide for…

Read More

New Features of Oracle Database 23c

Oracle Database 23c, Oracle Corporation’s most recent release, includes a slew of new features and changes designed to provide organizations with expanded capabilities and improved performance. Overview: Enhanced machine learning…

Read More

Viewing alert log for Amazon RDS for Oracle

This blog is intended for Oracle DBA’s administering Amazon RDS for Oracle. Issue: Oracle DBAs may need to view alertlog for the database, for troubleshooting issues and looking out for…

Read More

Online reorganization of a table using Oracle DBMS_REDEFINITION package

This blog is intended for DBA’s who would like to reorganize tables online using Oracle dbms_redefinition package. Issue: DBAs may need to reorganize tables to improve the SQL query performance…

Read More

Voice Recording in ORACLE APEX

Overview This overview outlines the steps to implement voice recording in Oracle APEX applications, including capturing audio from the user’s microphone, storing it in the database using Oracle APEX and…

Read More

Push Notifications in ORACLE APEX

Overview Progressive Web Apps (PWAs) are web applications that utilize modern web technologies to deliver an app-like experience to users. PWAs are installable, work offline, and have other features that…

Read More

TXK Delta 13 failed due to missing files

TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed twice, once when looking for…

Read More

Adop Phase=cutover Failing With AutoPatch – AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found

AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome this issue Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG…

Read More

OEM 13.4 Step by Step Installation

OEM 13.4 INSTALLATION AND CONFIGURATION   OEM OVERVIEW: Oracle Enterprise Manager is management tool, which is used to integrated solution for managing your heterogeneous environment. It Includes, Graphical console, Agents,…

Read More