Online DBA

  <<Back to Oracle ASM Main Page ASMCMD-9521: AFD is already configured while labeling the disk #export ORACLE_HOME=/u01/app/product/19c/grid #export ORACLE_BASE=/u01/app # $ORACLE_HOME/bin/asmcmd afd_label FRA_01_RAC_001  /dev/dm-10 --init   ASMCMD-9521: AFD is already configured After checking the disk status I found the disk is available to lable #$ORACLE_HOME/bin/asmcmd afd_lslbl /dev/dm-10 No devices to be scanned. The Permission is also fine # ls -lrt /dev/dm-10  lrwxrwxrwx 1 root root 8 Sep 28 10:19 /dev/dm-10  Lets read the header of this disk # $ORACLE_HOME/bin/kfed read /dev/dm-10  kfbh.endian:                          0 ; 0x000: 0x00 kfbh.hard:                            0 ; 0x001: 0x00 kfbh.type:                            0 ; 0x002: KFBT...

  <<Back to DB Administration Main Page  Scheduler Jobs not Running Post DB Patching on Windows  After Database patching it was identified that the scheduled jobs using oracle job scheduler was not running any more Tried to run the job manually was successful  SQL>exec dbms_scheduler.run_job('<JOBNAME>') After some troubleshooting come across that the following tables/view were missing  sys.scheduler$_job_refresh sys.scheduler$_lwjob_refresh sys.scheduler$_window_refresh Solution executing below script created the missing tables which fixed the scheduler issue and all jobs running again SQL>@?/rdbms/admin/catschv.sql