- Community Home
- >
- Servers and Operating Systems
- >
- Operating System - OpenVMS
- >
- Oracle10g - Database Files on ODS2 or ODS5
-
-
Categories
- Topics
- Hybrid IT with Cloud
- Mobile & IoT
- IT for Data & Analytics
- Transformation
- Strategy and Technology
- Products
- Cloud
- Integrated Systems
- Networking
- Servers and Operating Systems
- Services
- Storage
- Company
- Events
- Partner Solutions and Certifications
- Welcome
- Welcome
- Announcements
- Tips and Tricks
- Feedback
-
Blogs
- Alliances
- Around the Storage Block
- Behind the scenes @ Labs
- Converged Data Center Infrastructure
- Digital Transformation
- Grounded in the Cloud
- HPE Careers
- HPE Storage Tech Insiders
- Infrastructure Insights
- Inspiring Progress
- Internet of Things (IoT)
- My Learning Certification
- Networking
- OEM Solutions
- Servers: The Right Compute
- Telecom IQ
- Transforming IT
-
Quick Links
- Community
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Contact
- Email us
- Tell us what you think
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Enterprise.nxt
- Marketplace
- Aruba Airheads Community
-
Categories
-
Forums
-
Blogs
-
InformationEnglish
Oracle10g - Database Files on ODS2 or ODS5
SOLVED- 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
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-15-2010 08:06 AM
11-15-2010 08:06 AM
About to upgrade Oracle9i to Oracle10g on an Alpha running VMS8.3
The Question is this:-
Oracle upgrade notes makes it clear that the Oracle10g System files MUST reside on an ODS5 formatted disk.
However they say that the actual Oracle Data Files can reisde on either an ODS2 or ODS5 disk.
Is there any performance issues selecting either one over the other?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-15-2010 08:24 AM
11-15-2010 08:24 AM
Re: Oracle10g - Database Files on ODS2 or ODS5
Re: Oracle10g - Database Files on ODS2 or ODS5
There are no salient differences in performance between ODS-2 and ODS-5, and the volume-level differences between the two are trivial, and the host I/O paths are basically the same for both.
The chief considerations include whether you can keep the stuff that expects ODS-2 operational. If you keep to an ODS-2 subset where that matters, that's usually feasible.
As for performance, you're running Oracle. You'll want to pick ODS-5 for its increased compatibility with newer tools, and you'll likely want to look at Oracle performance.
Though as Stonebraker commented an eon or two ago, all file systems stink as database platforms.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-15-2010 08:31 AM
11-15-2010 08:31 AM
Re: Oracle10g - Database Files on ODS2 or ODS5
Re: Oracle10g - Database Files on ODS2 or ODS5
was thinking of changing our data disks to ODS5 for this upgrade and your answer would seem to back this up
I take it I can simply do a
$ set volume/struture_level=5 dkb100:
$ set volume/struture_level=5 dkb200:
$ set volume/struture_level=5 dkb300:
on the 3 volumes that are currently ODS2
just before I start the upgrade? Obviously after a backup!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-15-2010 08:37 AM
11-15-2010 08:37 AM
SolutionThe SET VOLUME /STRUCT=5 command does almost nothing.
At its core, the command changes a single constant within the storage control block; within an ODS-level data structure.
The "reversion" path is via BACKUP, and BACKUP can "downgrade" ODS-5 to ODS-2. That's a tougher nut, as BACKUP has to rename stuff.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-15-2010 08:39 AM
11-15-2010 08:39 AM
Re: Oracle10g - Database Files on ODS2 or ODS5
Re: Oracle10g - Database Files on ODS2 or ODS5
Seems nice and stright forward!
thank you very much
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
11-15-2010 08:54 AM
11-15-2010 08:54 AM
Re: Oracle10g - Database Files on ODS2 or ODS5
Re: Oracle10g - Database Files on ODS2 or ODS5
Hewlett Packard Enterprise International
- Communities
- HPE Blogs and Forum
© Copyright 2018 Hewlett Packard Enterprise Development LP