-
1. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
jariola Mar 29, 2018 6:20 AM (in response to Denis Savenko)Because instruction is for "fresh" install, I propose run apxremov.sql script before install APEX 5.1.
It will remove also APEX static files from database
-
2. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
Denis Savenko Mar 29, 2018 7:19 AM (in response to jariola)Hm, will defintely have a look at this script (had not a clue about it, because the official documentation lacks information about it).
-
3. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
jariola Mar 29, 2018 8:41 AM (in response to Denis Savenko)It is mentioned in documentation A.4.2 Removing Oracle Application Express from the Database.
And of course you run script that comes with XE, and not version you going to install.
You find script from your XE installation $ORACLE_HOME/apex
-
4. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
jariola Mar 29, 2018 9:10 AM (in response to Denis Savenko)Few more comment:
Instead altering default profile by command
alter profile default limit password_life_time unlimited;
I would create new profile where password not expire and assign that for needed users.
Just wonder where you need this below?
alter system set job_queue_processes=100 scope=spfile;
And maybe you check how these parameters works. Do you really need 250 sessions and why set processes parameter.
alter system set sessions=250 scope=spfile; alter system set processes=200 scope=spfile;
I would remove Tomcat HTTP connector.
In HTTPD I would use something like below for APEX static files so you don't need define separately file types.
And you can use longer expire.
# Alias to APEX static files Alias "/i/" "/var/www/apex/images/" <Directory "/var/www/apex/images/"> AllowOverride none Require all granted <IfModule expires_module> ExpiresActive on ExpiresDefault "access plus 10 year" <IfModule headers_module> Header append Cache-Control "public" </IfModule> </IfModule> </Directory>
-
5. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
Denis Savenko Mar 29, 2018 10:42 AM (in response to jariola)Instead altering default profile by command I would create new profile where password not expire and assign that for needed users.
Well, this is, I think, a matter of preferences. I prefer using really long passwords instead of changing them often.
Just wonder where you need this below?
Excerpt from the docs:
JOB_QUEUE_PROCESSES
determine the maximum number of concurrently running jobs. In Oracle Application Express transactional support and SQL scripts require jobs. IfJOB_QUEUE_PROCESSES
is not enabled and working properly, you cannot successfully execute a script. I don't remember clearly, but also I read somewhere that APEX processes also utilize JOBs for running.I would remove Tomcat HTTP connector.
I wrote about it in the second part of the guide. I suggested doing it as an excercise.
In HTTPD I would use something like below for APEX static files so you don't need define separately file types. And you can use longer expire.
And this is a really fair point. Will definitely add this to the guide, though, I think, It is better to combine both approaches (in order to cache apllication-based static files as well).
-
6. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
jariola Mar 29, 2018 10:50 AM (in response to Denis Savenko)Denis Savenko wrote:
It is better to combine both approaches (in order to cache apllication-based static files as well).
I didn't quite understand what you mean by this.
Could you please explain?
If you mean e.g. workspace and application static files that are stored to database, APEX 5.1.x adds by default needed headers that client caches files.
And you can cache those also in HTTPD, see this blog post
-
7. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
Denis Savenko Mar 29, 2018 10:51 AM (in response to jariola)And maybe you check how these parameters works. Do you really need 250 sessions and why set processes parameter.
About this point - frankly speaking, I just stole this from Morten. I didn't think much about the values, the only thought was well, it should be enough.
I would really appreciate if you shared your thought about this and guided me in the right direction.
-
8. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
Denis Savenko Mar 29, 2018 1:29 PM (in response to jariola)By the way, I love the fact that your blog is totally powered by APEX, I was lazy to implement a new application with this functionality. Didn't you think about sharing your blogging platform with the community?
-
9. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
jariola Mar 29, 2018 1:43 PM (in response to Denis Savenko)Denis Savenko wrote:
Didn't you think about sharing your blogging platform with the community?
Yes, I have think. Application is available in SourceForge.
Unfortunately, SourceForge having some issues right now. At least I get error when try access there.And unfortunately I haven't yet find time to publish new version for APEX 5.x.
But it is coming some point and maybe I move project to GitHub
-
10. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
Franck N Mar 29, 2018 1:47 PM (in response to Denis Savenko)Ok,
Keep us up to date.
regards
-
11. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
Denis Savenko Mar 29, 2018 3:20 PM (in response to jariola)But it is coming some point and maybe I move project to GitHub
Great, that was exactly what I dreamt to hear)
Looking forward to seeing it on GitHub.
-
12. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
Mike Kutz Mar 29, 2018 6:02 PM (in response to Denis Savenko)Denis Savenko wrote:
Just wonder where you need this below?
Excerpt from the docs:
JOB_QUEUE_PROCESSES
determine the maximum number of concurrently running jobs. In Oracle Application Express transactional support and SQL scripts require jobs. IfJOB_QUEUE_PROCESSES
is not enabled and working properly, you cannot successfully execute a script. I don't remember clearly, but also I read somewhere that APEX processes also utilize JOBs for running.Link is bad for me. I found a similar document. But, the quoted section of text was in the EPG Deployment section.
I can see EPG using job_queue_processes threads.
You can probably skip this step if you're using ORDS.
My $0.02
MK
-
13. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
Denis Savenko Mar 30, 2018 6:21 AM (in response to Mike Kutz)But, the quoted section of text was in the EPG Deployment section.
I can see EPG using job_queue_processes threads.
It was indeed in that section, but I thought the words "In Oracle Application Express transactional support and SQL scripts require jobs" do not quite relate to EPG itself.
I mean scripts are scripts everywhere, not only in EPG, as well as APEX processes.
I do not argue I can be wrong, but still, it could be lack of documentation in ORDS section as well.
And, I'm not sure how to test the functionality to be sure it leverages JOBs or not when usin ORDS.
-
14. Re: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7 explained!
Denis Savenko Apr 1, 2018 10:12 AM (in response to jariola)jariola wrote:
Because instruction is for "fresh" install, I propose run apxremov.sql script before install APEX 5.1.
It will remove also APEX static files from database
Finally, I managed to update the second part of the guide following your piece of advice: http://dsavenko.me/oracledb-apex-ords-tomcat-httpd-centos7-all-in-one-guide-part-two/