Sidebar
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
Table of Contents
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:
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:
-
Change the "Temporary directory for storing restore files" to location where the Oracle service has full read and write permissions.
OR - 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
