DBA Maestro - Helpful DBA tips

Kerberos Authentication to Oracle Database using Active Directory ================================================================= This guide provides step-by-step instructions to configure Kerberos-based authentication using Active Directory for Oracle databases, including all relevant OS, Oracle, and network settings for successful authentication between Windows clients and Oracle Database on Linux. Environment Overview -------------------- Database Server: - OS: Oracle Linux Server release 7.9 - Oracle Version: 19.28.0.0.0 - PDB Name: APPPDB - Hostname: dbserver01.example.com - Keytab Path: $ORACLE_HOME/network/admin/oracle.keytab Active Directory: - Realm: EXAMPLE.COM - AD Domain Controller: dc01.example.com - Oracle AD Service Account: svc_oracle_kerberos Client Workstation: - OS: Windows 11 Enterprise - Kerberos Implementation: MIT Kerberos for Windows - AD Username: dbuser1@EXAMPLE.COM SECTION 1: Active Directory Configuration ----------------------------------------- 1. AD Adm...

  Hey Oracle DBAs! It's been a while, Oracle community! But I'm back with a helpful post. :-) Today, I faced an issue while performing an RMAN duplicate to build out a standby database (Oracle version 19.25) on an ExaCS VM. The database is 110 TB in size. I was doing an active duplicate over the WAN for 2 days. Everything was going smoothly until it reached ~94% completion... and then it FAILED!! I didn't want to risk restarting the entire RMAN duplicate process again out of concern that the same issue would occur. Here's my error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 04/10/2025 09:57:48 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-19875: multisection restore or copy not complete ...