Optimal Flexible Architecture<\/a> 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.<\/p>\n\/myapp1\/oradata\/\/myapp1\/oraindex\/\/myapp2\/oradata\/\/myapp2\/oraindex\/<\/code><\/pre>\n<\/p>\nbut I’m still not convinced. If people ever failed over individual applications then it might prove useful, but I don’t see that as a common requirement and it does create lots of mini ‘containers’ for each application. The up-side of that is that storage is allocated on an application-by-application basis. The down-side is that it’s less flexible.<\/p>\n
But even if there is an argument for that, I’m still dumb-founded by Oracle’s decision to make the default Oracle 10g installation create an admin subdirectory like this<\/p>\n
[oracle@ISP4400 ~]$ cd $ORACLE_HOME[oracle@ISP4400 db_1]$ pwd\/home\/oracle\/product\/10.2.0\/db_1[oracle@ISP4400 db_1]$ cd admin[oracle@ISP4400 admin]$ ls -ltratotal 32drwxr-x--- 57 oracle dba 4096 Apr 2 23:38 ..drwxr-xr-x 8 oracle dba 4096 Apr 11 21:53 TEST1020drwxr-xr-x 8 oracle dba 4096 May 22 20:28 RAID1020drwxr-x--- 4 oracle dba 4096 Aug 4 21:38 .<\/code><\/pre>\nWhy on earth would you have admin under $ORACLE_HOME? So that you have to move your site-specific and instance-specific files to different directories every time you perform a software upgrade? Have these people read<\/b> the OFA documents?<\/p>\n
Please, please, someone convince me I’m wrong about this, because it looks like a complete dog’s breakfast to me and is so wide of my understanding of OFA that I have to assume I’m missing some crucial reason for this change.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 over individual… Continue reading 10g Default Installation and 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-1063","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":973,"url":"http:\/\/orcldoug.com\/blog\/2005\/06\/10\/the-importance-of-ofa\/","url_meta":{"origin":1063,"position":0},"title":"The importance of OFA","date":"June 10, 2005","format":false,"excerpt":"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\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1102,"url":"http:\/\/orcldoug.com\/blog\/2006\/10\/08\/10gr2-on-solaris-10\/","url_meta":{"origin":1063,"position":1},"title":"10gR2 on Solaris 10","date":"October 8, 2006","format":false,"excerpt":"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\u2026","rel":"","context":"With 7 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1062,"url":"http:\/\/orcldoug.com\/blog\/2006\/08\/21\/resumable-storage-allocation\/","url_meta":{"origin":1063,"position":2},"title":"Resumable Storage Allocation","date":"August 21, 2006","format":false,"excerpt":"At the moment I'm writing a short 9i\/10g New Features seminar for the developers at work. The idea is to run through lots of new features very quickly to see if anything lights their candle and they can then go off and investigate further afterwards.It occurred to me while I\u2026","rel":"","context":"With 9 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1386,"url":"http:\/\/orcldoug.com\/blog\/2008\/02\/27\/optimiser-upgrading-from-9i-to-10g\/","url_meta":{"origin":1063,"position":3},"title":"Optimiser – Upgrading from 9i to 10g","date":"February 27, 2008","format":false,"excerpt":"On the one hand, I regret the fact I seem to be posting a lot of links to other people's work at the moment but I couldn't let this one by, if only for those who don't use OraNA or the like and might miss it.The one consistent message I\u2026","rel":"","context":"With 15 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":831,"url":"http:\/\/orcldoug.com\/blog\/2006\/03\/19\/solaris-10-and-oracle-10g\/","url_meta":{"origin":1063,"position":4},"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":1417,"url":"http:\/\/orcldoug.com\/blog\/2008\/06\/08\/real-application-testing-and-more-relinking\/","url_meta":{"origin":1063,"position":5},"title":"Real Application Testing and more Relinking","date":"June 8, 2008","format":false,"excerpt":"I'd been thinking of blogging about the appearance of Real Application Testing in 10.2.0.4 since I noticed it post-upgrade, just before the course in Prague. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsIt looked like a\u2026","rel":"","context":"With 9 comments","img":{"alt_text":"","src":"\/serendipity\/uploads\/xRAT_7.png.pagespeed.ic.3MsqSFp_gp.png","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1063","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=1063"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1063\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1063"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1063"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}