𝗔𝗽𝗲𝘅 𝟮𝟭.𝟭 𝗔𝗽𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗠𝗶𝗴𝗿𝗮𝘁𝗶𝗼𝗻 𝗙𝗿𝗼𝗺 𝘀𝗼𝘂𝗿𝗰𝗲 𝘁𝗼 𝗧𝗮𝗿𝗴𝗲𝘁 𝘀𝗲𝗿𝘃𝗲𝗿 (𝗢𝗻-𝗽𝗿𝗲𝗺𝗶𝘀𝗲 𝘁𝗼 𝗢𝗖𝗜 𝗖𝗹𝗼𝘂𝗱 𝗣𝗹𝗮𝘁𝗳𝗼𝗿𝗺)

                                                             ░A░P░E░X░

𝐻𝑒𝓁𝓁𝑜 𝑒𝓋𝑒𝓇𝓎𝑜𝓃𝑒, 𝒜𝒻𝓉𝑒𝓇 𝒶 𝓂𝑜𝓃𝓉𝒽 𝑜𝒻 𝑔𝒶𝓅, 𝐼 𝒽𝒶𝓋𝑒 𝒹𝑒𝒸𝒾𝒹𝑒𝒹 𝓉𝑜 𝓈𝒽𝒶𝓇𝑒 𝒜𝓅𝑒𝓍 𝑀𝒾𝑔𝓇𝒶𝓉𝒾𝑜𝓃 𝓼𝓽𝓮𝓹𝓼 𝓌𝒾𝓉𝒽 𝒶𝓁𝓁 𝑜𝒻 𝓎𝑜𝓊.

𝐼 𝒽𝑜𝓅𝑒 𝒾𝓉 𝓌𝒾𝓁𝓁 𝒽𝑒𝓁𝓅 𝒶𝓁𝓁 𝑜𝒻 𝓎𝑜𝓊  𝒾𝓃 𝓎𝑜𝓊𝓇 𝓅𝓇𝑜𝒻𝑒𝓈𝓈𝒾𝑜𝓃𝒶𝓁 𝒸𝒶𝓇𝓇𝑒e𝓇 𝑒𝓋𝑒𝓃 𝒾𝒻 𝓎𝑜𝓊 𝒶𝓇𝑒 𝓃𝑜𝓉 𝒻𝒶𝓂𝒾𝓁𝒾𝒶𝓇 𝓌𝒾𝓉𝒽 "𝒜𝓅𝑒𝓍".

𝒮𝑜 𝓁𝑒𝓉'𝓈 𝓈𝓉𝒶𝓇𝓉 𝒻𝓇𝑜𝓂 𝒽𝑒𝓇𝑒..!!

Step 1:  Create backups of the APEX Workspaces and Applications

At First, Go to  $ORACLE_HOME/apex/utilities  Take Workspace backup: java oracle.apex.APEXExport -db hostname:PORT:SID -user <username> -password <password> -expWorkspace    Take every application and shared component backup: java oracle.apex.APEXExport -db hostname:Port:SID -user <username> -password <password> -instance

Step 2: On the Target Database Node 19C Create the Apex schema by Installing Apex

SQL> @apexins.sql tablespace_apex tablespace_files tablespace_temp images Now, Change Apex Admin Password:

Step 3: Configuring Oracle REST Data Services

Sql> @apex_rest_config.sql   Install ORDS Service: $ java -jar ords.war install advanced

Now, Import Apex workspaces and Application: $ sqlplus "/as sysdba" alter session set current_schema = APEX_210100; --Run the scripts to create the workspaces..!! In my case I have created one shell script and executed all at once. SQL> @/orahome/oracle/PROD/19.3.0/software/apex/utilities/Apex_WFexport.sql   Session altered.     Session altered.   --application/set_environment WORKSPACE 1368305965994364 Creating workspace PRODICS... Creating Groups... Creating group grants... Creating Users... ...RESTful Services SCHEMA PRODICS - User Interface Defaults, Table Defaults User Interface Defaults, Attribute Dictionary ...done --application/set_environment WORKSPACE 6468418341304004 Creating workspace XXFMPROJ... Creating Groups... Creating group grants... Creating Users... ...RESTful Services SCHEMA XXFMPROJ - User Interface Defaults, Table Defaults User Interface Defaults, Attribute Dictionary ...done --application/set_environment WORKSPACE 1247603809411412 Creating workspace EXCELVENA... Creating Groups... Creating group grants... Creating Users... ...RESTful Services SCHEMA APPS - User Interface Defaults, Table Defaults SCHEMA XXFMIT - User Interface Defaults, Table Defaults User Interface Defaults, Attribute Dictionary ...done

Apex URL: http://localhost:8080/ords/apex_admin

~~~~~If you liked my Post please share OR Comment....Thanks !!