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.