Problem Description
-------------------
You are attempting to put archived logs onto a share/network drive.
On startup of the database, you recieve the following errors:
MGR-03514: Unable to Start Database
ORA-00256: error occurred in translating archive text string
'k:\new_archive_files'
ORA-09291: sksachk:invalid device specified for archive destination
OSD-04018: Unable to access the specified directory ordevice
O/S-Error: (OS 5) Access is denied
The above error messages are displayed when using either LOG_ARCHIVE_DEST
or LOG_ARCHIVE_DUPLEX_DEST and pointing them to a share or network drive.
Solution Description
--------------------
For OracleserviceSID to write to network disk, you have to assign a logon
user account to the OracleserviceSID service. The steps are as follows:
1. Make sure the instance is down.
2. Stop the service for your database using the control panel services.
3. From Start -> Programs -> Admin Tools -> User Manager
4. Make sure your user logon account has privilege of 'Logon as Service',
to find this select 'Show Advanced User Rights' then select the privilege
and hit o.k.
5. Change the OracleService<sid> in control panel -> Services.
6. Hit < Startup> button and change to 'Logon as this account',
enter username and password.
7. Start the service.
8. Startup the database.
Prerequisite: The user MUST exist on the local PC as an Administrator user.
User must exist on the network/share pc as a standard user.
In both the above cases password should be set to never expire.
Note. See the Bug.5176230 - It is not longer supported have archive logs in remote drives,
The archives must be in the primary machine
References
----------
Bug:382757
Bug:791316
To Bottom