Osman’s DBlog

How to Change DB_UNIQUE_NAME and Relocate All Oracle Database Files in ASM (Including PDB$SEED) #JoelKallmanDay

14 Oct 2026 01:10

—

by

Osman DİNÇ

Administration, Databases, Oracle

This article provides a step-by-step guide to changing the DB_UNIQUE_NAME parameter in Oracle Database after cloning, migration, or environment refreshes. It explains how to relocate database files, including datafiles, tempfiles, redo logs, control files, SPFILE, and password files, to a new directory structure in ASM or filesystem storage, while also covering for pdb$seed and Oracle Clusterware configuration.
Troubleshooting RMAN ORA-01403 When Allocating an SBT_TAPE Channel

19 Sep 2026 23:45

—

by

Osman DİNÇ

Backup, Databases, Oracle

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

19 Sep 2026 01:37

—

by

Osman DİNÇ

Backup, Databases, Oracle

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).

7 Sep 2026 02:46

—

by

Osman DİNÇ

Databases, Oracle

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

18 Aug 2026 21:43

—

by

Osman DİNÇ

Databases, Exadata, Oracle

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: Resolving DCS-10045 and DCS-12013 Errors During DB Home Update

15 Aug 2026 16:13

—

by

Osman DİNÇ

Databases, Exadata, Oracle

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.