Mapping Oracle Datafile in a different server

[Darren_43]

Hi,

Is it possible to have a tablespace or datafile(s) on a different machine than the one running the instance that has rest of the tablespaces/datafiles? We are having Oracle 9i on a HP 9000/800 server running HP 11x and trying to use free hard disk space from another server running HP 11x.

Thank you for your valuable input.

With Regards,
Darren

[Jean-Luc Oudart]

You may mount a remote file system with NFS but personally I would not go near NFS for a Live database datafile

Rgds,
Jean-Luc

[Steven E. Protter]

If you don't mind a performance penalty, you can export the filesystem with NFS or do a CIFS/9000 mount to make the filesystem available on the local system.

Then its just a filesystem and you are all set.

But Oracle 9i uses raw disk for the datafiles right?

There should be a way to use LVM or pvlinks to make that space available on the other system. Those disks would have to be OWNED by the original system.

Are the systems next to each other? Could you possibily take these disks out of lvm on the second server and connect them via SCSI to a SCSI card on the first system? If they're not in use this might work. There are compatability issues with this approach.

SEP

[Alzhy]

Darren,
If you are eying to use an NFS mount froma different server for your Oracle storage - then yes it can be done but may not be "totally" supported by Oracle. Oracle supports NFS storage only in the context of Filers or NAS Applicances certified by them (ie. NetApps, EMC Filers, etc..). If the datafiles you plan to store ar not really that IO bandwidth hungry - then go ahead. You may want to use UDP instead for your NFS mounts. If you have GigE infrastructure -- then you certainly have the advantage of a larger pipe than traditional SCSI..

[T G Manikandan]

It depends on the criticallity of the database and performance of the database.

If you are to use a frontend application which would get data from the database then you are killed,the brower will wait and wait for queries.

Using NFS you can use another server hard disk to store datafiles.

I would strongly disagree with that way.It is a very bad idea to save some money.
Get new hard disks,it will definitely be useful for future project resource allocations.

[Yogeeraj_1]

hi,
-
I agree with TG - Performance can be a real issue, although this can be done.
-
regards
Yogeeraj

[Graham Cameron_1]

Darren

If the above don't put you off NFS, see the following thread:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=230057
My advice - move the disk to your oracle server and have all database files local.
-- Graham