My Oracle Support Banner

Apex Installation ORA-00933 Error On A New PDB (Doc ID 2636534.1)

Last updated on FEBRUARY 06, 2020

Applies to:

Oracle Application Express (APEX) - Version 18.2 and later
Information in this document applies to any platform.

Symptoms

On : APEX 18.2 version, Administration

When attempting to install APEX on a new PDB
the following error occurs.

ERROR
-----------------------
ORA-00933: SQL command not properly ended
  # Statement: comment on column apex_appl_data_profile_cols.remote_attribute_
name is 'Attribute name to be used in filter or order by expressions when
 different from column selector.'
  #
  # comment on column apex_appl_data_profile_cols.last_updated_by
 is 'APEX developer who made last update'
ERROR at line 1:
ORA-20001: Install errors found in phase 1
ORA-06512: at "APEX_180200.WWV_INSTALL_API", line 435
ORA-06512: at line 5


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create a new PDB

   create pluggable database <PDB_NAME> admin user <PDB_ADMIN_USER> identified by <PASSWORD>;

   alter pluggable database <PDB_NAME> open instances=all;


2.connect as SYS ans switch to the PDB

       SQL> alter session set container=<PDB_NAME>;


3. run @apexins.sql TABLESPACE_APEX TABLESPACE_FLOWS TEMP /i/


Changes

 New Installation of APEX on a new PDB

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.