Sunday Aug 15, 2004

Yikes!

Got called out this weekend to help out on an Oracle problem down in Athens. Apparently theres some sort of sporting event going on...

Wednesday Jul 21, 2004

Oracle on Network Attached Storage + blue boxin'


so it's not the most thrilling subject, but I found this document on BigAdmin a while ago, and just got around to reading it. The document contains a lot of good tips on setting up Oracle on NAS (Particularly NetApps). The impressive thing I found was that the engineers use real measured data to qualify much of what they recommend. The authors are from Sun's performance group, and from NetApp themselves. Check it out for general Solaris/Oracle/NFS configuration guidelines also.

And by way of apology for such a dry and boring blog entry, please enjoy this gratuitous picture of an original Woz designed blue box I found at the Coumputer History museum. Nice.

Monday Jul 19, 2004

Good news for bad databases...

I just closed a long running escalation whereby old oracle connections would appear to hang, and new ones could not be established. A truss of a new sqlplus session showed that the oracle process was sleeping on a semop system call.
sqlplus/1:      read(10, 0x10024FF66, 2064)     (sleeping...)\^M
oracle/1:       semop(1245185, 0xFFFFFFFF7FFFAF9C, 1) (sleeping...)\^M
sqlplus/1:      556.9328            Received signal #2, SIGINT, in read() 

\^\^\^Here we see the process is eventually killed with CTRL-C
Anyhow the fix was to apply Oracle update 9.2.0.5 (9205) which according to my Oracle contacts contains around 1,100 fixes. 9.2.0.4 contained in the region of 800 compared to 9.2.0.3 Cor blimey, what a whopper .
About

gjl

Search

Categories
Archives
« April 2014
MonTueWedThuFriSatSun
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
    
       
Today