Tru64 Unix-Oracle9i Cluster Quick Reference

Chapter 8: Create and Manage Oracle9i Databases

Overview

Use the Oracle database configuration assistant (DBCA) to create a new clustered database, manage an existing database, delete a database, and to manage database templates.

DBCA creates a database from an existing template, or a custom database can be created and saved as a new template. Preconfigured templates are available for a data warehouse, transaction processing, or general purpose database. The database file location, configuration options, and database name can be set with the DBCA tool.

This chapter covers the use of the Oracle database assistant tool (DBCA) to create a sample Oracle9 i RAC database as well as some of the new Oracle9 i management features.

Timer

Plan 1 Hour to Create a Sample Database

Oracle9 i Create Database Summary

  • Oracle global services daemon (GSD)

  • Oracle listener configuration

  • Run the Oracle database configuration assistant (DBCA)

  • Verify database

  • Using server control (SRVCTL)

  • Oracle9 i external tables

  • Oracle9 i transportable tablespaces

  • Oracle9 i flashback query

  • Transparent failover

Oracle Global Services Daemon (GSD)

Oracle programs that access the database as a client such as srvctl, dbca, and Oracle Enterprise Manager use the gsd daemon for management operations. Before using dbca or srvctl, always make sure that the gsd daemon is running on all nodes of the cluster.

  1. Start GSD on all cluster members.

    oracle@rac2> gsd

    Successfully started the daemon on the local node.
    Note

    Start the gsd daemon only once on each node. A gsd log file is located...

UNLIMITED FREE
ACCESS
TO THE WORLD'S BEST IDEAS

SUBMIT
Already a GlobalSpec user? Log in.

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Customize Your GlobalSpec Experience

Category: Database Tools Software
Finish!
Privacy Policy

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.