Uncategorized

For me, myself and I (as a reminder) 🙂 I needed to calculate the difference between a log entry and the previous log-entry to be able to investigate where performance was dropping: With alittle bit of help here and here I figured out how to do it:

This is post 7 in the Fully Freeware APEX environment series. The post will cover the configuration of the Oracle HTTP server. Please mention, that I’m not fully aware about the license restrictions on the Oracle HTTP server. What I heard is that if you use it for an APEX installation and install it physically … Read more

This is post 6 in my series about a fully freeware APEX installation: Information has been taken from The Oracle Install guidelines http://eelzinga.wordpress.com/2009/07/04/oracle-fusion-middleware-11g-ofm11g-on-centos-5/ Shut down EPG The EPG is still running. To shut it down, open SQL*plus:conn conn system execute dbms_xdb.sethttpport(0); exit Prerequisits Make sure your system has enough memory (2 Gigs or more) We … Read more

This is part 3 of my series on a fully freeware APEX environment on CentOS: This post consists of 3 parts: Install Java Glassfish preparations Install GlassFish Configure Glassfish (part 3a) Information has been taken from: http://www.scribd.com/doc/19252518/StepbyStep-Install-Guide-Sun-GlassFish-Enterprise-Server-v3-on-Linux (glassfish part) http://bhapca.blogspot.com/2009/05/how-to-install-glassfish-on-centos-and.html (java part) Here we go… Install Java CentOS allready comes with java pre-installed: /usr/bin/java -> … Read more

In this post we’ll configure the GlassFish 3 server that we installed in the previous post. Information has been aggregated from different blogs: http://www.davidghedini.com/pg/entry/install_glassfish_3_1_on http://bhapca.blogspot.com/2009/05/how-to-install-glassfish-on-centos-and.html The APEX Listener Installation guide (pdf) Apex & Apex listener download Apex and the listener should be downloaded now. Now we start the admin console and mkdir -p $ORACLE_BASE/product/1.1.2/apxlistener mkdir … Read more

This is post 3 in my series about a fully freeware CentOS Apex environment Configure the APEX Listener Your listener is deployed, but not yet configured. Go to http://localhost:8080/apex/listenerConfigure We must set parameters in three tabs: Connection Username: apex_public_user Password: the password as set earlier for this user Connection Type: Basic Hostname: localhost Port: 1521 … Read more

This is part two of my series regarding a fully freeware APEX setup. Post 1 coveres the installation of Oracle XE 11 beta on CentOS 5 Shut Down Apex-EPG Log in as system into the XE database using SQL*plus. We must close the EPG within the database, because Tomcat is going to use the same … Read more

In my effort to create a fully free APEX environment this post is step 1: Install CentOS-5 and Oracle XE 11g. This series will consist of a number of posts: Install CentOS-5 linux (post 1) Install Oracle XE 11g beta (post 1) Webserver choices EPG (post 1) TomCat (post 2) Configuring the APEX Listener (post … Read more

Nothing to do with APEX, but I really don’t want to forget this. As you might know, I’m a big fan of the command prompt. I’ve been using 4DOS/4NT/Take Command for years. These products are sold by a company called JP Software. But now they also have a free-ware product, which suffices for most of … Read more

Please imagine the following: You started out with apex. And because it was the easiest installation scheme (apart from copying the ready-made virtual machine offered by Oracle free-of-charge ;-), you used the EPG-installation scenario. Lets suppose that by now you have gained a bit of experience and you want to use a proper webserver to … Read more