In this Document
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
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
BUG:9289361 - ORA-16032 WITH OPTIONAL DESTINATION PREVENTS STARTUP 2 DIRECTORIES DEEP
BUG:974890 - INVALID LOG_ARCHIVE_DEST DOES NOT RETURN ERROR.