My Oracle Support Banner

DBCA -SILENT -CREATEDATABASE ... -INITPARAMS CANNOT PARSE LOG ARCHIVE DESTINATION PARAMETER VALUES (Doc ID 2952499.1)

Last updated on AUGUST 23, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

if log_archive_dest_1 in Initparams contains both LOCATION and VALID_FOR :

InitParams=...,log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES, ALL_ROLES)',

dbca fails with

[WARNING] ORA-01078: failure in processing system parameters
[FATAL] ORA-01034: ORACLE not available

if InitParams=...,log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST', 'VALID_FOR=(ALL_LOGFILES, ALL_ROLES)', - database is created but "show parameter log_archive_dest_1" returns "LOCATION=USE_DB_RECOVERY_FILE_DEST" (VALID_FOR part was ignored).

Changes

 

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.