ORA-01403 when applying Oracle database JVM patch 38523609 (January 2026 CPU) to 19c RU 29 database.
After installing the database RU patch 38632161 followed by the JVM patch 38632161, the following error is generated when applying the patch to the database via the datapatch utility:
-> Error at line 882: script javavm/install/bug35933540_apply.sql
- ORA-01403: no data found
- ORA-06512: at line 5
The log file indicates that the following code failed:
SQL> declare
2 stat varchar2(30);
3 begin
4
5 select status into stat from dba_registry where comp_id = 'JAVAVM';
6 if stat != 'REMOVED' then
7 begin
8 execute immediate 'revoke read on SYS.DBA_JAVA_CLASSES from PUBLIC';
9 execute immediate 'revoke read on SYS.CDB_JAVA_CLASSES from PUBLIC';
10 execute immediate 'grant select on SYS.DBA_JAVA_CLASSES to select_catalog_role';