Skip Headers

Oracle9i Database Administrator's Guide
Release 2 (9.2) for Windows

Part Number A95491-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

1
Postinstallation Database Creation

This chapter describes how to create a database after installing Oracle, using either Database Configuration Assistant or command-line tools.

This chapter contains these topics:

Before You Create a Database

Before you create a database, consider the following requirements:

Naming Conventions for Oracle Databases

All mounted Oracle databases in a network must have unique database names. When a database is created, a name is associated with it and stored in its control files. If you provide the database keyword, either in the CREATE DATABASE statement or when prompted by Database Configuration Assistant, then that value becomes the name for that database.

If you attempt to mount two Oracle9i databases with the same database name, then you receive the following error during mounting of the second database:

ORA-01102: cannot mount database in EXCLUSIVE mode

If there are two or more Oracle9i databases on the same computer, but located in different Oracle homes, then the following rules apply:

To change the name of an existing database, you must use the CREATE CONTROLFILE statement to re-create your control files and specify a new database name. This restriction exists only for Oracle8i and later versions. Any Oracle7 instances running simultaneously with an Oracle9i instance are not subject to this restriction.


Note:

Directory path examples in this chapter follow Optimal Flexible Architecture (OFA) guidelines. An example of an OFA path is ORACLE_BASE\ORACLE_HOME\rdbms\admin. If you specified non-OFA directories during installation, then your directory paths will differ.


Accessing Data Files and Log Files on Remote Computers

Oracle can access database files on a remote computer using Universal Naming Convention (UNC), but it may degrade database performance and network reliability. UNC is a PC format for specifying locations of resources on a local area network. UNC uses the following format:

\\server-name\shared-resource-path-name

For example, UNC specification for file system01.dbf in directory C:\oracle\oradata\orcl on shared server argon would be:

\\argon\oracle\oradata\orcl\system01.dbf

Locations of archive log files cannot be specified using UNC. Always set initialization parameter LOG_ARCHIVE_DEST_n to a mapped drive. If you set it to a UNC specification, then Oracle9i database does not start and you receive the following errors:

ORA-00256: error occurred in translating archive text string '\meldell\rmdrive'
ORA-09291: sksachk: invalid device specified for archive destination 
OSD-04018: Unable to access the specified directory or device
O/S-Error: (OS 2) The system cannot find the file specified

An ORA-00256 error also occurs if you enter \\\meldell\rmdrive or \\\meldell\\rmdrive. Control files required the additional backslashes for Oracle8 release 8.0.4, but redo log files and datafiles did not.

Creating a Database Using Database Configuration Assistant

Oracle Corporation recommends you use Database Configuration Assistant to create a database, because it is easier.

Use Database Configuration Assistant (DBCA) to register a database running in a member server or workstation in Active Directory on a Windows 2000 domain from a member server or workstation.

If the database service is running on a server, then make sure everyone is a member of Pre Windows 2000 Compatible domain group. If everyone is not a member of this group, then add the username/computer name (LocalSystem) that the database service is running to the Pre Windows 2000 Compatible domain group. If this is not done, then the database on the member server will randomly get ACCESS DENIED errors when accessing Active Directory.

For Database Configuration Assistant to successfully register the database with Active Directory, the database service on the server is required to be running as a LocalSystem or domain user. If the database is running as a local user, then trying to register the database with Active Directory using Database Configuration Assistant fails, because this user cannot log on to Active Directory.

After successfully registering with the directory using Database Configuration Assistant, you must manually add a name to Access Control List of OracleDBSecurity container (in Active Directory) with read permissions on OracleDBSecurity container. If the database service is running as a LocalSystem, then manually add the computer name. If the database service is running as a domain user, then manually add the username. If this is not done, then you may not be able to use Active Directory to grant an enterprise role.

Database Configuration Assistant enables you to:

Create a Database

  1. Choose Start > Programs > Oracle - HOME_NAME > Configuration and Migration Tools > Database Configuration Assistant.

    The Database Configuration Assistant Welcome page appears.


    Note:

    You must have the Windows Administrator privilege to create an Oracle9i database. If Database Configuration Assistant is run from a user account that is not part of the Administrator's group, then it displays a warning stating that you do not have administrative privileges to create the database.


  2. Click Next.

    A window appears prompting you to select an operation to perform.

    Text description of dbwel.gif follows.

    Text description of the illustration dbwel.gif

  3. Select Create a database.

  4. Click Next.

    A window appears prompting you to select a database template.

    Text description of dbtmpl.gif follows.

    Text description of the illustration dbtmpl.gif

  5. Select New Database.

  6. Click Next.

  7. Enter a global database name and an Oracle System Identifier (SID).

    The name is typically of the form name.domain, and the SID must be 64 characters or less.

    Text description of dbname.gif follows.

    Text description of the illustration dbname.gif

  8. Click Next.


    Note:

    If you use Database Configuration Assistant to create a new database in a new Oracle home, then file listener.ora is updated with the SID information, and a new TNS entry is generated in file tnsnames.ora. Both files are located in ORACLE_BASE\ORACLE_HOME\network\admin.


Text description of dbfeat.gif follows.

Text description of the illustration dbfeat.gif


Go to previous page Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback