My Oracle Support Banner

OCI-C: DBCS Provisionnig Failed With Message 'An Error Occurred While Installing ORDS RPM ORA-06502: PL/SQL: numeric or value error: character string buffer too small' (Doc ID 2487062.1)

Last updated on FEBRUARY 12, 2020

Applies to:

Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms


OCI Classic env. Creating DBCS instance failed at 'checkDatabaseConfig' with following exception stack.

ERROR: An error occurred while installing "ORDS RPM"".
............
SSH access to VM [DB_1/vm-1] succeeded...
Failed to configure Oracle Database Server...
[...
SCRIPT execution errors in [x.x.x.x]:
INFO: Starting catcon log files removal
INFO: catcon log files removed
Died at /var/opt/oracle/ocde/assistants/ords/ords line 5791
ERROR: An error occurred while installing "ORDS RPM"

ERROR : Assistant ords has failed, please check ocde logfile /var/opt/oracle/log/UUECD07D/ocde/ocde_2018-12-20_10:31:16.log
INFO: Total time taken by ocde is 967 seconds

#### Completed OCDE with errors, please check logs ####
### End: /var/opt/oracle/ocde/ocde.out

From PSM logs



Dec 20, 2018 12:11:31 PM oracle.dbtools.installer.InstallerCDB log
INFO: CDB restart file created in /u01/app/oracle/product/ords/log/ords_restart_2018-12-20_121131_00383.properties
java.io.IOException: Error executing script: ords_create_rest_users.sql Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 3

Refer to log file /u01/app/oracle/product/ords/log/ords_cdb_install_core_CDB_ROOT_2018-12-20_121129_00849.log for details
at oracle.dbtools.installer.Runner.executeSQLScript(Runner.java:224)
at oracle.dbtools.installer.Runner.executeScripts(Runner.java:114)
at oracle.dbtools.installer.Runner.executeScripts(Runner.java:57)
at oracle.dbtools.installer.Runner.executeScripts(Runner.java:41)
at oracle.dbtools.installer.InstallerBase.installORDS(InstallerBase.java:147)
at oracle.dbtools.installer.InstallerCDB.cdbInstallORDS(InstallerCDB.java:124)
at oracle.dbtools.installer.InstallerCDB.processCDB(InstallerCDB.java:57)
at oracle.dbtools.installer.InstallerCDB.CDBProcessing(InstallerCDB.java:35)
at oracle.dbtools.installer.Installer.cdbProcessing(Installer.java:65)
at oracle.dbtools.installer.Installer.execute(Installer.java:52)
at oracle.dbtools.rt.config.setup.SchemaSetup.install(SchemaSetup.java:63)
at oracle.dbtools.rt.config.setup.Setup.execute(Setup.java:293)
at oracle.dbtools.cmdline.DefaultCommand.execute(DefaultCommand.java:115)
at oracle.dbtools.cmdline.Commands.execute(Commands.java:195)
at oracle.dbtools.cmdline.Commands.main(Commands.java:156)
at oracle.dbtools.cmdline.Commands.main(Commands.java:349)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at oracle.dbtools.jarcl.Entrypoint.invoke(Entrypoint.java:66)
at oracle.dbtools.jarcl.Entrypoint.main(Entrypoint.java:77)
Dec 20, 2018 12:11:31 PM oracle.dbtools.installer.InstallerCDB processCDB
SEVERE: Error executing script: ords_create_rest_users.sql Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 3

Refer to log file /u01/app/oracle/product/ords/log/ords_cdb_install_core_CDB_ROOT_2018-12-20_121129_00849.log for details
ERROR: Unable to configure the ORDS' Database Objects

 

Changes

 

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


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