Day: April 6, 2022

Important Parameters in Data Guard

by

DB_NAME On a primary database, specify the name used when the database was created. On a physical standby database, use the DB_NAME of the primary database. DB_UNIQUE_NAME Specify a unique name for each database. This name stays with the database and does not change, even if the primary and standby databases reverse roles. LOG_ARCHIVE_CONFIG The … Read more

Connect To Hung Database In Oracle

by

Oracle hangs only when he is waiting for a resource.  It might be a software resource (a latch or lock), or you could be hung waiting for server resources (CPU, RAM).   There are several ways to find the root cause of an Oracle hanging issue: oradebug – See below for complete steps for diagnosing a … Read more