Apps DBA Workshop

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...

Concurrent programs taking too long to complete and most of the time is spent in Output post processor Apply latest patch : 34091953 This patches creates a file oppjava.sh if you are on instance 12.2.5 or earlier Download 64 bit jre from the internet and place it in a location accessable by applmgr In my case I downloaded and unzipped it in below location /u25/TEST/JREOPP/JRE -bash-4.1$ cd /u25/TEST/JREOPP/JRE/ bin/ lib/ man/ release Welcome.html COPYRIGHT LICENSE README THIRDPARTYLICENSEREADME.txt -bash-4.1$ cd /u25/TEST/JREOPP/JRE/bin/ -bash-4.1$ ./java -version java version "1.8.0_202" Java(TM) SE Runtime Environment (build 1.8.0_202-b08) Java HotSpot(TM) 64-Bit Server VM (build 25.202-b08, mixed mode) -bash-4.1$ Open the oppjava.sh and modify JSERVJAVA parameter to the java location as seen below. JSERVJAVA=/u25/T...