Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping Oracle Datafile in a different server

Darren_43
Occasional Contributor

Mapping Oracle Datafile in a different server

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

6 REPLIES
Jean-Luc Oudart
Honored Contributor

Re: Mapping Oracle Datafile in a different server

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
fiat lux
Steven E. Protter
Exalted Contributor

Re: Mapping Oracle Datafile in a different server

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Alzhy
Honored Contributor

Re: Mapping Oracle Datafile in a different server

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..
Hakuna Matata.
T G Manikandan
Honored Contributor

Re: Mapping Oracle Datafile in a different server

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
Honored Contributor

Re: Mapping Oracle Datafile in a different server

hi,
-
I agree with TG - Performance can be a real issue, although this can be done.
-
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Graham Cameron_1
Honored Contributor

Re: Mapping Oracle Datafile in a different server

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
Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done.