?

Log in

No account? Create an account
Computers

Quick oracle Rant.

Yes, I am once again having to try and convince oracle to behave, and once again it doesn't quite want to do so.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-27123: unable to attach to shared memory segment
Linux Error: 22: Invalid argument
Additional information: 1
Additional information: 5898253
SQL> startup;
ORACLE instance started.

Total System Global Area 406847488 bytes
Fixed Size 779080 bytes
Variable Size 204217528 bytes
Database Buffers 201326592 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.


Amusingly it would appear the the installer is making the same mistake.

In other news, hopefully I should be getting internet access at home in the near future (dat from BT is apparently Saturday....)

Plug : ewx's with-readline makes Oracle's SQL Plus almost useable :)

Comments

Don't talk to me about Oracle's SQL Plus. It's as close to unusable as you can get. Minq's DbVisualizer is your friend...
I like http://henplus.sourceforge.net/ as an alternative command line SQL client, especially given that I switch between Oracle and Sybase all the time.

If you've got DBD::Oracle setup, http://dbishell.sourceforge.net/ is probably also worth a look.
fireworks

August 2010

S M T W T F S
1234567
891011121314
15161718192021
22232425262728
293031    
Powered by LiveJournal.com