Posts by Pushparaj Vijayan

23ai_Unified_Auditing_feature_and_Best_Practices

Oracle 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 More

Creating_Auditing_in_Oracle_Database_23ai

How 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 More

How to change the Database sys password in OCI

Introduction: 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 More

How to Enable the private endpoint for the Database management

Introduction: 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 More

Migrate to Oracle Cloud Database within “1-Click”

Introduction: 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 More

11G to 19c autoupgrade failled with ORA-00904 Error

Introduction: 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 More

Resolving autoconfig issue with patch file system “adgendbc.sh INSTE8_SETUP”

Problem: 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 More

How to reslove “adadmprf.sh INSTE8_PRF”

Problem:  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

ADOP STATUS – FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] Solution.

Problem : [ebsprd@myebstes01 ~]$ adop -status Enter the APPS password: *******FATAL ERROR******* PROGRAM : (/u01/app/ebs/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME : Fri Aug 27 03:42:33 2021 FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ] MESSAGES: SQLPLUS…

Read More

ADOP Status – Error FUNCTION: ADOP::GlobalVars::_ValidateArgs [ Level 1 ] – Solution

ADOP Status – Error FUNCTION: ADOP::GlobalVars::_ValidateArgs [ Level 1 ] – Solution Problem: [ebsprd@myebstes01 ~]$ adop status *******FATAL ERROR******* PROGRAM : (/u01/app/ebs/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME : Fri Aug 27 03:31:33 2021 FUNCTION:…

Read More