- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Mapping Oracle Datafile in a different server
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2003 04:53 AM
тАО10-14-2003 04:53 AM
Mapping Oracle Datafile in a different server
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2003 05:01 AM
тАО10-14-2003 05:01 AM
Re: Mapping Oracle Datafile in a different server
Rgds,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2003 05:01 AM
тАО10-14-2003 05:01 AM
Re: Mapping Oracle Datafile in a different server
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2003 05:31 AM
тАО10-14-2003 05:31 AM
Re: Mapping Oracle Datafile in a different server
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..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2003 03:17 PM
тАО10-14-2003 03:17 PM
Re: Mapping Oracle Datafile in a different server
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2003 05:04 PM
тАО10-14-2003 05:04 PM
Re: Mapping Oracle Datafile in a different server
-
I agree with TG - Performance can be a real issue, although this can be done.
-
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-14-2003 07:26 PM
тАО10-14-2003 07:26 PM
Re: Mapping Oracle Datafile in a different server
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