DBA NAVIGATOR

  Resolving OPatch Error OUI-67064: OPatchSession Cannot Load Inventory When applying patches using OPatch on Oracle Database or Grid Infrastructure, you may encounter error OUI-67064. This post explains the troubleshooting steps to resolve this common issue. The Error OUI-67064: OPatchSession cannot load inventory for the given Oracle Home /opt/oracle/product/19.3.0/db_1. Possible causes are: - No read or write permission to ORACLE_HOME/.patch_storage - Central Inventory is locked by another OUI instance - No read permission to Central Inventory - The lock file exists in ORACLE_HOME/.patch_storage - The Oracle Home does not exist in Central Inventory This error indicates that OPatch is unable to read or interact with the Oracle Inventory, which is critical for patching operations. Root Cause Analysis After examining the logs and directory structures, a mismatch in ownership within the central inventory directory  /opt/app/oraInventory  was identified. The directory list...

Oracle Real Application Clusters (RAC) provide high availability, scalability, and manageability for databases. One of the most powerful tools for managing RAC databases is srvctl , a command-line utility that allows administrators to control various database services. This blog explores essential srvctl commands to help you efficiently manage Oracle RAC environments. 1. Checking Database Configuration and Status  List all available databases on the host:                  srvctl config database   Check the status of a specific database and its instances:                    srvctl status database -d <database_name>   Retrieve detailed status information about a database, including its instances and states:                    srvctl status database -d <database_name> -v 2. Stopping and Starting Databases   ...