My Oracle Support Banner

datapatch fails with Error : "ORA-01403: no data found" during execution of script rdbms/admin/backport_files/bug_29766207_apply.sql (Doc ID 3078356.1)

Last updated on MARCH 28, 2025

Applies to:

Oracle Database - Enterprise Edition - Version 19.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Datapatch execution for DB RU fails with below error-

[2025-03-22 10:58:59] Installation queue:
[2025-03-22 10:58:59] No interim patches need to be rolled back
[2025-03-22 10:58:59] Patch 37260974 (Database Release Update : 19.26.0.0.250121 (37260974)):
[2025-03-22 10:58:59] Apply from 19.1.0.0.0 Feature Release to 19.26.0.0.0 Release_Update 250118124854
[2025-03-22 10:58:59] The following interim patches will be applied:
[2025-03-22 10:58:59] 37102264 (OJVM RELEASE UPDATE: 19.26.0.0.250121 (37102264))

[2025-03-22 10:59:00] Installing patches...
[2025-03-22 11:00:46] Patch installation complete. Total patches installed: 2

[2025-03-22 11:00:46] Validating logfiles...[2025-03-22 11:00:51] done
[2025-03-22 11:00:51] Patch 37260974 apply: WITH ERRORS
[2025-03-22 11:00:51] logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/37260974/26040769/37260974_apply_ORCL_2025Mar22_10_59_00.log[2025-03-22 11:00:51] (errors)
[2025-03-22 11:00:51] -> Error at line 436813: script rdbms/admin/backport_files/bug_29766207_apply.sql
[2025-03-22 11:00:51] - ORA-01403: no data found
[2025-03-22 11:00:51] - ORA-06512: at line 22
[2025-03-22 11:00:51] - ORA-06512: at line 5
[2025-03-22 11:00:51] ru_logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/37260974/26040769/37260974_ru_apply_ORCL_2025Mar22_10_59_00.log[2025-03-22 11:00:51] (no errors)
[2025-03-22 11:00:51] Patch 37102264 apply: WITH ERRORS (PREV PATCH)
[2025-03-22 11:00:51] logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/37102264/25987410/37102264_apply_ORCL_2025Mar22_10_59_00.log[2025-03-22 11:00:51] (no errors)

Checking Patch Apply Log, Below is the Code Block inside bug_29766207_apply.sql that results in the ORA_01403 Error -

SQL> Rem =========================================================================
SQL> Rem Bug 29766207  : change value of parameter ALTERNATE_PLAN_BASELINE
SQL> Rem from 'AUTO' to 'EXISTING'
SQL> Rem =========================================================================
SQL>
SQL>
SQL> -- Insert upgrade actions here
SQL> DECLARE
2 old_value VARCHAR2(32767);
3 BEGIN
4
5 SELECT p.value INTO old_value
6 FROM sys.wri$_adv_parameters p, sys.wri$_adv_tasks t
7 WHERE p.task_id = t.id and t.name = 'SYS_AUTO_SPM_EVOLVE_TASK' AND
8 p.name = 'ALTERNATE_PLAN_BASELINE';
9
10 IF (old_value = 'AUTO') THEN
11 prvt_advisor.set_task_parameter(task_name =>'SYS_AUTO_SPM_EVOLVE_TASK',
12 parameter =>'ALTERNATE_PLAN_BASELINE',
13 data =>'EXISTING',
14 task_owner_id => prvt_advisor.SYS_USER_ID);
15 END IF;
16
17 EXCEPTION
18 WHEN OTHERS THEN
19 IF SQLCODE = -942
20 THEN NULL;
21 ELSE
22 RAISE;
23 END IF;
24 END;
25 /
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 22
ORA-06512: at line 5





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.