DB Creation Failing - ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2895749.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

DB Creation failed

Changes

 File : dbaastools_2022-07-19_08-31-15-PM_168374.log

******************************************************************************
SEVERE: [2022-07-19 20:54:40.818 CEST][main][AbstractErrorAdvisor.getDetailedMessage:105] [FATAL] [DBAAS-60022] Command '/var/opt/oracle/dbaastools/pilot/bin/pilot -plugin create_db_cloud CDB="true" LANGUAGE="AMERICAN" ORACLE_SID="DBSID" RESOURCE_OCID="ocid1.database.oc1.eu-frankfurt-1.XX" TENANCY_OCID="ocid1.tenancy.oc1..XX" DB_UNIQUE_NAME="DBSID" TERRITORY="AMERICA" ORACLE_HOME_NAME="OraHome4" NCHARSET="AL16UTF16" HONOR_NODE_NUMBER_FOR_INSTANCE="true" CHARSET="WE8MSWIN1252" PDB_NAME="pdb1" DBNAME="DBNAME" DB_AGENT_ID="725f21aa-29e3-4a0b-93df-60f05ab13cf6" PDB_ADMIN_USER_NAME="pdbuser" DBAASAPI_JOB_ID="2a26c087-815a-46a7-b84f-8b06cff7c19d" COMPARTMENT_OCID="ocid1.compartment.oc1..XX" -J-Doracle.install.commons.pilot.log.enablePID=true -logLevel FINE -logDir /var/opt/oracle/log/DBNAME/database/create -silent -checkpointDir /var/opt/oracle/log/pilot_checkpoints -jreLoc /usr/java/jdk1.8.0_331-amd64/jre ' execution has failed on nodes [localnode].
ACTION: Refer application log file for more information.
*MORE DETAILS*
Result of node:localnode
[Execution of Create_db_secure_profile failed, [FATAL] [DBAAS-60038] Unable to execute sql script: (/var/opt/oracle/ocde/assistants/dbda/opcsecureprofile.sql -targetusers=NONE -ignoreusers=NONE)., ACTION: Refer to the log file for more information., SUMMARY:, - ORA-06502: PL/SQL: numeric or value error: character string buffer too small, ORA-06512: at line 2, ******** PLUGIN EXECUTION FAILED ********, Executing jobs which need to be run always..., -----------------, Running DB_creation_release_lock job, Completed DB_creation_release_lock job, Completed execution.] ◄◄-----------------
Exit code of the operation:255

Refer associated stacktrace #oracle.install.commons.util.exception.AbstractErrorAdvisor:202
---# Begin Stacktrace #---------------------------
ID: oracle.install.commons.util.exception.AbstractErrorAdvisor:202
oracle.dbcloud.common.lib.ExecutionException: [DBAAS-60022] Command '/var/opt/oracle/dbaastools/pilot/bin/pilot -plugin create_db_cloud CDB="true" LANGUAGE="AMERICAN" ORACLE_SID="DBSID" RESOURCE_OCID="ocid1.database.oc1.eu-frankfurt-1.XX" TENANCY_OCID="ocid1.tenancy.oc1.XX" DB_UNIQUE_NAME="DBSID" TERRITORY="AMERICA" ORACLE_HOME_NAME="OraHome4" NCHARSET="AL16UTF16" HONOR_NODE_NUMBER_FOR_INSTANCE="true" CHARSET="WE8MSWIN1252" PDB_NAME="pdb1" DBNAME="DBNAME" DB_AGENT_ID="725f21aa-29e3-4a0b-93df-60f05ab13cf6" PDB_ADMIN_USER_NAME="pdbuser" DBAASAPI_JOB_ID="2a26c087-815a-46a7-b84f-8b06cff7c19d" COMPARTMENT_OCID="ocid1.compartment.oc1..aaaaaaaadgtolz3j4niumo62qj3sdwbo3gxwbdylzreocserzup6dyvl45uq" -J-Doracle.install.commons.pilot.log.enablePID=true -logLevel FINE -logDir /var/opt/oracle/log/DBNAME/database/create -silent -checkpointDir /var/opt/oracle/log/pilot_checkpoints -jreLoc /usr/java/jdk1.8.0_331-amd64/jre ' execution has failed on nodes [localnode].
at oracle.dbcloud.common.lib.cmd.DefaultCommandExecutor.run(DefaultCommandExecutor.java:378)
at oracle.dbcloud.common.lib.cmd.DefaultCommandExecutor.runAsUser(DefaultCommandExecutor.java:277)
at oracle.dblcm.sa.dbaastools.cmd.DBaasExecutorHelper.execute(DBaasExecutorHelper.java:66)
at oracle.dblcm.sa.dbaastools.cmd.PilotExecutor.execute(PilotExecutor.java:125)
at oracle.dblcm.sa.dbaastools.cmd.PilotPluginCommandProcessor.runPilotExecutor(PilotPluginCommandProcessor.java:122)
at oracle.dblcm.sa.dbaastools.cmd.PilotPluginCommandProcessor.processCommand(PilotPluginCommandProcessor.java:82)
at oracle.dblcm.sa.dbaastools.driver.DBaaSToolsDriver.setup(DBaaSToolsDriver.java:271)
at oracle.dblcm.sa.dbaastools.driver.DBaaSToolsApplication.run(DBaaSToolsApplication.java:171)
at oracle.install.commons.util.Application.startup(Application.java:1142)
at oracle.install.commons.util.Application.startup(Application.java:870)
at oracle.dblcm.sa.dbaastools.driver.DBaaSToolsApplication.startup(DBaaSToolsApplication.java:149)
at oracle.dblcm.sa.dbaastools.driver.DBaaSToolsApplication.main(DBaaSToolsApplication.java:180)

---# End Stacktrace #-----------------------------
INFO: [2022-07-19 20:54:40.828 CEST][main][AbstractErrorAdvisor.advise:52] Advice is ABORT
SEVERE: [2022-07-19 20:54:40.828 CEST][main][DefaultExceptionHandler.handleException:46] Unconditional Exit

Cause

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