DBUA fail With Error ORA-01722: Invalid Number for select on lbacsys.ols$props
(Doc ID 2696041.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation 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
-----------------------
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 |