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

[V7] 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: 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: <table 800“=”“ border=“0” cellpadding=“0” cellspacing=“0” width=“700”>

 <tr>  <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> No. </td>  <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> Type </td>  <td bgcolor="#E8E8E8" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-TOP: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> Timestamp </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"> Log </td>  </tr>  <tr>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> * </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> ... </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> ... </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> ... </td>  </tr>  <tr>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> * </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> erro </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> YYYY/MM/DD hh:mm:ss </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> ORA-01078: failure in processing system parameters </td>  </tr>  <tr>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> * </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> erro </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> YYYY/MM/DD hh:mm:ss </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> LRM-00109: could not open parameter file </td>  </tr>  <tr>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> * </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> erro </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> YYYY/MM/DD hh:mm:ss </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> Restore database fail., Reason = "Set database parameter fail" </td>  </tr>  <tr>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> * </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> info </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="top"> ... </td>  <td bgcolor="#ffffff" style="BORDER-LEFT: #C0C0C0 1px solid; BORDER-RIGHT: #C0C0C0 1px solid; BORDER-BOTTOM: #C0C0C0 1px solid" valign="middle"> ... </td>  </tr> 

</table> </html>

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: 2021/12/16 05:41 by anna.olalia

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?

Table of Contents