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
Subscribe to:
Posts (Atom)
Minimalistic Oracle: A SQL-centric and a session-centric way to query V...
Minimalistic Oracle: A SQL-centric and a session-centric way to query V... : Version 1: SQL-Centric This version starts from V$SQL and...
-
When a rac database instance fails, a service which is running on this failed instance (configured as preferred) will fail over to the avail...
-
Minimalistic Oracle: How to detach an ORACLE_HOME to an existing inventory : I want to detach an existing oracle_home from my inventory. No...
-
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)...
