Month: September 2026

  • Troubleshooting RMAN ORA-01403 When Allocating an SBT_TAPE Channel

    Troubleshooting RMAN ORA-01403 When Allocating an SBT_TAPE Channel

    The RMAN backup error originated after upgrading an Oracle Database from version 19.26 to 19.32 while using Veritas NetBackup. The issue was identified as a version incompatibility between the RMAN recovery catalog (19.6) and the database environment. Testing showed that the backup worked without the recovery catalog, indicating that the catalog was the stumbling block. Upgrading the catalog resolved the issue, allowing successful backup operations to resume.

  • Oracle Data Pump Export Fails with ORA-31642

    Oracle Data Pump Export Fails with ORA-31642

    The post discusses an error encountered during a Data Pump export from an Oracle Database 19c, upgraded from 12c, specifically ORA-31642 and ORA-01031. Initially attributed to insufficient privileges, the problem was traced to lacking necessary rights. After granting required privileges and tablespace quotas, the export completed successfully.

  • Here is the wrap-up of POUG2026 (Pint With Oracle User Group).

    Here is the wrap-up of POUG2026 (Pint With Oracle User Group).

    The conference featured technical sessions with insights from various experts. Highlights included direct ASM file access via NFS, effective use of SQL tracing for diagnosing contention, and practical applications of SQLcl and AutoUpgrade. Presentations also covered transitioning to SaaS, PostgreSQL for Oracle DBAs, and lots of many things all about Oracle. Overall, the event fostered valuable networking and knowledge sharing among database professionals.