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

In this Document

APPLIES TO: 

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

Bug 9289361 was filed and is listed as duplicate of Bug 974890 - Not feasible to Fix.

SOLUTION

1.  Use a pfile/spfile that has a valid location.
OR
2.  Change the pfile/spfile removing the invalid location.
OR
3.  Bring the storage location online thereby making the location available.

REFERENCES