Apps DBA Workshop

In one of our csutomer Environment during the Oracle E-Business suite siwtchover activity we encounted the following error during exeuction of autoconfig. adcvmlog.xml renamed to /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/PROD_ERPAPPSdr01/06081214/adcvmlog.xml.06081215 [CVM Error Report] The following report lists errors encountered during CVM Phase /u01/oracle/PRODDR/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.sh 1 No of scripts failed in CVM phase: 1 AutoConfig is exiting with status 1 AutoConfig execution completed on Sat Jun 8 12:15:08 2024 Time taken for AutoConfig execution to complete : 0 mins 23 secs Cause: UTL_FILE_DIR is obselete with Database 19c and hence autoconfig is not able to set/locate the correct utl_file_dir Solution: Need to set utl_file_directory as per the new tech stack tools and once the locations are set to valid directories autoconfig will be completed successfully. Script "txkCfgUtlfileDir.pl" will be used with thr...

 The following Error was encountered when we tried starting up the database manually:   SQL> startup ORACLE instance started.   Total System Global Area 4.8694E+11 bytes Fixed Size                 37521640 bytes Variable Size            5.5298E+10 bytes Database Buffers         4.3111E+11 bytes Redo Buffers              499347456 bytes Database mounted. Database opened.         " was non-numeric Usage: { EXIT | QUIT }e [ SUCCESS | FAILURE | WARNING | n |        <variable> | :<bindvariable> ]  [ COMMIT | ROLLBACK ] Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0...

This blogpost will provide you detailed information about Oracle Audit Vault and Database Firewall (Oracle AVDF) setup. Oracle AVDF is a comprehensive Database Activity Monitoring (DAM) solution that integrates with native audit data. Environment Setup: [oracrp@ebs-dev2-db01 ~]$ mkdir -pv /oradb/oracle/avcli mkdir: created directory ‘/oradb/oracle/avcli’ [oracrp@ebs-dev2-db01 ~]$ mkdir -pv /oradb/oracle/avagent mkdir: created directory ‘/oradb/oracle/avagent’ [oracrp@ebs-dev2-db01 ~]$ - Add these variables to the environment file vi DEV2CDB.env # AVS export AVCLI_HOME="/oradb/oracle/avcli" export AV_HOME="/oradb/oracle/avagent" export PATH="$PATH:$AV_HOME/bin" Download the JAR files:   AVDF installation requires one network interface card on respective hosts. IP assigned to AV server NIC will communicate with target databases and IP assigned to DF server will connect to AV Download - Agent jar file:   Login to AV console as avadmin user   - Go t...

We were working on 8 node Extended RAC setup and based on request from customer we need to scale up the existing ASM disk group and when we tried adding the disk to the disk group we encountered the following error SQL> alter diskgroup data add disk '/dev/mapper/CL1_SITEA_D007' force; alter diskgroup data add disk '/dev/mapper/CL1_SITEA_D007' force * ERROR at line 1: ORA-00600: internal error code, arguments: [kfgSiteNumPopulate02], [], [], [], [], [], [], [], [], [], [], [] Error From ASM Alert logfile: Dumping diagnostic data in directory=[cdmp_20230424121633], requested by (instance=1, osid=397487), summary=[incident=68188]. 2023-04-24T12:16:33.770798+03:00 NOTE: Attempting voting file refresh on diskgroup DATA NOTE: Refresh completed on diskgroup DATA. No voting file found. 2023-04-24T12:16:36.289397+03:00 ORA-00600: internal error code, arguments: [kfgSiteNumPopulate02], [], [], [], [], [], [], [], [], [], [], [] 2023-04-24T12:16:36.289445+03:00 ERROR: al...

The following post will provide the list of steps that needs to be performed while performing a manual switchover to DR database when Data guard is configured between these database. These commands are helpful if we are not using broker for switchover operations: Primary DB -  ERPDB Standby DB  DERPDB*   STEP1:(ERPDB) srvctl status database -d ERPDB srvctl stop instance  -d ERPDB  -i ERPDB2 -o immediate srvctl status database -d ERPDB STEP2: (DERPDB) srvctl status database -d DERPDB srvctl stop instance  -d DERPDB  -i DERPDB1 -o immediate srvctl status database -d DERPDB STEP3:(ERPDB) SELECT  NAME,DB_UNIQUE_NAME,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE; STEP4:(DERPDB) SELECT  NAME,DB_UNIQUE_NAME,DATABASE_ROLE,SWITCHOVER_STATUS FROM V$DATABASE; STEP5:(ERPDB) - Convert ERPDB to Physical standby database ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN; SHUTDOWN IMMEDI...