Funny Behavior ORA-16025

From: Howard Latham <howard.latham_at_gmail.com>
Date: Thu, 30 May 2019 16:50:16 +0100
Message-ID: <CAPCNhx3arJpbW7rwx1Fj0fU+R6Hw_cXDTEU+-V=GqWPVBnrk2A_at_mail.gmail.com>



Linux RH 7 oracle 11.2.04

I know 1 is a special location but surely not 11-19? I also noticed that the trace file complains about the location ever though I am specifying a SERVICE! Anyone know why this is ok for dest 9 but not 19?

*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid ORA-16025: parameter LOG_ARCHIVE_DEST_19 contains repeated or conflicting attributes

SQL> l
  1 alter system set log_archive_dest_19 = 'SERVICE="TRIPS3"   2* async valid_for=(online_logfile,primary_role) db_unique_name=TRIPS3' SQL> alter system set log_archive_dest_4 = 'SERVICE="TRIPS3"   2* async valid_for=(online_logfile,primary_role) db_unique_name=TRIPS3'

1* alter system set log_archive_dest_4 = 'SERVICE="TRIPS3" SQL> / System altered.

!!

Best Wishes

Howard A. Latham

--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 30 2019 - 17:50:16 CEST

Original text of this message