My Oracle Support Banner

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 later
Information 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


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