On Fri, Feb 29, 2008 at 10:08 AM, Simon Wong <[EMAIL PROTECTED]> wrote:
> On Thu, 2008-02-28 at 18:04 +0900, Adrian Chadd wrote: > > > Can anyone confirm whether Oracle 9i running under Windows will work > if > > > it's DB files are stored on a samba share? > > > > > > I have to try and run Mincom's Minescape under Windows but want the > data > > > and DB shared via Samba. > > > > .. why do you think this would be a good idea? > > because the instance of Windows will be running under VMware server (or > Workstation) and I like to keep the data outside the VM where it can > also be shared with other instances of the app. > > What are you thinking? > Simon, 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. 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. Is there a good reason you need more than one oracle instance? Joel -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
