My Oracle Support Banner

DBUA fail With Error ORA-01722: Invalid Number for select on lbacsys.ols$props (Doc ID 2696041.1)

Last updated on AUGUST 03, 2020

Applies to:

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

Symptoms

Upgrading to 19.6.0.0.0 version.

DBUA failed with error ORA-01722: invalid number as below, when performing DB upgrade from 12.1(CDB) to 19.6.0.0   

 

ERROR
-----------------------

Elapsed: 00:00:00.00
11:59:04 SQL>
11:59:04 SQL> COLUMN :file_name NEW_VALUE comp_file NOPRINT
11:59:04 SQL> VARIABLE file_name VARCHAR2(256)
11:59:04 SQL>
11:59:04 SQL> DECLARE
11:59:04 2 oid_status NUMBER;
11:59:04 3
11:59:04 4 BEGIN
11:59:04 5 SELECT COUNT(*) INTO oid_status FROM lbacsys.ols$props
11:59:04 6 WHERE name='OID_STATUS_FLAG' AND value$=1;
11:59:04 7 IF oid_status = 1 THEN
11:59:04 8 :file_name := 'prvtolsldap.plb';
11:59:04 9 ELSE
11:59:04 10 :file_name := sys.dbms_registry.nothing_script;
11:59:04 11 END IF;
11:59:04 12 END;
11:59:04 13 /
DECLARE
*
ERROR at line 1:
ORA-01722: invalid number
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.