MIME-Version: 1.0
In-Reply-To: <0f88c9d82b2042f4a2a91ccf37e8233c@ex04mail01b.ad.rit.edu>
References: <e1126a8b596d4393b1427b7527bb1adf@ex04mail01b.ad.rit.edu>
 <291750f70fa45bf393b237d7ea66c919@society.servebeer.com> <5B16D0060200000B00041849@groupwise2014.gcrta.org>
 <e0228a910ce441fbaa68a9e117ab420a@ex04mail01b.ad.rit.edu> <CAP50yQ-d9=VX6A1s1HWtTFz3awnNKSM_HRgnfSNuuvegLGkDqw@mail.gmail.com>
 <0f88c9d82b2042f4a2a91ccf37e8233c@ex04mail01b.ad.rit.edu>
From: Stefan Knecht <knecht.stefan@gmail.com>
Date: Wed, 6 Jun 2018 21:29:24 +0700
Message-ID: <CAP50yQ-keacD5kV8siPyQUDuz+S9jDe5FV72FthW1UGo2n3eZg@mail.gmail.com>
Subject: Re: Oracle Apex Question
To: Scott Canaan <srcdco@rit.edu>, oracle-l-freelist <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="0000000000008d92fc056df9ff1f"
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: knecht.stefan@gmail.com
--0000000000008d92fc056df9ff1f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hey Scott

Most welcome.

Based on what you stated - I'm fairly certain there must be a web server
involved, if the only account that's open is the APEX_PUBLIC_USER. It not
having any objects is normal.

It could run locally on the same machine as the database (if you're saying
it's a "package" you got as-is then that's quite likely). You should look
for a dads.conf file, which would tell you where the images directory is
mapped on the server - you will see an entry similar to this in that file:

Alias /i/ "/u00/app/webDomain/
fuzzy.co.th/config/fmwconfig/components/OHS/instances/ohs1/images_apex5/"

The path will look different of course - and likely simpler - if you're on
an older version.

When using APEX with an HTTP server, the entire apex images directory is
copied there and this would also be where any custom javascript or style
sheet files are located. Depending on how the environment was built, the
files may be anywhere within that directory and may be hard to locate. You
may want to download the same apex version, extract it and do a compare on
the images directory contents to determine if there is custom stuff in
there that you will need to bring along for the application to function.

You may also want to try looking at the page source (if you are logged on
to the application, "view page source" and look for links referencing files
in /i/, such as this for example:

<script type=3D"text/javascript"
src=3D"/i/select2.min.js?v=3D5.1.3.00.05"></script>
<script type=3D"text/javascript" src=3D"/i/zz_user_mgmt.js?v=3D1.0.48"></sc=
ript>

Do note however that the default apex files are also referenced this way,
so it may not be immediately obvious.

Another thing is that the files included may vary depending on which page
of the application you're on. So if there are many pages, this may not be
feasible.

One last thing that just came to mind - it's possible that they didn't use
a dads.conf and just put all the settings necessary for APEX in other conf
files (httpd.conf or even something else - if you can't find a dads.conf on
the machine you have to dig a little deeper). But I'd bet you will have
httpd processes running.

Stefan


On Wed, Jun 6, 2018 at 8:34 PM, Scott Canaan <srcdco@rit.edu> wrote:

> Stefan,
>
>    Thank you for the explanations.  This is very helpful.  What I can tel=
l
> you is this:
>
>
>
> 1)      I don=E2=80=99t know how it is used =E2=80=93 this is a purchased=
 package.
>
> APEX_PUBLIC_USER is unlocked.  It owns nothing.
>
> APEX_040100 owns everything.
>
> ORDS_PUBLIC_USER doesn=E2=80=99t exist.
>
> ANONYMOUS is locked.
>
>
>
> I did the query for the http port and it returned 0.
>
>
>
> I plan on running through the upgrade / migration process in test at leas=
t
> a couple of times to make sure I get everything.  I=E2=80=99m hoping just=
 using
> datapump will work to get what I need over to the new server, where Apex
> 5.4 will eventually be installed.
>
>
>
> *Scott Canaan =E2=80=9888*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> srcdco@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 tha=
n
> the intended recipient is prohibited. If you received this in error, plea=
se
> contact the sender and destroy any copies of this information.
>
>
>
> *From:* Stefan Knecht [mailto:knecht.stefan@gmail.com]
> *Sent:* Tuesday, June 05, 2018 7:50 PM
> *To:* Scott Canaan
> *Cc:* jbeckstrom@gcrta.org; oracle-l-freelist;
> rjoralist3@society.servebeer.com
>
> *Subject:* Re: Oracle Apex Question
>
>
>
> There are a few things here that need to be looked at if you want to cove=
r
> all the possibilities and ensure a smooth migration.
>
>
>
> 1) How is APEX used by the clients
>
>
>
> Currently there's EPG (not likely in production), Oracle HTTP Server (OHS=
)
> with mod_plsql, Oracle REST data services (ORDS - formerly known as APEX
> Listener), or even if someone has been very adventurous, mod_owa over
> Apache.
>
>
>
> To help determine what can be and can't be in use, a good starting point
> is to look at the database users you have in that database.
>
>
>
> APEX_PUBLIC_USER, if it's unlocked (and particularly if you see
> connections) indicates OHS is used.
>
> ORDS_PUBLIC_USER, if it's unlocked indicates ORDS is used.
>
> ANONYMOUS if it's unlocked indicates EPG is used.
>
>
>
> It's also worth noting that these aren't mutually exclusive - you can run
> them all at the same time. You can run a standard APEX app via OHS and at
> the same time offer REST services via ORDS.
>
>
>
> A good way to find out is to just connect to the APEX web interface with =
a
> browser and see what pops up on the database end (e.g. which users become
> active). Another indicator is the URL that's used to connect to APEX:
>
>
>
> 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 c=
an
> be offloaded - e.g. you can run OHS or ORDS on a different machine than t=
he
> 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 lsnrct=
l
> 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 fo=
r
> 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@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=E2=80=99t lost when the upgrade to =
Apex 5.4
> is done.
>
>
>
> *Scott Canaan =E2=80=9888*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> srcdco@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 tha=
n
> the intended recipient is prohibited. If you received this in error, plea=
se
> contact the sender and destroy any copies of this information.
>
>
>
> *From:* oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@
> freelists.org] *On Behalf Of *Jeffrey Beckstrom
> *Sent:* Tuesday, June 05, 2018 2:02 PM
> *To:* oracle-l-freelist; rjoralist3@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@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 =E2=80=9Ci=
nstall=E2=80=9D
> 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 Oracl=
e
> schemas, but I=E2=80=99ve been told that doesn=E2=80=99t 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=E2=80=99t use Oracle data pump to copy Apex from on=
e 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 | @zztat_oracle | fb.me/zztat | zztat.net/blog/
>


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

--0000000000008d92fc056df9ff1f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hey Scott<div><br></div><div>Most welcome.</div><div><br><=
/div><div>Based on what you stated - I&#39;m fairly certain there must be a=
 web server involved, if the only account that&#39;s open is the APEX_PUBLI=
C_USER. It not having any objects is normal.</div><div><br></div><div>It co=
uld run locally on the same machine as the database (if you&#39;re saying i=
t&#39;s a &quot;package&quot; you got as-is then that&#39;s quite likely). =
You should look for a dads.conf file, which would tell you where the images=
 directory is mapped on the server - you will see an entry similar to this =
in that file:</div><div><br></div><div>Alias /i/ &quot;/u00/app/webDomain/<=
a href=3D"http://fuzzy.co.th/config/fmwconfig/components/OHS/instances/ohs1=
/images_apex5/">fuzzy.co.th/config/fmwconfig/components/OHS/instances/ohs1/=
images_apex5/</a>&quot;<br></div><div><br></div><div>The path will look dif=
ferent of course - and likely simpler - if you&#39;re on an older version.<=
/div><div><br></div><div>When using APEX with an HTTP server, the entire ap=
ex images directory is copied there and this would also be where any custom=
 javascript or style sheet files are located. Depending on how the environm=
ent was built, the files may be anywhere within that directory and may be h=
ard to locate. You may want to download the same apex version, extract it a=
nd do a compare on the images directory contents to determine if there is c=
ustom stuff in there that you will need to bring along for the application =
to function.<br></div><div><br></div><div>You may also want to try looking =
at the page source (if you are logged on to the application, &quot;view pag=
e source&quot; and look for links referencing files in /i/, such as this fo=
r example:</div><div><br></div><div><div>&lt;script type=3D&quot;text/javas=
cript&quot; src=3D&quot;/i/select2.min.js?v=3D5.1.3.00.05&quot;&gt;&lt;/scr=
ipt&gt;</div><div>&lt;script type=3D&quot;text/javascript&quot; src=3D&quot=
;/i/zz_user_mgmt.js?v=3D1.0.48&quot;&gt;&lt;/script&gt;</div></div><div><br=
></div><div>Do note however that the default apex files are also referenced=
 this way, so it may not be immediately obvious.</div><div><br></div><div>A=
nother thing is that the files included may vary depending on which page of=
 the application you&#39;re on. So if there are many pages, this may not be=
 feasible.</div><div><br></div><div>One last thing that just came to mind -=
 it&#39;s possible that they didn&#39;t use a dads.conf and just put all th=
e settings necessary for APEX in other conf files (httpd.conf or even somet=
hing else - if you can&#39;t find a dads.conf on the machine you have to di=
g a little deeper). But I&#39;d bet you will have httpd processes running.<=
/div><div><br></div><div>Stefan</div><div><br></div><div><br></div><div cla=
ss=3D"gmail_extra"><br><div class=3D"gmail_quote">On Wed, Jun 6, 2018 at 8:=
34 PM, Scott Canaan <span dir=3D"ltr">&lt;<a href=3D"mailto:srcdco@rit.edu"=
 target=3D"_blank">srcdco@rit.edu</a>&gt;</span> wrote:<br><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex">


<div lang=3D"EN-US">
<div class=3D"gmail-m_-3798796245620508550WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:11pt;font-family:Calibri,sa=
ns-serif;color:rgb(31,73,125)">Stefan,<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt;font-family:Calibri,sa=
ns-serif;color:rgb(31,73,125)">=C2=A0=C2=A0 Thank you for the explanations.=
=C2=A0 This is very helpful.=C2=A0 What I can tell you is this:<u></u><u></=
u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt;font-family:Calibri,sa=
ns-serif;color:rgb(31,73,125)"><u></u>=C2=A0<u></u></span></p>
<p class=3D"gmail-m_-3798796245620508550MsoListParagraph"><u></u><span styl=
e=3D"font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><s=
pan>1)<span style=3D"font-style:normal;font-variant:normal;font-weight:norm=
al;font-stretch:normal;font-size:7pt;line-height:normal;font-family:&quot;T=
imes New Roman&quot;">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
</span></span></span><u></u><span style=3D"font-size:11pt;font-family:Calib=
ri,sans-serif;color:rgb(31,73,125)">I don=E2=80=99t know how it is used =E2=
=80=93 this is a purchased package.<u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:0.5in"><span style=3D"font-size=
:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">APEX_PUBLIC_USER=
 is unlocked.=C2=A0 It owns nothing.<u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:0.5in"><span style=3D"font-size=
:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">APEX_040100 owns=
 everything.<u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:0.5in"><span style=3D"font-size=
:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">ORDS_PUBLIC_USER=
 doesn=E2=80=99t exist.<u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:0.5in"><span style=3D"font-size=
:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">ANONYMOUS is loc=
ked.<u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:0.5in"><span style=3D"font-size=
:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u>=C2=A0<u>=
</u></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:0.5in"><span style=3D"font-size=
:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I did the query =
for the http port and it returned 0.<u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:0.5in"><span style=3D"font-size=
:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u>=C2=A0<u>=
</u></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:0.5in"><span style=3D"font-size=
:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I plan on runnin=
g through the upgrade / migration process in test at least a couple of time=
s to make sure I get everything.=C2=A0 I=E2=80=99m hoping
 just using datapump will work to get what I need over to the new server, w=
here Apex 5.4 will eventually be installed.<u></u><u></u></span></p><span c=
lass=3D"gmail-">
<p class=3D"MsoNormal"><span style=3D"font-size:11pt;font-family:Calibri,sa=
ns-serif;color:rgb(31,73,125)"><u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><b><span style=3D"color:rgb(244,123,32)">Scott Canaa=
n =E2=80=9888</span></b><b><span style=3D"font-size:11pt;color:rgb(31,73,12=
5)"><br>
</span></b><i><span style=3D"font-size:11pt;color:rgb(31,73,125)">Sr Databa=
se Administrator
<br>
</span></i><span style=3D"font-size:11pt;color:rgb(31,73,125)">Information =
&amp; Technology Services<br>
Finance &amp; Administration <b><u></u><u></u></b></span></p>
<p class=3D"MsoNormal"><b><span style=3D"font-size:11pt;color:rgb(31,73,125=
)">Rochester Institute of Technology<br>
</span></b><span style=3D"font-size:11pt;color:rgb(31,73,125)">o: (585) 475=
-7886 | f: (585) 475-7520</span><b><span style=3D"font-size:11pt;color:rgb(=
31,73,125)"><u></u><u></u></span></b></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt;color:rgb(31,73,125)">=
<a href=3D"mailto:srcdco@rit.edu" target=3D"_blank"><span style=3D"color:bl=
ue">srcdco@rit.edu</span></a> | c:
</span><span style=3D"font-size:11pt;color:rgb(31,73,125)">(585) </span><sp=
an style=3D"font-size:11pt;color:rgb(31,73,125)">339-8659
<br>
<br>
<u></u><u></u></span></p>
<p class=3D"MsoNormal"><b><span lang=3D"EN" style=3D"font-size:8pt;color:rg=
b(31,73,125)">CONFIDENTIALITY NOTE</span></b><span lang=3D"EN" style=3D"fon=
t-size:8pt;color:rgb(31,73,125)">: The information transmitted, including a=
ttachments, is intended only for the person(s) or entity
 to which it is addressed and may contain confidential and/or privileged ma=
terial. Any review, retransmission, dissemination or other use of, or takin=
g of any action in reliance upon this information by persons or entities ot=
her than the intended recipient
 is prohibited. If you received this in error, please contact the sender an=
d destroy any copies of this information.</span><span style=3D"font-size:8p=
t;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt;font-family:Calibri,sa=
ns-serif;color:rgb(31,73,125)"><u></u>=C2=A0<u></u></span></p>
</span><p class=3D"MsoNormal"><b><span style=3D"font-size:10pt;font-family:=
Tahoma,sans-serif">From:</span></b><span style=3D"font-size:10pt;font-famil=
y:Tahoma,sans-serif"> Stefan Knecht [mailto:<a href=3D"mailto:knecht.stefan=
@gmail.com" target=3D"_blank">knecht.stefan@gmail.<wbr>com</a>]
<br>
<b>Sent:</b> Tuesday, June 05, 2018 7:50 PM<br>
<b>To:</b> Scott Canaan<br>
<b>Cc:</b> <a href=3D"mailto:jbeckstrom@gcrta.org" target=3D"_blank">jbecks=
trom@gcrta.org</a>; oracle-l-freelist; <a href=3D"mailto:rjoralist3@society=
.servebeer.com" target=3D"_blank">rjoralist3@society.servebeer.<wbr>com</a>=
</span></p><div><div class=3D"gmail-h5"><br>
<b>Subject:</b> Re: Oracle Apex Question<u></u><u></u></div></div><p></p><d=
iv><div class=3D"gmail-h5">
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<div>
<p class=3D"MsoNormal">There are a few things here that need to be looked a=
t if you want to cover all the possibilities and ensure a smooth migration.=
<u></u><u></u></p>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">1) How is APEX used by the clients<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">Currently there&#39;s EPG (not likely in production)=
, Oracle HTTP Server (OHS) with mod_plsql, Oracle REST data services (ORDS =
- formerly known as APEX Listener), or even if someone has been very advent=
urous, mod_owa over Apache.<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">To help determine what can be and can&#39;t be in us=
e, a good starting point is to look at the database users you have in that =
database.<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">APEX_PUBLIC_USER, if it&#39;s unlocked (and particul=
arly if you see connections) indicates OHS is used.<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal">ORDS_PUBLIC_USER, if it&#39;s unlocked indicates ORD=
S is used.<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal">ANONYMOUS if it&#39;s unlocked indicates EPG is used=
.<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">It&#39;s also worth noting that these aren&#39;t mut=
ually exclusive - you can run them all at the same time. You can run a stan=
dard APEX app via OHS and at the same time offer REST services via ORDS.=C2=
=A0<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">A good way to find out is to just connect to the APE=
X web interface with a browser and see what pops up on the database end (e.=
g. which users become active). Another indicator is the URL that&#39;s used=
 to connect to APEX:=C2=A0<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><a href=3D"http://hostname/ords/apex" target=3D"_bla=
nk">http://hostname/ords/apex</a> indicates ORDS is used (but again, the fi=
le 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&#39;d
 see running).<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><a href=3D"http://hostname/*" target=3D"_blank">http=
://hostname/*</a> (on port 80) is more likely to be a real web server (OHS =
or Apache)<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><a href=3D"http://hostname:8080/apex" target=3D"_bla=
nk">http://hostname:8080/apex</a> is most likely EPG.<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">You can also look for the processes - for OHS or Apa=
che, you&#39;d see httpd processes, and for ORDS you&#39;d see a .war file =
being run by java; usually it&#39;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, the=
y don&#39;t need to be local.<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">For EPG, what MUST be the case if it&#39;s being use=
d is that the XDB HTTP port is open. You can see that by either querying:<u=
></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<div>
<p class=3D"MsoNormal">SQL&gt; select dbms_xdb.gethttpport from dual;<u></u=
><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">GETHTTPPORT<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal">-----------<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal">=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0<u></u><u></u></=
p>
</div>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">.. here, zero means it&#39;s closed; or by checking =
your listener with lsnrctl status where you&#39;d see an XDB endpoint (usua=
lly on port 8080).=C2=A0<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">2) Depending on 1) what else you need to move<u></u>=
<u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">Generally, exporting the workspace and application w=
ill work (see here for example=C2=A0<a href=3D"https://ruepprich.wordpress.=
com/2011/07/15/exporting-an-apex-application-via-command-line/" target=3D"_=
blank">https://ruepprich.<wbr>wordpress.com/2011/07/15/<wbr>exporting-an-ap=
ex-application-<wbr>via-command-line/</a>
 )<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">If you&#39;re using EPG, it&#39;s likely that all th=
e components the APEX app needs are inside the database (and stored in XDB)=
.<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">However, if you&#39;re using OHS or ORDS, there may =
also be files referenced outside the database.<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">If you have access to the APEX environment,=C2=A0 yo=
u can also take a look at SQL Workshop -&gt; RESTful Services to see if any=
 are configured.=C2=A0<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">Let us know what you find and if you need=C2=A0 more=
 information<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal">Stefan<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
</div>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<div>
<p class=3D"MsoNormal">On Wed, Jun 6, 2018 at 1:25 AM, Scott Canaan &lt;<a =
href=3D"mailto:srcdco@rit.edu" target=3D"_blank">srcdco@rit.edu</a>&gt; wro=
te:<u></u><u></u></p>
<div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt;font-family:Calibri,sa=
ns-serif;color:rgb(31,73,125)">I will be running the install for Apex 5.4, =
which is the version I ultimately need to end up with.=C2=A0
 I am trying to figure out how to get the Apex 4.1 data migrated over so it=
 isn=E2=80=99t lost when the upgrade to Apex 5.4 is done.</span><u></u><u><=
/u></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt;font-family:Calibri,sa=
ns-serif;color:rgb(31,73,125)">=C2=A0</span><u></u><u></u></p>
<div>
<p class=3D"MsoNormal"><b><span style=3D"color:rgb(244,123,32)">Scott Canaa=
n =E2=80=9888</span></b><b><span style=3D"font-size:11pt;color:rgb(31,73,12=
5)"><br>
</span></b><i><span style=3D"font-size:11pt;color:rgb(31,73,125)">Sr Databa=
se Administrator
<br>
</span></i><span style=3D"font-size:11pt;color:rgb(31,73,125)">Information =
&amp; Technology Services<br>
Finance &amp; Administration </span><u></u><u></u></p>
<p class=3D"MsoNormal"><b><span style=3D"font-size:11pt;color:rgb(31,73,125=
)">Rochester Institute of Technology<br>
</span></b><span style=3D"font-size:11pt;color:rgb(31,73,125)">o: (585) 475=
-7886 | f: (585) 475-7520</span><u></u><u></u></p>
<p class=3D"MsoNormal" style=3D"margin-bottom:12pt"><span style=3D"font-siz=
e:11pt;color:rgb(31,73,125)"><a href=3D"mailto:srcdco@rit.edu" target=3D"_b=
lank">srcdco@rit.edu</a> | c: (585) 339-8659
</span><u></u><u></u></p>
<p class=3D"MsoNormal"><b><span lang=3D"EN" style=3D"font-size:8pt;color:rg=
b(31,73,125)">CONFIDENTIALITY NOTE</span></b><span lang=3D"EN" style=3D"fon=
t-size:8pt;color:rgb(31,73,125)">: The information transmitted, including
 attachments, is intended only for the person(s) or entity to which it is a=
ddressed and may contain confidential and/or privileged material. Any revie=
w, retransmission, dissemination or other use of, or taking of any action i=
n 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 copi=
es of this information.</span><u></u><u></u></p>
</div>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt;font-family:Calibri,sa=
ns-serif;color:rgb(31,73,125)">=C2=A0</span><u></u><u></u></p>
<div>
<div style=3D"border-right:none;border-bottom:none;border-left:none;border-=
top:1pt solid rgb(181,196,223);padding:3pt 0in 0in">
<p class=3D"MsoNormal"><b><span style=3D"font-size:10pt;font-family:Tahoma,=
sans-serif">From:</span></b><span style=3D"font-size:10pt;font-family:Tahom=
a,sans-serif">
<a href=3D"mailto:oracle-l-bounce@freelists.org" target=3D"_blank">oracle-l=
-bounce@freelists.org</a> [mailto:<a href=3D"mailto:oracle-l-bounce@freelis=
ts.org" target=3D"_blank">oracle-l-bounce@<wbr>freelists.org</a>]
<b>On Behalf Of </b>Jeffrey Beckstrom<br>
<b>Sent:</b> Tuesday, June 05, 2018 2:02 PM<br>
<b>To:</b> oracle-l-freelist; <a href=3D"mailto:rjoralist3@society.servebee=
r.com" target=3D"_blank">
rjoralist3@society.servebeer.<wbr>com</a><br>
<b>Subject:</b> Re: Oracle Apex Question</span><u></u><u></u></p>
</div>
</div>
<div>
<div>
<p class=3D"MsoNormal">=C2=A0<u></u><u></u></p>
<div id=3D"gmail-m_-3798796245620508550m_4404464672119812206GroupWiseSectio=
n_1528221679000_jbeckstrom@gcrta.org_114824E002EF00009705AA006A008700_">
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:Tahoma,san=
s-serif">I would think you would have to run the install since at least in =
11G, APEX appears in dba_registry.</span><u></u><u></u></p>
</div>
<div id=3D"gmail-m_-3798796245620508550m_4404464672119812206GroupWiseSectio=
n_1528221678000_jbeckstrom@gcrta.org_114824E002EF00009705AA006A008700_">
<p class=3D"MsoNormal"><span class=3D"gmail-m_-3798796245620508550m44044646=
72119812206groupwisereplyheader"><span style=3D"font-size:10pt;font-family:=
Tahoma,sans-serif">&gt;&gt;&gt; Rich J &lt;<a href=3D"mailto:rjoralist3@soc=
iety.servebeer.com" target=3D"_blank">rjoralist3@society.servebeer.<wbr>com=
</a>&gt;
 6/5/18 1:54 PM &gt;&gt;&gt;</span></span><u></u><u></u></p>
<div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:Tahoma,san=
s-serif">On 2018/06/05 07:19, Scott Canaan wrote:</span><u></u><u></u></p>
</div>
<blockquote style=3D"border-top:none;border-right:none;border-bottom:none;b=
order-left:1.5pt solid rgb(16,16,255);padding:0in 0in 0in 5pt;margin:5pt 0i=
n">
<div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:Tahoma,san=
s-serif">I have an application that uses Oracle Apex.=C2=A0 We are just sta=
rting an application, Oracle, and O/S upgrade.=C2=A0 I have
 to copy the Apex =E2=80=9Cinstall=E2=80=9D from Oracle 11.2.0.3 on Red Hat=
 6 to Oracle 12.1.0.2 on Red Hat 7.=C2=A0 Normally, I do a data pump import=
 across the network to migrate the Oracle schemas, but I=E2=80=99ve been to=
ld that doesn=E2=80=99t work for Apex.=C2=A0 I need to preserve the Apex ve=
rsion
 at 4.01 until the application upgrade, then it will be upgraded to the cur=
rent version.</span><u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:Tahoma,san=
s-serif">Is it true that I can=E2=80=99t use Oracle data pump to copy Apex =
from one server to another?</span><u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:Tahoma,san=
s-serif">=C2=A0</span><u></u><u></u></p>
</div>
</div>
</blockquote>
<div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:Tahoma,san=
s-serif">The correct answer is &quot;it depends&quot;, of course.=C2=A0 I s=
uspect that if the webserver is the builtin EPG and there are
 no external files (custom images, CSS, etc), it *may* work.=C2=A0 I&#39;m =
not sure if APEX 4.x will work in an Oracle 12.1 DB either.=C2=A0 If possib=
le, I would upgrade the APEX version first, then migrate to another DB/serv=
er.</span><u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:Tahoma,san=
s-serif">I&#39;ve only attempted migrations by using the APEX export/import=
 application, but I&#39;m using ORDS on Tomcat for the
 web and also external files.=C2=A0=C2=A0 As always, test, and YMMV.</span>=
<u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:Tahoma,san=
s-serif">GL!</span><u></u><u></u></p>
</div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-size:10pt;font-family:Tahoma,san=
s-serif">Rich</span><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class=3D"MsoNormal"><br>
<br clear=3D"all">
<u></u><u></u></p>
<div>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
</div>
<p class=3D"MsoNormal">-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<p class=3D"MsoNormal">//<u></u><u></u></p>
</div>
<p class=3D"MsoNormal">zztat - The Next-Gen Oracle Performance Monitoring a=
nd Reaction Framework!<u></u><u></u></p>
<div>
<p class=3D"MsoNormal">Visit us at=C2=A0<a href=3D"http://zztat.net/" targe=
t=3D"_blank"><span style=3D"color:rgb(17,85,204)">zztat.net</span></a>=C2=
=A0| @zztat_oracle |
<a href=3D"http://fb.me/zztat" target=3D"_blank">fb.me/zztat</a> | <a href=
=3D"http://zztat.net/blog/" target=3D"_blank">
zztat.net/blog/</a><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
</div>

</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div class=
=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div>//</div><s=
pan style=3D"font-size:small">zztat - The Next-Gen Oracle Performance Monit=
oring and Reaction Framework!</span><div style=3D"font-size:small">Visit us=
 at=C2=A0<a href=3D"http://zztat.net/" style=3D"color:rgb(17,85,204)" targe=
t=3D"_blank">zztat.net</a>=C2=A0| @zztat_oracle | <a href=3D"http://fb.me/z=
ztat" target=3D"_blank">fb.me/zztat</a> | <a href=3D"http://zztat.net/blog/=
" target=3D"_blank">zztat.net/blog/</a></div></div></div></div></div>
</div></div>

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