"ORA-01078: failure in processing system parameters" error when restoring an Oracle 12c Database to an Alternate Location

5 Mar, 2025

Product Version

AhsayOBM: 7 and above

Operating System

Windows

Symptom

When performing a Oracle 12c database restore to an Alternate location on a Windows server the following error message is shown in the Restore Log/Report:


ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
Restore database fail., Reason = "Set database parameter fail"

Cause

When restoring an Oracle 12c database to an alternate location on a Windows server using AhsayOBM, the restore process fails if the "Temporary directory for storing restore files" is set to its default path, such as "C:\Users\Administrator\temp."

This happens because the Windows account running the Oracle database service does not have permission to access the default temp folder ("C:\Users\Administrator\temp"), causing the restore to fail with this configuration.

Resolution

To workaround this issue either:

  1. Change the "Temporary directory for storing restore files" to location where the Oracle service has full read and write permissions.

    OR

  2. Grant full read and write permission to the "C:\Users\Administrator\temp" folder to the Oracle login account.
Troubleshooting