Oracle 48

I have been trying to import a private key into ConnectBot for Android.
The key I’m using is working fine when using Putty, but does not work for ConnectBot.
It’s a server side generated key and protected with a password using Puttygen.
To make it work for ConnectBot, you need to have a OpenSSH version of this file.
Luckily one can also use Puttygen to create an OpenSSH key.

In Puttygen:

1. Load the private key
2. Enter passphrase if applicable
3. Goto [Conversions] -> [Export OpenSSH key] and export

Now find a way to get this OpenSSH key to your Android /sdcard (root) folder.

In Connectbot:

1. [Menu] -> [Manage Pubkeys]
2. [Menu] -> [Import]
3. Choose the OpenSSH key from /sdcard
4. Click the red lock icon to load the key into memory
5. Enter passphrase/password if applicable
6. (Disconnect current session)
7. Connect!

You don’t assign a private key to a connection, but ConnectBot will just try any loaded key instead.

Cheers!

In this blog post I will talk about the basic workings of Automatic Undo Management.

The scope is Automatic Undo Management used in 10g and 11g, but has to be explicitly set for 9i (UNDO_MANAGEMENT = AUTO). Manual Undo Management is out of scope for this blog.

The Undo tablespace is a normal tablespace like any other, but only Oracle is controlling what is happening inside it.

Undo something

The Undo tablespace is used for several features: ROLLBACK, READ CONSISTENCY and FLASHBACK technology.

[Read the rest of this entry...]

I have been moving sites and urls around and found this page to be very handy to implement friendly http 301 redirects.

http://www.webconfs.com/how-to-redirect-a-webpage.php

Cheers!

This HTTPS via utl_http using orapki recipe is prepared with certificates and the orapki tool having some sweet and spicy taste. You may also use the Oracle Wallet manager instead of using orapki but for Oracle RDBMS you will need to have Enterprise Edition and Advanced Security pack licenses.

[Read the rest of this entry...]

Installing the Oracle Instant Client will save you 600 megabyes compared to the ‘full’ Oracle Client.

Installation steps:

1. Download Basic Package
2. Unzip
3. Set path (and TNS_ADMIN !)
4. Extend with SQL*Plus Package (optional)
5. Start the application

Read full article here: Whiteblog – Installing the Oracle Instant Client.

Happy consulting!

Have a look at my Whitehorses Blog where I will explain in more detail.

Final conclusion (on one line):

CustomLog "|<midtier>\Apache\Apache\bin\rotatelogs logs\ssl_request_log 43200" "%t %... %b"

Happy consulting!

They have finally arrived, the Windows 64 and 32 bit versions of Oracle 11gR2.

Download Oracle Database 11g Release 2 for Windows

The 64 bit version was released a bit earlier, so I was hoping the 32 bit version would not come… Why do we want the 32 bit versions? Older systems? Ancient systems! Why…?!

Now I don’t have an excuse to update my almost 10 years old Windows XP OS (running on 64bit hardware) to a much nicer Windows 7 64 bit. The only excuse now is that I could use 600+ megs of memory… enough to run that XP OS virtually!

In Oracle 11g, the one who is calling a remote site needs to get access to that site. This is done via the Access Control List.

I have written a blog about this error at my Whitehorses Blog: Oracle 11g: Access Control List and ORA-24247.

Happy consulting!

Today I had to babysit a demo machine I set-up for a proof of concept. All went well, as I expected.

A two gigabyte RAM Linux machine with SOA/BPEL 11g, two WebLogic 10.3 domains extended with ADF and Apex XE running on it. It kept running, but at one point is had only 30 megs of memory left!

Check out ‘Extending your WebLogic standalone environment with ADF runtime libraries‘ for more information about setting up the WebLogic environment with ADF.

When moving/deleting the listener.log, I used to stop and start the listener and move/delete the listener in between the actions.
This method has a big inconvenience: users can not connect to the database for a few seconds…
What I never knew was that the listener could be told to stop and start logging and take the appropriate action in between.

[Read the rest of this entry...]