On Fri, 2008-02-29 at 10:38 +1100, Joel Heenan wrote: > Why don't you run the database on a big fat database server then have > all the applications connect to it via oracle listeners through > TCP/IP. That would be the standard solution to this problem.
hmmm, the more I look into this application (Mincom Minescape) it seems that may in fact be what it does, it has a "Design File Server". > This solution is strange because > > - you may hit issues because not all FS locking commands will be > supported > - running multiple database instances connecting to the same DB > files is normally done in an Oracle RAC configuration. You don't run > Oracle on the app servers you run it on database servers and use a > shared filesystem like ASM or OCFS2 normally connected to the DB files > over a SAN. Network filesystems are not normally used for database > files. I am sure you are correct, I don't have any experience with Oracle or large, distributed DB installations. > Is there a good reason you need more than one oracle instance? No! I think I phrase the question incorrectly to start with. If I just want one instance of the Oracle DB (the Design File Server) can I run it installed in a VM and have it's DB files stored on Samba shared to it from the host OS? -- Simon Wong <[EMAIL PROTECTED]> -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
