Uncategorized – warp11

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:

Fully freeware APEX environment VII: Oracle HTTP server (configuration)

25 May 2011 by Richard Martens

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

Fully freeware APEX environment VI: Oracle HTTP server (installation)

23 May 2011 by Richard Martens

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

Fully freeware APEX environment IV: GlassFish Installation

23 May 2011 by Richard Martens

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

Fully freeware APEX environment V: Configure GlassFish

23 May 2011 by Richard Martens

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

Fully freeware APEX environment III: The APEX listener

23 May 2011 by Richard Martens

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