Sidebar

Announcement

Ahsay Backup Software

Backup Set Types

Supported Storage

Features in OBM / ACB

Features in CBS

Brand and Customize

License

Documentation

Performance Testing

FAQs and Known Issues

Can't Find What You Need?

public:5266_issue:ora-01078:failure_in_processing_system_parameters_error_when_restoring_an_oracle_12c_database_to_an_alternate_location_on_a_windows_server

ISSUE:"ORA-01078: failure in processing system parameters" error when restoring an Oracle 12c database to an Alternate location on a Windows server

Article ID: 5266
Reviewed: 07/08/2017

Product Version:
AhsayOBM: 7.5.0.0 or above
OS: Windows

===== Problem Description =====
When performing a Oracle 12c database restore to an Alternate location on a Windows server the following error message is shown:

No. Type Timestamp Log
* ... ... ...
* erro YYYY/MM/DD hh:mm:ss ORA-01078: failure in processing system parameters
* erro YYYY/MM/DD hh:mm:ss LRM-00109: could not open parameter file
* erro YYYY/MM/DD hh:mm:ss Restore database fail., Reason = "Set database parameter fail"
* info ... ...

Cause

This is a known issue on AhsayOBM v7 when restoring an Oracle 12c database to an Alternate location on a Windows server. If the "Temporary directory for storing restore files" is left on the default setting, i.e. "C:\Users\Administrator\temp" . As the Windows account used to start the Oracle database service does not have permission to access the folder "C:\Users\Administrator\temp" .

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.

Keyword

Oracle 12c, Windows, Alternate location, temporary folder, permission, restore

public/5266_issue/ora-01078/failure_in_processing_system_parameters_error_when_restoring_an_oracle_12c_database_to_an_alternate_location_on_a_windows_server.txt · Last modified: 2018/06/28 16:35 by mike.gong