Introduction This document explains how to configure a normal Oracle Data Guard physical standby in Oracle Database 23ai, where the primary database is a Non-CDB and the standby database is…
Read MoreIntroduction High availability and predictable disaster recovery are critical in any Oracle production environment. While managing Data Guard manually via SQL*Plus is possible, the number of manual steps during incidents…
Read MoreOracle 23ai Auditing: Unified Audit Trail, Features, and Best Practices Why Auditing Matters in Oracle Database 23ai In today’s high-stakes data environment, knowing who accessed your database, what they did,…
Read MoreHow to Check and Create Auditing Policies in Oracle Database 23ai Auditing in Oracle Database 23ai is not just about compliance — it’s about knowing exactly who did what in…
Read MoreIntroduction: In OCI Database Administrator user sys password change using OCI console. Changing the Sys Password: Step 1: Login to a database where you want to change the sys…
Read MoreIntroduction: During the enable of the Database management we need the private endpoint for that operation. In this post, you will see the step to create the private endpoint. Step…
Read MoreIntroduction: Oracle provide a tool called MV2OCI(Move to Oracle Cloud Database) and it is a new tool is permitting the load data and migration from “on premises” to Oracle Cloud…
Read MoreIntroduction: During 11.2.0.4 database upgrade to 19c, Autoupgrade fails with error – NVL(bundle_series,’0′)||’#’|| * ERROR at line 3: ORA-00904: “BUNDLE_SERIES”: invalid identifier ] [ORCL] – ExecuteSql$SQLClient.run NVL(TO_CHAR(action_time, ‘DD-MM-YYYY HH24:MI:SS’),’0′) ||’#’|| NVL(action,’0′)||’#’||…
Read MoreProblem: In the execution of autoconfig in the patch file system. we faced the following error. [SETUP PHASE] AutoConfig could not successfully execute the following scripts: Directory: /u01/apps/fs2/inst/apps/TEST_TESTEBSSYS01/admin/install adgendbc.sh INSTE8_SETUP…
Read MoreProblem: Adcfgclone got complete but at the end it failed for autoconfig with the below error. Error : WARNING: [AutoConfig Error Report] The following report lists errors AutoConfig encountered during…
Read More