failed to start the database in upgrade mode ora-16025 Error

[former_member249929]

Dear Gurus,

We are upgrading our Oracle database of BI PRD to 12.2. Dev and QAS was successfully completed. But in BI PRD the upgrade is failing from pre-checks. It is giving below error.

1. ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes

As far as i know, my team has tried to configure DR for this Bi system, and they failed and dropped. But the parameters which they have configured for the log shipping is still present in the BI PRD system. I have tried to change the parameter in sp file and orainit file. But still giving the same error.

Please find the spfile details below

=================================

*.job_queue_processes=1 *.log_archive_config='dg_config=(pbp_kch,pbp_bom)' *.log_archive_dest_1='LOCATION=/oracle/PBP/oraarch/PBParch' *.log_archive_dest_2='service="pbp_bom"','LGWR ASYNC NOAFFIRM delay=180 optional comprCC"l`ession=enable max_failure=0 max_connections=1 reopen=300 db_unique_name="pbp_bom" net_timeout=30','valid_for=(all_logfiles,primary_role)' *.log_archive_dest_3='location="/oracle/PBP/112_64/dbs/arch"','valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='ENABLE' *.log_archive_dest_state_3='ENABLE' *.log_archive_format='%t_%s_%r.dbf' *.log_archive_max_processes=2 *.log_archive_min_succeed_dest=1 *.log_archive_trace=0 *.log_checkpointCC-U_interval=0 *.log_checkpoints_to_alert=TRUE *.log_file_name_convert='PBP','PBP' *.max_dump_file_size='20000' *.open_cursors=800

==================================

initPBP.ora

==================================

*.diagnostic_dest='/oracle/PBP/saptrace' *.dml_locks=4000 *.event='10027','10028','10142','10183','10191','10995 level 2','38068 level 100','38085','38087','44951 level 1024','60025'#SAP_12102170418_201705 RECOMMENDED SETTINGS *.filesystemio_options='ASYNCH' *.job_queue_processes=1 *.log_archive_config='dg_config=(pbp_kch,pbp_bom)' *.log_archive_dest_1='LOCATION="/oracle/PBP/oraarch/PBParch"','valid_for=(ONLINE_LOGFILE,ALL_ROLES)' #*.log_archive_dest_2='service="pbp_bom"','LGWR ASYNC NOAFFIRM delay=180 optional compression=enable max_failure=0 max_connections=1 reopen=300 db_unique_name="pbp_bom" net_timeout=30','valid_for=(all_logfiles,primary_role)' *.log_archive_dest_3='location="/oracle/PBP/112_64/dbs/arch"','valid_for=(STANDBY_LOGFILE,STANDBY_ROLE)' *.log_archive_dest_1='location=/oracle/PBP/oraarch/PBParch' *.log_archive_dest_state_1='ENABLE' *.log_archive_dest_state_2='DEFER' *.log_archive_dest_state_3='ENABLE' *.log_archive_format='%t_%s_%r.dbf' *.log_archive_max_processes=2 *.log_archive_min_succeed_dest=1 *.log_archive_trace=0 *.log_checkpoint_interval=0 *.log_checkpoints_to_alert=TRUE *.log_file_name_convert='PBP','PBP' *.max_dump_file_size='20000'

====================================

Please find some command output also.

1) select DEST_NAME,STATUS,DESTINATION from V$ARCHIVE_DEST;

DEST_NAME -------------------------------------------------------------------------------- STATUS --------- DESTINATION -------------------------------------------------------------------------------- LOG_ARCHIVE_DEST_1 VALID /oracle/PBP/oraarch/PBParch LOG_ARCHIVE_DEST_2 INACTIVE DEST_NAME -------------------------------------------------------------------------------- STATUS --------- DESTINATION -------------------------------------------------------------------------------- LOG_ARCHIVE_DEST_3 VALID /oracle/PBP/112_64/dbs/arch

SQL> archive log list;

Database log mode Archive Mode

Automatic archival Enabled

Archive destination /oracle/PBP/112_64/dbs/arch

Oldest online log sequence 1228347

Next log sequence to archive 1228354

Current log sequence 1228354

I believe i need to disable the options, please help me to disable this and finish my upgrade.

Regards,

John