AFTER_PASTEBINARY_COMMENV
Issue: During adcfgclone execution in EBS 12.2, the commenv.sh file was populated with an incorrect JAVA_HOME path after the paste binary step. This caused the clone process to fail with…
Read MoreThe Oracle Migration Challenge – Datatype Conversion Nightmares
When Database Migrations Go Wrong: Snowflake to Oracle Every database migration project starts with optimism: “We’ve mapped the tables, the data looks similar – how hard can it be to…
Read MoreEncrypting SQL Server Database: Transparent Data Encryption (TDE)
Introduction Transparent Data Encryption (TDE) in SQL Server secures sensitive data by encrypting database files at rest without impacting application access, helping organizations protect against unauthorized data exposure. Steps to…
Read MoreRemoving Transparent Data Encryption (TDE) from SQL Server
Introduction Removing Transparent Data Encryption (TDE) from SQL Server involves carefully disabling encryption and cleaning up encryption keys to ensure your database is decrypted and accessible. Steps to remove TDE: …
Read MoreOracle Autonomous Health Framework Fleet Insights Configuration
Introduction: AHFFI is a function that collects data collected by AHF from multiple servers and displays it on a single screen. Why we need to do Observe key issues across your fleet-Dashboards allow for in-depth analysis of the root cause of each issue-If necessary, drill down into specific insight reports to identify detailed. Support Platform: (OEL) x86_64, (RHEL) x86_64, db 19c or later and ahf 24.9 or later system requirements for ahffi : 4 cores CPU, 16GB RAM, 4GB disk space yum install cronie sudo yum install iproute sudo yum install hostname INSTALLATION STEPS: Download ahffi from link 3043060.1 mos Prerequisite setup Install jdk-24 Install instant client sqlplus 23.4.0 Install instant client basic 23.4.0 Create a user for ahffi on 23ai database create user ahffi identified by ahffi; grant create session to ahffi; grant connect, resource to ahffi; grant create table to ahffi; grant insert any table to ahffi; alter user ahffi quota unlimited on users; Download the ahffi file and upload it to the server …
Read MoreInvalid 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 MoreScript 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 MoreQuery 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 MoreChange 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 MoreCloning 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