system admin guides<\/a>. (It’s in different books on different versions and operating system ports).<\/p>\nOtherwise you get a variation on OFA that’s been picked up by looking at an OFA directory structure and modifying it slightly in ways that totally miss the point. Here are some filesystems I\ufffdve come across recently<\/p>\n
\/myapp1\/oradata\/\/myapp1\/oraindex\/\/myapp2\/oradata\/\/myapp2\/oraindex\/<\/pre>\nWhich cause a few problems :-<\/p>\n
1) We have large numbers of discrete filesystems for different applications. So if one application starts to run out of space, we might have free space kicking around on other applications\ufffd filesystems, but it’s unusable!<\/p>\n
2) So people start putting files in inappropriate directories e.g. take an myapp1-related datafile and put it in \/myapp2\/oradata. Which will, of course end up being deleted by some enthusiastic sys admin when the other application reaches its end of life.<\/p>\n
3) If we suddenly find that we need more index tablespace space and less data tablespace space, do we either a) take everything offline so we can steal from oradata to give to oraindex; or b) stick an index tablespace datafile in the oradata filesystem? If it’s b), why didn’t we just call them both oradata in the first place?!?!?<\/p>\n
Then it gets worse. <\/p>\n
Under the \/myapp1\/oradata mount-point, we have environment-specific directories <\/p>\n
dev test support<\/pre>\nBut the relevant instance names are (made these up) <\/p>\n
DOUGDEV DOUGTST DOUGSUPP<\/pre>\nWhat exactly was the point in using anything but the SIDs to identify which database the files belonged to?<\/p>\n
Trust me, there’s loads of this stuff. In 2005. I worked it out – the first OFA paper I saw was in 1993. How can people call themselves DBAs when they still can’t get it after 12 years?!!?I think I need a lie down …<\/p>\n","protected":false},"excerpt":{"rendered":"
When discussing Cary Millsap and his work (for example during this week’s user group presentation or when teaching courses), I’ve often said that I wish he was more widely known for one of my favourite pieces of work – the various Optimal Flexible Architecture documents and standards. I think one of the benefits of having… Continue reading The importance of OFA<\/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-973","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1063,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/21\/10g-default-installation-and-ofa\/","url_meta":{"origin":973,"position":0},"title":"10g Default Installation and OFA","date":"August 21, 2006","format":false,"excerpt":"or ... 'what's that all about?!?!'Last year, I blogged about some of the variations on Optimal Flexible Architecture that I've seen on my travels. I'm gradually coming round to having the service group for clustered applications as the top directory level (e.g.\/myapp1\/oradata\/\/myapp1\/oraindex\/\/myapp2\/oradata\/\/myapp2\/oraindex\/but I'm still not convinced. If people ever failed\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1310,"url":"http:\/\/orcldoug.com\/blog\/2007\/08\/14\/thats-more-like-it\/","url_meta":{"origin":973,"position":1},"title":"That’s More Like It!","date":"August 14, 2007","format":false,"excerpt":"(and I'm writing this from a positive perspective)Now that the community is over the initial 'Look over, there! It's 11g!!!!', there are some genuinely interesting blogs kicking around. (Maybe we need to give these things a little time?) I'd better only talk about a couple, though, or Dave Edwards will\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1367,"url":"http:\/\/orcldoug.com\/blog\/2007\/12\/08\/ukoug-days-three-and-four\/","url_meta":{"origin":973,"position":2},"title":"UKOUG Days Three and Four","date":"December 8, 2007","format":false,"excerpt":"I was up pretty early on Wednesday to carry on working on my presentation. As I said to someone, once they saw how basic the content was, it would be difficult to see why it takes so long but a lot of it is tweaking with the flow and by\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"\/serendipity\/uploads\/OFA.jpg","width":350,"height":200},"classes":[]},{"id":1406,"url":"http:\/\/orcldoug.com\/blog\/2008\/04\/27\/upcoming-events\/","url_meta":{"origin":973,"position":3},"title":"Upcoming Events","date":"April 27, 2008","format":false,"excerpt":"I'll be presenting at a few events in the next couple of months.30th April - OUG Scotland DBA SIG Meeting.This one is the easiest for me to travel to, being just on the out-skirts of Edinburgh, and is always a well-organised event with a decent agenda, thanks to the local\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1419,"url":"http:\/\/orcldoug.com\/blog\/2008\/06\/10\/more-blogs-2\/","url_meta":{"origin":973,"position":4},"title":"More Blogs","date":"June 10, 2008","format":false,"excerpt":"It's good to see some more people joining in, particularly those I already know and admire.First up is Mark Bobak, who I've met at several conferences and, as you can tell from his first few posts, is likely to have some interesting technical tales to tell.Via Mark's blog-roll, I noticed\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1408,"url":"http:\/\/orcldoug.com\/blog\/2008\/05\/19\/conference-activities\/","url_meta":{"origin":973,"position":5},"title":"Conference Activities","date":"May 19, 2008","format":false,"excerpt":"I should get to bed soon because I have to be up at 4am for my flight to Stockholm (via Copenhagen). Tomorrow (and on Wednesday) I'll be presenting at the Swedish and Finnish Oracle User Groups joint 20th Anniversary event on the good ship (I hope) m\/s Silja Serenade. The\u2026","rel":"","context":"With 2 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/973","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=973"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/973\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=973"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}