Databases@Powered by Passion

  • rman allocate channel fails

    Troubleshooting RMAN ORA-01403 When Allocating an SBT_TAPE Channel

    —

    by

    Osman DİNÇ
    , ,

    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.

  • POUG 2026

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

    —

    by

    Osman DİNÇ
    ,

    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.

  • rpmdb: DB_RUNRECOVERY Errors When Using dbaascli on Exacc

    rpmdb: DB_RUNRECOVERY Errors When Using dbaascli on Exacc

    —

    by

    Osman DİNÇ
    , ,

    To register a manually created database on Exacc using dbaascli, a DBNAME.ini file must be created first. A specific command may fail due to a corrupted RPM database under /var/lib/rpm, showing a standard RPM-related error. To resolve this, the RPM database needs to be rebuilt by backing up and removing stale files. After rebuilding, the registration command should succeed and generate the necessary cloud registration file.

  • ODA Patching Issue

    ODA Patching Issue: Resolving DCS-10045 and DCS-12013 Errors During DB Home Update

    —

    by

    Osman DİNÇ
    , ,

    During an Oracle Database Appliance (ODA) patching process, a validation error (DCS-10045) occurred due to the absence of ‘Running’ databases. Although a physical standby database was running, ODA’s dcsagent failed to recognize it. The issue was resolved by adding the database using the srvctl command, and fixing missing ASM directory paths allowed the patching to complete successfully.

  • register-database-fails-rman

    RMAN Register database for Catalog fails with ORA-01403

    —

    by

    Osman DİNÇ
    , ,

    The RMAN database registration process encountered an error, specifically ORA-01403 (no data found), during its initial synchronization due to an existing restore point. Despite entering commands correctly, the registration failed because RMAN could not process the restore point metadata across the CDB. Upon identifying this issue through trace analysis, the restore point was deleted, allowing successful completion of the database registration process, highlighting the importance of internal procedures in troubleshooting.