ORA-01405 while running "noncdb_to_pdb.sql" (Doc ID 2000882.1)

Last updated on SEPTEMBER 18, 2016

Applies to:

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

Symptoms

While running noncdb_to_pdb.sql,  You may get ORA-01405 error.

SQL> @noncdb_to_pdb.sql
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01405: fetched column value is NULL

The failing SQL will be similar to below:
select u.name, u.password, u.spare4, a.syspriv, decode(bitand(u.spare1, 128), 128, 1, 0) from adminauth$ a, user$ u where a.user# > 0 and u.user# = a.user# and a.syspriv != 0;

If any other SQL fails with ORA-01405,  then file a SR with Oracle Support as the cause may be different.   If the failing SQL is same as above, then proceed with the steps given in the "Solution" section.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms