OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » migrate APEX from Oracle 11g to Oracle XE 21

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

migrate APEX from Oracle 11g to Oracle XE 21 [message #687652]

Thu, 27 April 2023 08:52

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.

Report message to a moderator

Re: migrate APEX from Oracle 11g to Oracle XE 21 [message #687659 is a reply to message #687652]

Fri, 28 April 2023 04:23

John Watson
Messages: 8960
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 01:51:29 CST 2024