8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Multitenant : Remove APEX Installations from the CDB in Oracle Database 12c Release 1 (12.1)


Joel R. Kallman said...

For the customer who who wishes to manage a fleet of APEX databases, and to patch/upgrade them in concert, then leaving APEX in the root container is desirable.

For those who wish to have discrete control over which PDBs have APEX and which do not, and to manage a collection of PDBs with varying APEX versions, then removing APEX from the root container is the best practice. It's what I do.

Tim... said...

Hi.

I'm sure there are people out there that will find it useful, but for most folks I imagine it is a pain. :)

Cheers

Tim...

Laury said...

Hi Tim,
As usual, great article for you!
After upgrading the shipped version of APEX in the CDB I was not being able to create a PDB: ORA-01403, ORA-06512: at "SYS.VALIDATE_APEX", line 144.
Upgrading the shipped version of APEX in the PDB returned an invalid registry for the APEX component.
Kind Regards

Tim... said...

Hi.

I never use the shared APEX installation, so not sure what to say. I guess you need to contact the APEX team.

If you have a database support CSI, you can raise an SR on MOS. If not, post a question in the APEX forum. The APEX team read those. :)

Cheers

Tim...

Tonny said...

when i try to uninstall apex from the CDB i get this error :
catconInit: database is not open
Unexpected error encountered in catconInit; exiting

but it open.

using the apex from the installed oracle home.

Tim... said...

Hi.

Are you sure your environment is set correctly? ORACLE_HOME and ORACLE_SID must be correct for catcon.pl to work.

Cheers

Tim...

John V said...

Just as an FYI
In RAC you need to set your SID correctly for the node your on
So for me with Container Database 4

export ORACLE_SID=CD41
sqlplus / as sysdba
@apxremov_con.sql

Otherwise you get errors like
catconInit: database is not open on the default instance

Tim... said...

Hi.

I kind-of through that was implied, by the fact we are connecting using "/ as sysdba". I've added it in anyway, just in case it confuses someone. :)

Cheers

Tim...

Tim Krupinski said...

Just an FYI - when creating the APEX tablespace I had to manually specify a datafile path (using filesystem management):

create tablespace apex datafile '/u02/app/oracle/oradata/orcl/pdborcl/apex.dbf' size 100M autoextend on next 1M;

Hope it helps somebody!

Tim... said...

Hi.

That's because you are not using Oracle Managed Files (OMF), which is the recommendation when using the multitenant architecture.

Cheers

Tim...

MRadovan said...

I made a new installation in PDB @ Oracle 12.2, where APEX wasn't preinstalled in CDB. After all these steps, when I try to start APEX from other machine in the network, I get just this annoying "Authentication Required" Dialog, with message: http://myip:myport is requesting your username and password. The site says: "XDB"!!!

Any solution?

Tim... said...

Hi.

It sounds like you are using the Embedded PL/SQL Gateway (EPG). If so, you need to do the EPG config inside the PDB.

https://oracle-base.com/articles/misc/oracle-application-express-apex-5-0-installation#epg-configuration

Cheers

Tim...

Anonymous said...

Although I often see this recommendation of installing local apex inside a pdb as opposed to common, I can never find a straightforward answer as to how to remove apex common cleanly from a container with pdbs already installed.

Tim... said...

Hi.

Unplug all the PDBs, remove APEX. Plug them back in. Manually drop all the APEX and Flow users. Install APEX in your PDB.

Cheers

Tim...
Prepared Statement Error: Table './oraclebasecms/cms_page_comment_uuids' is marked as crashed and should be repaired