topic Re: Mapping Oracle Datafile in a different server in Operating System - HP-UX

Mapping Oracle Datafile in a different server

Darren_43 — Tue, 14 Oct 2003 11:53:14 GMT

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

Re: Mapping Oracle Datafile in a different server

Jean-Luc Oudart — Tue, 14 Oct 2003 12:01:09 GMT

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

Re: Mapping Oracle Datafile in a different server

Steven E. Protter — Tue, 14 Oct 2003 12:01:35 GMT

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

Re: Mapping Oracle Datafile in a different server

Alzhy — Tue, 14 Oct 2003 12:31:49 GMT

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..

Re: Mapping Oracle Datafile in a different server

T G Manikandan — Tue, 14 Oct 2003 22:17:47 GMT

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.

Re: Mapping Oracle Datafile in a different server

Yogeeraj_1 — Wed, 15 Oct 2003 00:04:27 GMT

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

Re: Mapping Oracle Datafile in a different server

Graham Cameron_1 — Wed, 15 Oct 2003 02:26:10 GMT

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