6.11 Performing Post Installation Tasks for Upgrade Installations
Once you have verified that your upgrade installation was successful and all upgraded applications function properly, you should remove schemas from prior Oracle APEX installations.
- About Removing Prior Oracle APEX Installations
Learn about removing schemas from a prior installation by verifying if a prior installation exists. - Verifying if a Prior Installation Exists
Run the SQL query to verify if a prior Oracle APEX installation exists. - Removing Schemas and SYS Objects from Prior Installations
Start SQL*Plus and connect to database and execute a statement to remove schemas andSYS
objects. - Removing Schemas from Prior Installations in a CDB
Usecatcon.pl
to remove schemas of prior installations in a CDB. - Fixing Invalid ACL
Learn how to fix an invalid ACL.
6.11.1 About Removing Prior Oracle APEX Installations
Learn about removing schemas from a prior installation by verifying if a prior installation exists.
The database users associated with schemas from prior installations are privileged users and should be removed when they are no longer necessary. Removing schemas from a prior installation is a two step process. First you verify if a prior installation exists and then you remove the schemas.
6.11.2 Verifying if a Prior Installation Exists
Run the SQL query to verify if a prior Oracle APEX installation exists.
To verify if a prior installation exists:
If the results contain entries in the form FLOWS_
XXXXXX
or APEX_
XXXXXX
where XXXXXX
represents six numbers, those entries are candidates for removal.
6.11.3 Removing Schemas and SYS Objects from Prior Installations
Start SQL*Plus and connect to database and execute a statement to remove
schemas and SYS
objects.
To remove schemas and SYS
objects from prior installations:
6.11.4 Removing Schemas from Prior Installations in a CDB
Use catcon.pl
to remove schemas of prior installations in a CDB.
To remove schemas and SYS objects from prior installations, run commands using the following example:
$ORACLE_HOME/perl/bin/perl -I $ORACLE_HOME/rdbms/admin $ORACLE_HOME/rdbms/admin/catcon.pl -b drop_apex210100 -- --x'drop user APEX_210100 cascade'
$ORACLE_HOME/perl/bin/perl -I $ORACLE_HOME/rdbms/admin $ORACLE_HOME/rdbms/admin/catcon.pl -b drop_wwv_dbms_sql -- --x'drop package SYS.WWV_DBMS_SQL_APEX_210100'
6.11.5 Fixing Invalid ACL
Learn how to fix an invalid ACL.
After following the instructions in"About Removing Prior Oracle APEX Installations," you may need to fix an invalid ACL if you are running Oracle Database and you enabled network services for the prior Oracle APEX schema.
To fix an invalid ACL: