Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » migrate APEX from Oracle 11g to Oracle XE 21 (Oracle: 11.2.0.3.0 APEX: 4.1.1.00.23)
icon5.gif  migrate APEX from Oracle 11g to Oracle XE 21 [message #687652] Thu, 27 April 2023 08:52 Go to next message
divv
Messages: 1
Registered: April 2023
Junior Member
Dear All,
I want to migrate APEX and I don't know which scenario will be the best.
I have old server with Oracle Database 11g Enterprise Edition Release 11.2.0.3.0; APEX: 4.1.1.00.23 and I want to transfer it to a new server with Oracle Database 21c Express Edition Release 21; APEX 22.2 [PDB].

I think to do it like this.

In Apex 4.1:
1. Export workspace.
2. Export application.

In Apex 22.2
1. Import Workspace.
2. Import application.

I'm not sure that's enough because the differences in the versions are large. I also can't touch anything on the old server so no update is an option.
Re: migrate APEX from Oracle 11g to Oracle XE 21 [message #687659 is a reply to message #687652] Fri, 28 April 2023 04:23 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

You'll need to get the parsing schema(s) across as well, with Data Pump.
In addition to the workspace(s) and application(s), you'll need to get the uploaded static content out, perhaps something like this,
export CLASSPATH=$ORACLE_HOME/jdbc/lib/ojdbc8.jar:$APEX_HOME/utilities
java oracle.apex.APEXExport -db $HOST:$PORT/$SERVICE -user system -password $SYSTEMPW -expFiles -workspaceid $WORKSPACEID
Then (our developers always tell me) the hard part: converting everything to the Universal Theme.

Previous Topic: How To Get APEX users who are currently active
Next Topic: tuning queries run through APEX
Goto Forum:
  


Current Time: Thu Mar 28 04:00:29 CDT 2024