Document ID:        41947.1
Subject:            CONF72: Creating a new 7.2/7.3 instance/database on NT
Last Modified:      08 May 97 
Author: 	    Unknown


This bulletin gives step by step instructions on how to create a 7.2 or 7.3
Oracle instance/database on Microsoft Windows NT.

The information here is meant to supplement the following manuals:
Enterprise Server:  "Release 7.2 for Windows NT User's Guide",
                    "Release 7.3 Getting Started for Windows NT"
Workgroup Server:   "Release 7.2 for Windows NT Understanding Oracle7
                     Workgroup Server"
                    "Release 7.3 for Windows NT - Getting Started"

******************************************************************************

This document assumes the following:
a.  That your new SID is named "TEST"
b.  That your password for the user INTERNAL is ORACLE
c.  That you already have the ORCL Instance (starter database) that should
    have been created at installation time.
d.  That you are using/have used the default installation directories
******************************************************************************

CREATING THE DATABASE initSID.ora:
==================================

1. Copy the initORCL.ora file to a file named initTEST.ora
   (The default directory for the initORCL.ora file is C:\ORANT\DATABASE)

2. Modify initTEST.ora to contain your new database information.
   Using Notepad (NOT Write) edit the file and modify the following:

   a.  DB_NAME = (new SID)
       Example: Change db_name=oracle to db_name=TEST

   b.  CONTROL_FILES = (D:\ORANT\DATABASE\ctl1TEST.ora)*
       * This step is very important.  If you do not change the
         CONTROL_FILES parameter the control files of other database(s)
         could be overwritten by the new instance rendering the other
         instance unusable.

CREATING INSTANCE SERVICES:
===========================

1.  Use the GUI version of Instance Manager to create the SID, the Services,
    the Database, and the Data Dictionary.
    (The command line version does NOT create a new database)

    a.  Double click on the Instance Manager icon.  Click on the NEW button.

    b.  In the New Instance Window fill in the following Information:

          SID:                                 A unique 4 Character or less
                                               name, ie TEST.
          DBA Authorization Password:          This is the INTERNAL password*
          Confirm DBA Authorization Password:  Same as above.

       (O)Maximum Number of DBA/Operators:     Change from the default of 5**
       (O)Instance Startup Mode:               Change to Automatic

        Click on the Advanced button

          Database:                            Change to TEST
       (O)Character Set:                       Change to WE8IS08859P1***

       (O) Optional - don't HAVE to be changed
         * Be sure to remember this password since it will be required when
           starting and stopping the database, as well as for other DBA
           activities.
        ** This will allow you to grant up to 5 users the SYSDBA/SYSOPER
           roles, so that they can CONNECT... AS SYSDBA/SYSOPER, and not know
           the database password.  This is only useful for stopping/starting
           the database from SQL*DBA or Server Manager (not the Database
           Administration tools)
       *** US7ASCII is a subset of this character set

2.  Verify that the services were created.  This is accomplished by doing the
    following:
    a.  Open the Control Panel and double click on the Services icon.
    b.  Scroll down to the Oracle Services and verify that OracleServiceTEST
        and OracleStartTEST services exist
    c.  Click on the Close button to exit the Services applications.

3.  If the services were not created, create them from the DOS command
    prompt using Oradim7x (where x is the version, 2 or 3):
    a.  If neither service was created:

        > oradim7x -new -sid TEST -intpwd ORACLE -startmode AUTO -pfile
             C:\ORANT\DATABASE\INITTEST.ORA

    b.  If only OracleStartTEST was not created:

        > oradim7x -delete -sid TEST
        > oradim7x -new -sid TEST -intpwd ORACLE -startmode AUTO -pfile
             C:\ORANT\DATABASE\INITTEST.ORA

STARTING THE DATABASE:
======================

For Oracle7 Server version 7.2, use SQLDBA72 for version 7.3, use SVRMGR23.

1.  From a DOS Command prompt set your environment variable to the new SID:*
    SET ORACLE_SID=TEST
2.  From the same DOS window execute either SQLDBA72 or SVRMGR23
    > CONNECT INTERNAL/password
    > STARTUP PFILE=C:\ORANT\DATABASE\INITTEST.ORA

     The tool should reply with:
            ORACLE instance started
            Database mounted
            Database opened
            Total System Global Area ....

      or, if already started, it should reply with:

      ORA-01081: Cannot start already running ORACLE - shut it down first

* If this new instance is going to be your primary instance (ie. the instance
  you work with most often)  You can permanently set your environment
  variable in the Registry:
    - From Program Manager, click FILE, click RUN, and type REGEDT32
    - In the Window HKEY_Local_Machine on Local Machine,  double click on
      Software,
    - Click on Oracle
    - Change the Oracle_SID key to your new SID (ie. TEST) by double clicking
      on the Oracle_SID key in the right hand window and changing the value
      in the String Editor Window

FINAL NOTES:
============

The previous instructions are to create a very basic database.  You must
create your own tablespaces, rollback segments, etc.
You may want to look at the scripts, such as BUILD_DB.SQL, which were used
to create the ORCL database, for guidance.  The scripts are located in C:\ORANT\
RDBMS7x\ADMIN (where x is 2 or 3 depending on the version).