My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.