Thursday, March 5, 2009

Oracle SqlPlus Error

A remedy to the following error:
ORA-01034: Oracle not available
...shared memory realm does not exist
...

Execute the following commands:
sqlplus /nolog
connect / as sysdba
startup

I have found Oracle on Ubuntu to be a bit hacky. I've been tweaking configuration each day to get a stable instance running. This wasn't a clean install and Oracle states that Ubuntu is an unsupported os. However, with a bit of tweaking and using the directions I provided in a previous post, one can get a fairly stable Oracle instance running.

Thursday, February 26, 2009

Testing CouchDB

If you made it through the installation process and successfully started CouchDB then you could use your browser to get familiar with CouchDB or you could use curl.

I used curl because it is command line driven, fast and gets the job done.

Test access:
curl http://localhost:5984/

A response of {"couchdb": "Welcome", "version": "0.8.0-incubating"} will indicate we are ready.

If you do not get this response then check to make sure Couchdb is running.

You can also go to the browser to double check: http://localhost:5984.

Creating a database:
curl -X PUT http://localhost:5984/mydemodb/

A repsonse of {"ok",true} will indicate that the database was created. If you get an illegal name error then check your database name. Is it all lower case, no spaces, no special characters?

Deleting a database:
curl -X DELETE http://localhost:5984/mydemodb/

Adding data to the database:

Presuming a database was created, create a testdata.dat file with your data. Here is an example:

{
"field1": "value1",
"field2": "value2"
}

Enter the command to save the data:
curl -T testdata.dat -X POST http://localhost:5984/mydemodb/

With a response of:
{"ok": true, "id": "...", "rev":"..."}

Tuesday, February 17, 2009

Installing Oracle on Ubuntu

Ubuntu isn't a supported OS for Oracle so the installation process can be a bit of a challenge. However, I have found a fairly decent reference for exactly what to tweak in order to successfully install Oracle.

This article provides step by step instruction on installing Oracle on Ubuntu. The only additional notes I would add are the following:

1. You will need to export your display before installing.
2. Ignore the glib errors that occur during the installation process.

Enjoy....

Thursday, February 12, 2009

CouchDB

If you are struggling with the installation of CouchDB on Ubuntu, particularly the dreaded SpiderMonkey issue. The process outlined at http://barkingiguana.com/2008/06/28/installing-couchdb-080-on-ubuntu-804 worked perfectly. Blow away your current CouchDB directory first, then follow the process outlined at http://barkingiguana.com/2008/06/28/installing-couchdb-080-on-ubuntu-804 and you will quickly discover success.