Wednesday, November 27, 2024

Automatic failback of an Orace RAC database Service - 19c new feature

When a rac database instance fails, a service which is running on this failed instance (configured as preferred) will fail over to the available instance to continue application connectivity. Wheh the failed instance restarted again, Unfortunately, the service did not fail back to the original (preferred) instance as soon as the instance is up. So a DBA need to relocate the service again. This has changed with Oracle RAC Database 19c with a feature called "failback -yes" option. 

Monday, November 25, 2024

Oracle's Autonomous Health Framework

AHF (Oracle Support Doc ID 2550798.1) is Oracle's current diagnostic tool which includes Orachk and TFA (Trace File Analyzer).

Thursday, November 21, 2024

How to see EXADATA machine information on OCI GEN-2 Cloud (EXACC / EXACS)?

To see EXADATA machine information of OCI cloud, follow below method. 1) Log in to EXACS/EXACC compute (db server) node with ROOT user. 2) Navigate to below location. cd /opt/oracle.SupportTools/onecommand 3) fire below command cat em.param | grep machinemodel

Bryan's Oracle Blog: Automating cloning of your Exadata Database Servic...

Bryan's Oracle Blog: Automating cloning of your Exadata Database Servic... : One of the questions I often get from customers is  ...