Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Initialization Parameters, 39 of 188


DB_NAME

Parameter type: 

String 

Syntax: 

DB_NAME = database_name 

Parameter class: 

Static 

Default value: 

None 

Oracle Parallel Server: 

You must set this parameter for every instance. Multiple instances must have the same value, or the same value must be specified in the SQL*Plus command STARTUP OPEN db_name or the SQL statement ALTER DATABASE db_name MOUNT

DB_NAME specifies a database identifier of up to 8 characters. If specified, it must correspond to the name specified in the CREATE DATABASE statement. Although the use of DB_NAME is optional, you should generally set it before issuing the CREATE DATABASE statement, and then reference it in that statement.

If you have multiple databases, the value of this parameter should match the Oracle instance identifier of each one to avoid confusion with other databases running on the system.

If you do not specify this parameter, you must specify a database name in either the STARTUP command or the ALTER DATABASE ... MOUNT statement for each instance of the Oracle Parallel Server. 

The following characters are valid in a database name: alphabetic characters, numbers, underscore (_), pound (#), and dollar symbol ($). No other characters are valid. Oracle removes double quotation marks before processing the database name. Therefore you cannot use double quotation marks to embed other characters in the name. The database name is case insensitive.

See Also: Oracle8i Administrator's Guide and Oracle8i Parallel Server Administration, Deployment, and Performance for more information on setting this parameter. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index