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 MoreWithin 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 MoreManaging large datasets efficiently is a key challenge for database administrators (DBAs). One solution to this problem is table partitioning, a feature in Oracle databases that allows large tables to…
Read MoreIn Oracle E-Business Suite (EBS) environments, it’s a good practice to occasionally analyze the largest database objects to identify potential inefficiencies. Recently, I discovered that the FND_LOG_MESSAGES table in my…
Read MoreExploring the New Features in Oracle 23c: What You Need to Know Oracle’s latest release, Oracle 23c, brings a suite of new features and enhancements designed to improve database management,…
Read MoreIntroduction In today’s fast-paced digital landscape, maintaining the health and performance of your Oracle databases is critical. The Oracle Autonomous Health Framework (AHF) is your go-to suite of tools for…
Read MoreIntroduction: Upgrading from Oracle E-Business Suite 11i to R12 or transitioning between 12.x versions is a crucial step for organizations seeking enhanced functionality and improved performance. As part of this…
Read MoreDuring Cutover phase while Patching , ADOP failed with below error stating unable to start the application. Please find the root cause and its related solution below Error : …
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 More