Data Guard physru_v3.sh Script Errors ORA-01403 ORA-06512
(Doc ID 2570572.1)
Last updated on MAY 14, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
While executing physru_v3.sh script as part of DBMS_ROLLING upgrade process, got ORA-01403 ORA-06512 errors as below:
### The following error was encountered:
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 5
### The offending sql code in its entirety:
set pagesize 0 feedback off verify off heading off echo off tab off
whenever sqlerror exit sql.sqlcode
select to_char(dest_id) into destid from v$archive_dest where
lower(db_unique_name) = lower('AOASRLMP');
stmt := 'alter system set log_archive_dest_state_' || destid || '=enable';
execute immediate stmt;
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