ORA-16032 During Startup with LOG_ARCHIVE_DEST_x Set Two Directories Deep (Doc ID 989664.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.5.0 to 11.2.0.0 [Release 8.1.5 to 11.2]
Generic Windows
This affects Windows only.

Symptoms

When specifying a LOG_ARCHIVE_DEST_x with a location that is Not Available (ie...doesn't exist)
and
that path is 2 directories deep
and
specified as OPTIONAL,

 an ORA-16032 is generated preventing the Database from starting.

In this case a test was done listing: 

log_archive_dest_x='location=c:\nowhwere\nowhere OPTIONAL'

Some Versions of the Database Software may show additional errors similar to:

ORA-16032: parameter LOG_ARCHIVE_DEST_2 destination string cannot be translated
ORA-9291: sksachk: invalid device specified for archive destination
OSD-4018: Unable to access the specified directory or device.
O/S-Error: (OS-2) The system cannot find the file specified.

Changes

The "OPTIONAL" location is not available.  This may be due to changing drive letters/UNC paths.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms