Upgrade ORA-01722: invalid number and ORA-06512 during rdbms/admin/olsload.sql
(Doc ID 2693608.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
In the upgrade log the following is seen:
Identifier OLS <Timestamp>
SCRIPT = [<ORACLE_HOME>/rdbms/admin/olsload.sql]
ERROR = [ORA-01722: invalid number ORA-06512: at line 5]
STATEMENT = [DECLARE
oid_status NUMBER;
BEGIN
SELECT COUNT(*) INTO oid_status FROM lbacsys.ols$props
WHERE name='OID_STATUS_FLAG' AND value$=1;
IF oid_status = 1 THEN
:file_name := 'prvtolsldap.plb';
ELSE
:file_name := sys.dbms_registry.nothing_script;
END IF;
END;]
Changes
The following NLS paramters are set in the pfile/spfile:
NLS_SORT='BINARY_CI'
NLS_COMP='LINGUISTIC'
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 |
Changes |
Cause |
Solution |
References |