Database Administration (MOSC)

MOSC Banner

19c : dbca response file "log_archive_dest_1" parameter with LOCATION and VALID_FOR

edited Oct 14, 2022 2:26PM in Database Administration (MOSC) 8 commentsAnswered ✓

"dbca -silent -createDatabase -responseFile dbca_response_MYDB44.rsp" fails with errors :

[WARNING] ORA-01078: failure in processing system parameters

[FATAL] ORA-01034: ORACLE not available

when initParams string contains this parameter: log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES, ALL_ROLES)'

in sqlplus the same line works fine:

SQL> alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES)';

System altered.

If I try to use this value : log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST', 'VALID_FOR=(ALL_LOGFILES, ALL_ROLES)' (which is also valid for sqlplus) - the second part of the value after comma is ignored, database is created but log_archive_dest_1 parameter equals to LOCATION=USE_DB_RECOVERY_FILE_DEST

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center