Monthly Archives: August 2025

 Invalid APPS Database User Credentials in txkPostPDBCreationTasks After PDB Creation in Oracle EBS 12.2

Introduction: When performing a Post-PDB Creation Task in Oracle EBS 12.2, you may encounter the following error while running the txkPostPDBCreationTasks.pl script: FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ] ERRORMSG: Invalid…

Read More

Script to enable Unified Auditing at Db level

Please find the below steps to enable the same.   create audit policy audit_all actions all only toplevel; audit policy audit_all by user1,user2,user3; audit policy audit_all by sys,system; CONNECT /…

Read More

Query to check identity columns in a table and enable/disable options.

Please run the below query to get the output. SELECT owner, table_name, column_name, generation_type, identity_options FROM dba_tab_identity_cols ORDER BY owner, table_name;   Generation type is below. GENERATED ALWAYS AS IDENTITY…

Read More

Change MAX_STRING_SIZE in an Oracle 19c Physical Standby Environment

In Oracle Database 19c, the MAX_STRING_SIZE parameter controls the maximum length for VARCHAR2, NVARCHAR2, and RAW columns. By default, it’s set to STANDARD, which limits columns to 4,000 bytes. Setting…

Read More

Cloning a Pluggable Database in Oracle

Within Oracle’s multitenant architecture, cloning a PDB allows you to build a duplicate environment—perfect for testing, patching, or sandboxing—without touching the production system. 1. Setting the Stage: Preparing Your Environment…

Read More

Enhancing Cloud Security with OCI Cloud Guard’s New Threat Recipes

Introduction Oracle Cloud Infrastructure (OCI) introduced new Cloud Guard threat detector recipes to help organizations better identify and respond to evolving cloud security risks. While many enterprises already use Cloud…

Read More

Secure SFTP Setup for Application File Exchange

Introduction There was a requirement to securely exchange application files (such as configuration files, logs, or deployment packages) between internal users and a restricted server location, without giving shell access…

Read More

TO DOWNLOAD THE SOFTWARE IN OEM CONSOLE IN OFFLINE MODE

1.Click on agent software once the connection mode set to offline. 2. Click on agent software.  3.Click on appropriate software that you need to download 4.Click download option  5.Click on check…

Read More

Jaspersoft Installation on Ubuntu – A Step-by-Step Guide

Introduction:  This blog provides a step-by-step guide to install Jaspersoft Community Edition on an Ubuntu machine. Jaspersoft is a widely used business intelligence tool that allows users to create, view,…

Read More

Migrating ORDS 24.1 from Standalone to Tomcat Deployment

Introduction  This blog explains how to convert a standalone ORDS 24.1 deployment (using the embedded Jetty server) to a Tomcat 9-based deployment. Deploying ORDS on Tomcat improves scalability, resource management,…

Read More