Skip to Main Content

Sunday, February 17, 2019

Stopping XE 18c properly when shutting down CentOs 7

Oracle Database

You can configure automatically start and stop Oracle XE 18c database on operating system startup and shutdown. See details from installation guide. I did install XE 18c on CentOs 7 and executed steps mentioned in installation guide. When viewing database alert.log after system reboot, noticed that database wasn't actually stopped properly. Processes were just killed. I didn't investigate more why that happens on my system. For workaround I did revert steps mentioned in installation guide and created service file for systemd.

Continue Reading

Sunday, March 4, 2018

Caching APEX static files

APEX and Apache HTTPD

Apache HTTP ServerThe APEX installation includes static files that are located on the web server. These files may changed normally only when you upgrade or apply patch to APEX. Because files are changing rarely, they are good subject stored to cache. If you use Apache HTTPD to serve static files, you can configure mod_file_cache for ones that are used most in your applications.

Continue Reading

Sunday, February 11, 2018

Changing Report Column Date Format

APEX Tips and Tricks

In APEX there is build in date formats SINCE and SINCE_SHORT that I use often in report date columns. Unfortunately you can't use SINCE format in application Globalization Attributes, so you need separately set it to columns. But, sometimes you need to see the actual date value in column.

Here is simple example how you can switch between application global date format and SINCE.

Continue Reading

Saturday, October 10, 2015

Oracle Database Developer Choice Awards

APEX Community

I'm finalist for Oracle Database Developer Choice Awards in Oracle Application Express (APEX) category.
I'm very impressed and surprised for this honor. I want thank all who have filled nomination form and voted. Special thanks to all who have also leave comments and supported me by blog posts and spreading word other ways.
If you haven't vote yet, now it's time. Voting ends at 15th of October. Please remember you can vote multiple persons in all categories. I hope Denes Kubicek's blog post encourage everybody to vote.

Continue Reading