Tuesday, May 26, 2020

Simulating ORA-XXXX errors manually in database alert log


Generate ORA-XXX error manually in DB alert log 

login as sysdba


SQL> exec dbms_system.ksdwrt(2,'ORA-00600: This is a test error message for monitoring and can be ignored.');

PL/SQL procedure successfully completed.

SQL>

In Alert_india.log


*************************************************************************
2020-05-26 13:45:21.335000 +00:00
ORA-00600: This is a test error message for monitoring and can be ignored.
2020-05-26 13:45:25.125000 +00:00
ORA-00600: This is a test error message for monitoring and can be ignored.

Tuesday, May 12, 2020

Create ASM diskgroup using ASMCA



Create ASM diskgroup using ASMCA



Login as Grid user or ASM owned user and set environment 



invoke asmcma utility





It will open the GUI window that helps to create diskgroup




after click on create give diskgroup name , redundancy and many more things as per requirement in my case I am creating FRA diskgroup  with external redundancy 








FRA disk group has been created