Pythian Group

That’s right folks! Playing with latest beta of free Oracle Database 11g Express Edition couldn’t be any easier than that. If you are using Amazon EC2, you can have a fully working image with 64 bit Oracle Linux and Oracle 11g XE database running in a matter of few clicks and a minute to get the instance to boot.

Image — ami-ae37c8c7
Name — pythian-oel-5.6-64bit-Oracle11gXE-beta-v4
Source — 040959880140/pythian-oel-5.6-64bit-Oracle11gXE-beta-v4

You can find it in public images and at this point it’s only in US East region.

If you never used Amazon EC2 before, see detailed step-by-step guide on how to get started with EC2 on the example of this 11g XE image.

This image works great with Amazon EC2 Micro instance and I configured it specifically for Micro instance. Micro instance costs you only 2 cents per hour to run or even less than 1 cent if you are using spot instance requests (and there is free offer for new AWS users as Niall mentioned in the comments).

So what’s there?

• Oracle Enterprise Linux 5.6 64 bit (I started with 5.5 and updated to the latest)
• Oracle Database 11g XE Beta (oracle-xe-11.2.0-0.5.x86_64)
• Database created and configured to start on boot
• APEX coming with 11g XE configured on port 8080 and remote access enabled
• 10GB root volume on EBS with 5+GB free for user data. You could store up to 11GB of data in 11g XE and there is a way to grow volumes if you need but for more critical use then playground, I’d allocate separate EBS volumes anyway.

Read the rest of this entry . . .

I was recently installing one APEX application and needed to upload a bunch of images. APEX was configured to use EGP (Embedded PL/SQL Gateway) so traditional options were to configure FTP or WebDAV but I’d rather not open these services on production environment.

After searching for the solution on the Internet, I surprisingly realized that there is none. At least, nothing I could find easily. Our resident APEX expert, Alex Fatkulin, pointed me to the installation process and suggested that there is a simple way to do that using a single PL/SQL call.

It turned out that it was more than a single PL/SQL call involved but nothing too difficult.

What you need is to create the hierarchy of files and directories that you want to upload (images or not – doesn’t matter). Then you create an XML file imagelist.xml listing required directories and files to upload.

Here is the example:

imagelist.xml
image1.png
logo/pythian.png

The content of imagelist.xml:

<upload>
    <directories>
        <directory>logo</directory>
    </directories>
    <files>
        <file>/image1.png</file>
        <file>/logo/pythian.png</file>
    </files>
</upload>

Read the rest of this entry . . .

Update 24-06-2010: Peter de Vaal reported that these instructions work without changes for APEX 4.0 as well. Great news!

Few days ago, I have put together the Quick Install Guide for Oracle 10g Release 2 on Mac OS X Leopard (Intel). I did mention that it would be cool to get APEX working as well but, apparently, APEX isn’t supposed to be running on Oracle 10g Release 2 Database on OS X as few people pointed our on the blogs.

Well, the release notes says that Oracle Application Express is not supported and I would imagine that it’s because Oracle HTTP Server is not supported either. I’m not a frequent user of APEX but I know that APEX 3.2 is not supposed to be configured in Oracle 10g Database using Embedded PL/SQL Gateway. However, looks like few people did manage to run APEX on 10g using Embedded PL/SQL Gateway. For example, Jeff Kemp has some APEX on 10g hints that I perused.

Long story short, I was able to install APEX successfully using the native Mac OS X Oracle 10g Database and here is how…
Read the rest of this entry . . .

The second, and the last, day of AUSOUG 2007 in Melbourne is over. Earlier today I had great presentation as I already blogged about. I had a quick chance to peak into Steve Lemme’s presentation on CA approach for solving an IT management dilemma. The only reason I was interested in it is because one of our clients is using CA Unicenter and looking to move away from it so I wanted to make sure that this is right (I’m quite sure myself anyway but it’s just a DBA perspective).

I had baked potato for lunch plus a sandwich. After that me and Paul Moen went down for a coffee (thanks to Chris Muir for suggestion of a better place). Oh yes – I’ve finally had a pleasure to meet Chris Muir.

Instead of keynote and the following presentation, I paid a visit to exhibitors and spoke to practically every exhibitor. It turned out that some of them knew or heard about Pythian which was quite pleasing to hear. I also found out that Han Xie (I’ve met him yesterday first time during follow up on my RAC presentation) from Dialog Information Technology had only come because of my presentation! As soon as he saw my name on the agenda few days ago, he requested his managers to send him over. This was a very pleasing compliment — thanks Han.

I sat on presentation about Web 2.0 interface with APEX but, frankly, I was almost falling asleep as the result of little rest last night and extremely monotonic speaking manner of the speaker. I also expected to be presented on how actually do that in APEX instead of some pretty much web 2.0 propaganda and demonstration of few cool widgets. Widgets were very cool indeed but it was definitely not my expectations. Anyway, what am I, DBA, supposed to know about development?

The last session for me was The Great Oracle Development Tools Debate with panel speakers (no need for names ;) being proponents of:
- Oracle JDeveloper
- Oracle Forms
- Oracle APEX
- Oracle Fusion as the whole concept

No one from .Net and only one person from the audience admitted he is using it. Strange, I quite liked .Net when I used it few years ago. If only it could run on non-windows platforms.

Anyway, the whole audience was pretty much concerned about discontinued Forms support (2014 was the year given by Lynne Munsinger from Oracle). So it was clear that new projects don’t start in Forms nowadays. But the choice between APEX and J2EE based platform was difficult. The audience was very cautious about Java and Fusion while optimistic on APEX. However, concerned that APEX won’t fit enterprise solutions bill, many are waiting on Java platform to become enough stable and reliable enough to build applications that can be supported for years to come instead of changing technology every year or so.

From my point of view it all boils down to when the business wants to spend the money — in advance with Java based Fusion and have a risk of loosing everything or slowly as the progress using APEX and having results right away. For me the choice is clear but modern architects and technologists might not agree with me.

Closing was quick — Babette didn’t win anything even though I sacrificed my chance for her (read that I was too lazy to stamp the paper at every exhibitor). I’m satisfied with the conference. I met many interesting people and discussed about how people work here in Australia and how the business is organized.

I’m going to the observation deck now to watch the sunset and I must harry not to miss it. I’m leaving tomorrow morning and will be in Ottawa on Wednesday night after the long journey (I don’t want to think about it now).