I can't imagine why you would want your database files located
in AFS. We keep Oracle binary and support files in AFS, and found
that the AFS lock rights were neccessary on some directories. These are
for client use only, however. Our server software and the database files
themselves are all kept local. The Oracle networking layer is adequate
to serve data to remote clients. I can't think of any justification for
putting the data files in AFS. Oracle does it's own row locking
internally, and file system record locking just adds another layer of
confusion. This is the same issue as putting user mailboxes
and Usenet articles in AFS - there are better ways to do it.
- Woody Kellum
Has someone attempted to use Oracle (latest versions) for databases
physically located in AFS?
We're currently using Empress, who agreed to make changes required
for successful use with AFS. The changes were related to providing
a record locking layer disassociated with the actual physical
file system. [Required since AFS only provides file locking]
Oracle's popularity is generating quite a bit of demand and we'd
like to address these requests somehow. I've queried Oracle relative
to their position on AFS and thus far I've received such enlightened
responses as "I don't know what AFS is, so we must not support it."
I'd would be satfisied if they just gave me an clear answer of "No",
but the responses thus far boil down to "I don't know."
If anyone has experience dealing with Oracle/AFS issues or any
other major DB provider I would appreciate hearing about those
solutions.
Thanks,
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ John L. Grant + [EMAIL PROTECTED] +
+ Faculty Associate for Engineering Computing + 704-547-4153 +
+ UNCC College of Engineering + 704-547-2352 FAX +
+ Charlotte, NC 28223 + Stress? What Stress? +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
