Re: Oracle Apex Question

There are a few things here that need to be looked at if you want to cover all the possibilities and ensure a smooth migration.

1. How is APEX used by the clients

http://hostname/ords/apex indicates ORDS is used (but again, the file can be renamed and this would change the URL - the path used in the URL would have to correspond to the name of the war file you'd see running). http://hostname/* (on port 80) is more likely to be a real web server (OHS or Apache)
http://hostname:8080/apex is most likely EPG.

You can also look for the processes - for OHS or Apache, you'd see httpd processes, and for ORDS you'd see a .war file being run by java; usually it's called ords.war but it can be renamed. Also keep in mind that they can be offloaded - e.g. you can run OHS or ORDS on a different machine than the database, they don't need to be local.

For EPG, what MUST be the case if it's being used is that the XDB HTTP port is open. You can see that by either querying:

SQL> select dbms_xdb.gethttpport from dual;

GETHTTPPORT

          0

.. here, zero means it's closed; or by checking your listener with lsnrctl status where you'd see an XDB endpoint (usually on port 8080).

2) Depending on 1) what else you need to move

Generally, exporting the workspace and application will work (see here for example
https://ruepprich.wordpress.com/2011/07/15/exporting-an-apex-application-via-command-line/ )

If you're using EPG, it's likely that all the components the APEX app needs are inside the database (and stored in XDB).

However, if you're using OHS or ORDS, there may also be files referenced outside the database.

If you have access to the APEX environment, you can also take a look at SQL Workshop -> RESTful Services to see if any are configured.

Let us know what you find and if you need more information

Stefan

On Wed, Jun 6, 2018 at 1:25 AM, Scott Canaan <srcdco_at_rit.edu> wrote:

> I will be running the install for Apex 5.4, which is the version I
> ultimately need to end up with. I am trying to figure out how to get the
> Apex 4.1 data migrated over so it isn’t lost when the upgrade to Apex 5.4
> is done.
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> srcdco_at_rit.edu | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_
> freelists.org] *On Behalf Of *Jeffrey Beckstrom
> *Sent:* Tuesday, June 05, 2018 2:02 PM
> *To:* oracle-l-freelist; rjoralist3_at_society.servebeer.com
> *Subject:* Re: Oracle Apex Question
>
>
>
> I would think you would have to run the install since at least in 11G,
> APEX appears in dba_registry.
>
> >>> Rich J <rjoralist3_at_society.servebeer.com> 6/5/18 1:54 PM >>>
>
> On 2018/06/05 07:19, Scott Canaan wrote:
>
> I have an application that uses Oracle Apex. We are just starting an
> application, Oracle, and O/S upgrade. I have to copy the Apex “install”
> from Oracle 11.2.0.3 on Red Hat 6 to Oracle 12.1.0.2 on Red Hat 7.
> Normally, I do a data pump import across the network to migrate the Oracle
> schemas, but I’ve been told that doesn’t work for Apex. I need to preserve
> the Apex version at 4.01 until the application upgrade, then it will be
> upgraded to the current version.
>
> Is it true that I can’t use Oracle data pump to copy Apex from one server
> to another?
>
>
>
> The correct answer is "it depends", of course. I suspect that if the
> webserver is the builtin EPG and there are no external files (custom
> images, CSS, etc), it *may* work. I'm not sure if APEX 4.x will work in an
> Oracle 12.1 DB either. If possible, I would upgrade the APEX version
> first, then migrate to another DB/server.
>
> I've only attempted migrations by using the APEX export/import
> application, but I'm using ORDS on Tomcat for the web and also external
> files. As always, test, and YMMV.
>
> GL!
>
> Rich
>

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/

--
http://www.freelists.org/webpage/oracle-l