August 2000
Intermediate to advanced
288 pages
7h 50m
English
Content preview from Oracle Parallel ProcessingBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 7. Administering an OPS Database
In Chapter 6, we introduced the fundamental concepts of Oracle Parallel Server (OPS) and its architecture. In this chapter we’ll explain specifically how to administer an Oracle Parallel Server database. This discussion includes the process you go through to create the database.
Creating an OPS Database
An OPS database is created in much the same way as a standalone database. The actual startup of an instance and the execution of the CREATE DATABASE command are exactly the same for both types of databases. The differences involve how you manage initialization parameters and how you must convert the newly created database into an OPS database. Initially, an OPS database must be created by just one instance, as a standalone database. Only after the database has been created do you take steps to convert it into an OPS database, one that is open by multiple instances simultaneously.
Preparing to Create the Database
In preparation for creating an OPS database, you must do the following:
Ensure that you have the proper hardware and software configuration. Refer to Chapter 6 and Chapter 2, for more information on hardware and software configuration for Oracle Parallel Server.
Organize your disk space to hold the Oracle software, the OPS database files, and other related files. On most platforms (including Unix and Windows NT) all datafiles, redo log files, and control files must be on raw devices. Refer to your operating system documentation for information ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.