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

Get Oracle Parallel Processing now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.