</b> <br/> When performing a Oracle 12c database restore to an Alternate location on a Windows server the following error message is shown: <br/> <br/> <table 800“=”“ border=“0” cellpadding=“0” cellspacing=“0” width=“700”>
<!-- <tbody>tr --> <tr> <!-- td --> <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> No. </td> <!-- td<br />td --> <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> Type </td> <!-- td<br />td --> <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> Timestamp </td> <!-- td<br />td --> <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> Log </td> <!-- td --> </tr> <!-- tr<br /><br />tr --> <tr> <!-- td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> * </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> ... </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> ... </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> ... </td> <!-- td --> </tr> <!-- tr<br /><br />tr --> <tr> <!-- td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> * </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> erro </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> YYYY/MM/DD <span> </span> hh:mm:ss </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> <span style="color: #FF0000"> ORA-01078: failure in processing system parameters </span> </td> <!-- td --> </tr> <!-- tr<br /><br />tr --> <tr> <!-- td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> * </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> erro </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> YYYY/MM/DD <span> </span> hh:mm:ss </b> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> <span style="color: #FF0000"> LRM-00109: could not open parameter file </span> </td> <!-- td --> </tr> <!-- tr<br /><br />tr --> <tr> <!-- td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> * </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> erro </span> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> <span style="color: #FF0000"> YYYY/MM/DD <span> </span> hh:mm:ss </b> </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> <span style="color: #FF0000"> Restore database fail., Reason = "Set database parameter fail" </span> </td> <!-- td --> </tr> <!-- tr<br /><br /><br />tr --> <tr> <!-- td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> * </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> info </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> <span> </span> ... </td> <!-- td<br />td --> <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> <span> </span> ... </td> <!-- td --> </tr> <!-- tr<br />[/td1][/tr]</tbody> -->
</table> <br/> </html>
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"
.
To workaround this issue either:
Oracle 12c, Windows, Alternate location, temporary folder, permission, restore