RAM&KRISHNA BLOG

     Common Issues and Solutions for Oracle 19c Grid Infrastructure Installation •       Check Log Files for Details Oracle installation issues often provide valuable clues in the log files. If the installer seems stuck or fails, check the following logs: ▪ Install log : /u01/app/oraInventory/logs/installActions<date>.log •       ▪ Grid Infrastructure log : $ORACLE_BASE/cfgtoollogs/ •         •       These logs can provide error messages and help identify the exact issue. •         •        Check Permissions and Ownership Verify that the Oracle Grid Infrastructure installation directories have the correct ownership and permissions. •        For example: •        Make sure the grid user has permission to write to the directories where the i...

    RESTORE AND RECOVERING A DROPPED DATAFILE IN PDB:   SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 31 12:27:21 2024 Version 19.3.0.0.0   Copyright (c) 1982, 2019, Oracle.  All rights reserved.   Enter user-name: / as sysdba   Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0   SQL> show pdbs;       CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 ORCLPDB           ...

  WHAT IS SCAN CLUSTERWARE AND BENEFITS OF SCAN? SCAN stands for Single Client Access Name . It's simplifies client connectivity.   Single Entry Point: SCAN provides a single, consistent name for clients to access any database instance within the RAC cluster. Now clients only need to know the SCAN name, eliminating the need to manage multiple connection strings.   srvctl set scan -scanname myrac-scan.example.com   to list the contents of the scan.properties file, you can use the following command: crsctl list scan How SCAN Listener Knows the Least-Loaded Node Local Listener Communication: Each node in the RAC cluster has its own local listener that keeps track of the load on its node, including session count, CPU usage, memory usage, and other factors. The local listeners regularly communicate with the Global Resource Directory (GRD) in the Oracle Clusterware to update load-related information. Each local listener adve...