Where no man has gone before
Richard Martens While developing the application for my kscope15 presentation I discovered that my Oracle XE database is unable to handle the certificate for Linked-in. This has to do with the algorithm used to sign the Linked-in certificate. Oracle XE 11 has a bug that prevents it from handling the certificate correctly. The solution lies in creating … Read more
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