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 installation is happening. • Ensure that your server has sufficient swap space and disk space . Oracle can sometimes fail silently if these requirements are not met. • Check the swap space with: • Check disk space wi
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 READ WRITE NO SQL> alter session set container=ORCLPDB; Session altered. SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 ORCLPDB READ WRITE NO SQL> select file_name from dba_data_files; FILE_NAME -----------------------------------------------------