My Oracle Support Banner

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 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

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:
declare
*
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
declare
 stmt varchar2(256);
 destid varchar2(4);
begin
 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;
end;
/
exit;

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
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.