{"id":1102,"date":"2006-10-08T12:00:00","date_gmt":"2006-10-08T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1102"},"modified":"2006-10-08T12:00:00","modified_gmt":"2006-10-08T12:00:00","slug":"10gr2-on-solaris-10","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2006\/10\/08\/10gr2-on-solaris-10\/","title":{"rendered":"10gR2 on Solaris 10"},"content":{"rendered":"

I was surprised to realise that it’s nearly 7 months since I bemoaned the lack of availability of 10gR2 on Solaris 10 (x86)<\/a>. Well, it’s been out a few weeks now and I’ve been waiting since then for a free weekend to install it on the ISP4400. One of the advantages of being busy the past few weekends was that it gave Howard Rogers the chance to produce a couple of excellent articles. The first is a guide to the Solaris 10 installation<\/a>, the second covering the Oracle install<\/a> on top.<\/p>\n

Having worked my way through the articles, I can vouch for their usefullness and accuracy. I probably wouldn’t stick the Oracle software on the root filesystem, which I’ve mentioned to Howard, but everything else is spot-on. Thoroughly recommended.<\/p>\n

With the time it saved me through not messing around, I was able to get straight onto creating a ZFS<\/a> pool without delay. How easy is this?<\/p>\n

# zpool create oradata c0t1d0 c0t2d0 c0t3d0 c0t4d0# zpool listNAME                    SIZE    USED   AVAIL    CAP  HEALTH   ALTROOToradata                 136G   1.10G    135G     0%  ONLINE   -# df -k oradataFilesystem            kbytes    used   avail capacity  Mounted onoradata            140378112      24 140378033     1%    \/oradata# mkdir \/oradata\/TEST1020# chown oracle:dba \/oradata\/TEST1020 <\/code><\/pre>\n
Of course, it might perform like a complete dog, but that’s what I’m hoping to find out one way or the other 😉<\/p>\n
Looks like a damn interesting blog all round, actually – added to my Blog-roll.<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"
I was surprised to realise that it’s nearly 7 months since I bemoaned the lack of availability of 10gR2 on Solaris 10 (x86). Well, it’s been out a few weeks now and I’ve been waiting since then for a free weekend to install it on the ISP4400. One of the advantages of being busy the… Continue reading 10gR2 on Solaris 10<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1102","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":831,"url":"http:\/\/orcldoug.com\/blog\/2006\/03\/19\/solaris-10-and-oracle-10g\/","url_meta":{"origin":1102,"position":0},"title":"Solaris 10 and Oracle 10g","date":"March 19, 2006","format":false,"excerpt":"Well that was an interesting if not too productive weekend.I'd been keen to install Solaris 10 on the ISP4400, which went very well. These things are always time-consuming but I was interleaving it with normal human activity to make up for my recent mental absence from those around me. So\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1101,"url":"http:\/\/orcldoug.com\/blog\/2006\/10\/07\/supporting-scotland\/","url_meta":{"origin":1102,"position":1},"title":"Supporting Scotland","date":"October 7, 2006","format":false,"excerpt":"I've spent all morning installing Solaris 10 and Oracle 10gR2 on the ISP4400 and configured my first ZFS filesystem. I'll blog about that later, but I had to get this one out of the way before Scotland play France at football at five o'clock.This is from an interview with Walter\u2026","rel":"","context":"With 8 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":895,"url":"http:\/\/orcldoug.com\/blog\/2005\/12\/07\/oracle-enterprise-manager-10gr2\/","url_meta":{"origin":1102,"position":2},"title":"Oracle Enterprise Manager 10gR2","date":"December 7, 2005","format":false,"excerpt":"First of all, let me be clear that I'm not a fan of GUI tools. That's not based on a misguided macho opinion that somehow you need to be able to struggle with a command line interface to prove that you're a good DBA but because :- I'm a contractor\u2026","rel":"","context":"With 9 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1212,"url":"http:\/\/orcldoug.com\/blog\/2007\/02\/23\/orasrp\/","url_meta":{"origin":1102,"position":3},"title":"OraSRP","date":"February 23, 2007","format":false,"excerpt":"While working on the PX paper for Hotsos, I've been trying to show the same issue using different tools that people might have available to them and struggled to get OraSRP working on Solaris 10. From digging around the net I started to realised that the Python distribution included in\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1017,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/13\/alter-table-move-and-table-stats\/","url_meta":{"origin":1102,"position":4},"title":"alter table … move and table stats","date":"July 13, 2006","format":false,"excerpt":"Howard Rogers left a comment on my last blog, showing an example of using alter table ... move on a 10gR2 database on Linux. In his example, unlike mine, the table rebuild did not nullify the table's statistics. I admit I was surprised myself when I ran my example yesterday\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1107,"url":"http:\/\/orcldoug.com\/blog\/2006\/10\/22\/dtrace\/","url_meta":{"origin":1102,"position":5},"title":"DTrace","date":"October 22, 2006","format":false,"excerpt":"I've certainly hinted at it before, but if there's one good reason for Oracle techies to run Solaris 10 (or OpenSolaris) on their home equipment, it's this. As far as I'm aware, there is nothing available on Linux which is within a million miles of DTrace in helping you see\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1102","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1102"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1102\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1102"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1102"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1102"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Updated later … Here’s an interesting link<\/a> that seems to confirm what I expected, that ZFS is not the best performing solution at the moment. (Well, certainly not for OLTP workloads) It confirms the earliest tests i’ve done too.<\/p>\n