O'Reilly logo

Oracle Parallel Processing by Sanjay Mishra, Tushar Mahapatra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required