Database

General:

• Convert Non-CDB database as PDB inside CDB database
• Create Passwordfile inside DiskGroup for RAC database and add to srvctl
• Oracle Database 19c Administration Certification - Most important certificate for DBAs
• Verifying the sys password using TNSNAMES and LISTENER - OS Authentication Vs Password Authentication
• Connecting to CDB & PDB with OS authentication Vs Password Authentication
• PDB Export and Import
• Manual Database Creation Or Silent Mode Database Creation
• How to find the database alert log?
• dbstart & dbshut Automatic startup & Shutdown Databases
• Drop Tablespace Scenarios
• Check or get the Execution plan from SQL ID
• Is flushing shared pool and buffer cache is good?
• SWITCH LOGFILE vs ARCHIVE LOG CURRENT
• Increasing the Redo Log size
• sample listener.ora and tnsnames.ora file for RAC PROD and DR/Standby database
• log archive destination full - What to do?
• error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory
• How to install HR schema?
• Automatic SQL Tuning Adviser
• Database Mode - Restrict Vs Exclusive & Drop database - Standalone Vs RAC
• Oracle Database - Connecting to CDB/PDB with OS Authentication Vs Password Authentication
• Oracle Database Listener Status - READY - UNKNOWN - RESTRICTED - BLOCKED
• How to enable or disable BCT in Oracle Database?
• sqlplus and rman and other binary executable are not working with error while loading shared libraries: libclntshcore.so.12.1: cannot open shared object file: No such file or directory
• DBCA fails with errors: [FATAL] [DBT-50000] Unable to check for available memory
• HR OR PM IX and SH Sample Schemas in Oracle - Create Manually
• EMP DEPT SALGRADE and BONUS - Sample tables in Oracle - Create Manually
• Oracle Home Installation Prerequisite Package Installation
• Oracle Database Memory Structure - AMM Vs ASMM - Memory Tuning
• DROP ASM Instance using asmca or servctl - How to Delete ASM from Clusterware & GI Home Cleanup?
• nid (DBNEWID) - Changing DBID and Changing DBNAME in Oracle
• Cleanup Old GI and DB homes || Deinstall Old GI & DB After GI and DB upgradation
• Drop Database Manually or Drop Database Using dbca and Deinstall/Uninstall Oracle Home
• GUI launch in Linux server for Oracle Installation || XMING GUI setup in Linux Server
• Drop Database Delete Database manual method or GUI method
• How to identify any parameter as static or dynamic?
• orapwd utility or Password File managmenet in Oracle
• archivelog mode and noarchivelog mode in Oracle database and How to convert from noarchivelog mode to archivelog mode
• listener.ora and tnsnames.ora configuration using netca & netmgr
• TOAD Installation on Windows Server
• What is ACL? and How to configure ACL?
• gDBClone Master/GOLD copy and SNAP database creation high level steps
  
  

Interview Questions & Answers

• #DBAchallenge -5 || Questions on corruption, DR sync issues, FRA & RAC – Cache Fusion & Split Brain Syndrome
• #DBAchallenge -4 || Questions on RMAN Backups and Recoveries - Oracle Patching Best Practices
• #DBAchallenge -3 || Interview Questions on RMAN, SGA, PGA, Patching, Password fIle and Query Running Slow
  
  

Patching & Patch Details

• Oct-2021 CPU Clusterware Patching using opatchauto 
• Oracle Home Patching Steps + Post Patching Database (datapatch) Steps - April 2021 CPU/SPU
• How to download Software & Patches from MOS using wget script or direct download
• Jul - 2021 CPU Patching - Standalone Database Patching - 12c & 19c Database Patching
• Jul – 2021 Patch Release Information - Jul 2021 CPU and PAD Documentation
• April – 2021 Patch Release Information and 19c Database Patching Steps
• Oracle Critical Patch Update for January - Jan 2022 CPU and PAD Documentation
  
  

21c Database

• 21c Installation and Database Creation Using dbca - 21.0.0.0
• Oracle Database 21c is available for download on Linux
  
  

19c Database

• 19c CDB and PDM Basic Administration Or Multitenant Database Administration
• 19c GI Home Patching + Database Patching + Database Post Patching (datapatch)
  
  

12c Database

• Install 12.2 Database Binaries or Oracle Home in silent mode
• 12.1.0.2 lsinventory + 12102 lsinventory
• Drop Database Delete Database manual method or GUI method
• Oracle 12.2.0 Client installation on Linux server
• Database Query Performance Issue After Database Upgraded to 12.2.0.1 from 11.2.0.4
  
  

11g Database

• 11.2.0.4 lsinventory + 11204 lsinventory
• Manual Oracle Home Cloning || 11g Release 2 (11.2.0.4)
• Oracle Patching Demo|| PSU Patching || 11g Release 2 (11.2.0.4) - OPatch
• Oracle Home Installation on Oracle Linux || 11g Release 2 (11.2)
• Oracle 11.2.0 Client installation on Windows Server
• 11g Oracle Homes Cloning Made Easy for RAC Database
  
  

Regards,

Mallik