ORA-00600: [kqldvir-no-result-from-view$] [1403] During ALTER PLUGGABLE DATABASE <PDB> OPEN (Doc ID 2972040.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

ALTER PLUGGABLE DATABASE <PDB> OPEN fails with error:

Failing query is similar to:

SELECT COUNT(*) FROM (SELECT /* interim patches */ 'Interim patch ' || patch_id || '/' || patch_uid patch_string,               
description, action, status FROM                                        
(SELECT dba_registry_sqlpatch.*,                                                      
RANK() OVER (PARTITION BY patch_id, patch_uid                                              
ORDER BY install_id DESC, action_time DESC) r               
FROM dba_registry_sqlpatch                                                    
WHERE patch_type = 'INTERIM'                                                  
AND flags NOT LIKE '%A%')                                                  
WHERE r = 1                                                                   
AND (action != 'ROLLBACK' OR status != 'SUCCESS')                             
ORDER BY patch_string);

The hcheck.sql script in <NOTE:136697.1> does not show any relevant dictionary issues.

When try open database in upgrade mode, it shows ORA-00600 [16201].

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.