Article ID: 5266
Reviewed: 2017-08-07

Product Version:
AhsayOBM: 7.5.0.0 to 7.x
OS: Windows

ATTENTION 1st January, 2022: v7 officially End-of-Life [details] ===== 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