Scripts to start the Dataguard Standby Server after Windows system reboot occurred. Problem: When the window reboot occurred, the DR site of the data guard environment did not come up …
Category:
Oracle
-
-
Error: ORA-27041: unable to open file Cause:Unable to start the database after adding new disk in diskgroup. Solution: 1. Check the permission of the disks.Note: Need permission at OS level …
-
DataguardOracleRac
Copy password file from primary to standby in RAC Environment
by tuanlpby tuanlpCopy password file from primary to standby in RAC Environment Errors:–PRODDB – Primary databaseError: ORA-16810: multiple errors or warnings detected for the database –DRDB – Physical standby databaseError: ORA-01017: …
-
Understand the terminology involved in Buffer Cache Buffer CacheOracle having copies of database blocks for frequent access instead of fetching from disks known as buffer cache in SGA area. It’s …
-
Check database is Administrative and policy managed in RAC Administrative: DBA manages each instance of the database by defining specific instances to run on specific nodes in the cluster.Policy: DBA …
-
Check session in waiting and how much time from its waiting COLUMN event FORMAT A30COLUMN wait_class FORMAT A15COLUMN sid format 9999select sid, seq#, EVENT, WAIT_CLASS, SECONDS_IN_WAIT from v$session_wait ORDER BY …
-
Hard Parses If session execute the SQL statement that not present in the shared pool then Oracle need following steps to placed in memory:1. Allocate memory for the statement from …
-
-
-