ORA-06576 Occurred When CDB Schema For SQL Developer Web Is Enabled (18.4.3.1+) DBCS Classic (Doc ID 2475643.1)

Last updated on OCTOBER 17, 2023

Applies to:

Symptoms

When trying to enable CDB schema for SQL Developer Web (SDW) the following error is seen:

ORA-06576: not a valid function or procedure name

This works with SQL Developer Web for DBCS / DBaaS 18.3.3
Reproduces with 18.4.3 and above.

Enabling schema for PDB works for all versions. 

STEPS
======

/var/opt/oracle/ocde/assistants/ords/ords -ords_action="enable_schema_for_sdw" -ords_sdw_schema="C##SDWADMIN" -ords_sdw_schema_password="/home/oracle/password.txt" -ords_sdw_schema_enable_dba="true"
WARNING: Couldn't obtain the "dbname" value from the assistant parameters nor the "$OCDE_DBNAME" environment variable
Starting ORDS
Logfile is /var/opt/oracle/log/ords/ords_2018-11-12_15:10:58.log
Config file is /var/opt/oracle/ocde/assistants/ords/ords.cfg
INFO: Starting environment summary checks...
INFO: Datacenter : DEFAULT
INFO: Database version : 12102
INFO: Database CDB : yes
INFO: Original DBaaS Tools RPM installed : dbaastools-1.0-1+18.4.3.0.0_181011.1252.x86_64
INFO: Actual DBaaS Tools RPM installed : dbaastools-1.0-1+18.4.3.0.0_181011.1252.x86_64
INFO: DBTools JDK RPM installed : dbtools_jdk-1.8.0-2.74.el6.x86_64
INFO: DBTools JDK RPM "/var/opt/oracle/rpms/dbtools/dbtools_jdk-1.8.0-2.74.el6.x86_64.rpm" MD5 : 48f13bb401677bfc7cf0748eb1a6990d
INFO: DBTools ORDS Standalone RPM installed : dbtools_ords_standalone-18.2.0-1.r1831332.el7.x86_64
INFO: DBTools ORDS Standalone RPM "/var/opt/oracle/rpms/dbtools/dbtools_ords_standalone-18.2.0-1.r1831332.el7.x86_64.rpm" MD5 : 4451696691d301f44bdb463e5ff99aab
INFO: DBTools DBaaS Landing Page RPM installed : dbtools_dbaas_landing_page-3.0.0-1.el7.x86_64
INFO: DBTools DBaaS Landing Page RPM "/var/opt/oracle/rpms/dbtools/dbtools_dbaas_landing_page-3.0.0-1.el7.x86_64.rpm" MD5 : 8bf6a2f83a304a3b04add88060b9f1bd
INFO: Environment summary completed...
INFO: Action mode is "full"
INFO: Database Role is "PRIMARY"
WARNING: ORDS is installed in a certain PDB but not in the CDB$ROOT
INFO: Enabling "C##SDWADMIN" schema in "CDB$ROOT" container for SQL Developer Web...

SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 12 15:11:09 2018

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL Developer Web user enable starting...
Enabling "C##SDWADMIN" user for SQL Developer Web...

PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.

CALL ORDS.ENABLE_SCHEMA(
  *
ERROR at line 1:
ORA-06576: not a valid function or procedure name


Disconnected from Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
WARNING: "C##SDWADMIN" schema in the "CDB$ROOT" container for SQL Developer Web enabling was not successful...

Cause

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