Document ID:        43449.1
Subject:            Auto-Starting ORACLE 7.2 & 7.3 via Instance Manager
Last Modified:      08 May 97
Author:		    Unknown 


Summary:

AUTO-STARTING AN ORACLE DATABASE ON BOOTUP VIA INSTANCE MANAGER (ORADIM)

This bulletins explains how to start an Oracle database using Instance Manager
via command line (ORADIM72 for RDBMS V7.2.X or ORADIM73 for RDBMS V7.3.X).

These following topics are covered in this bulletin:
  1. Launching the Registry Editor and modifying an entry.
  2. Modifying the Windows NT Logon Process.
  3. Configuring the Oracle Services for Manual Startup.
  4. Creating the STARTDB.CMD command file.

1.  LAUNCHING THE REGISTRY EDITOR AND MODIFYING AN ENTRY

    a. Start the Registry by executing the command REGEDT32.
       This command is found in the WINDOWS NT SystemRoot\SYSTEM32
       directory.  This command can also be run via FILE - RUN and
       enter REGEDT32.

    b. Once in the registry editor, open the HKey_local_machine
       key window and expand the tree as follows:
         HKEY_LOCAL_MACHINE
           SOFTWARE
             Microsoft
               Windows NT
                 CurrentVersion
                   Winlogon

        NOTE: Double-clicking on a key expands its tree.

2.  MODIFYING THE WINDOWS NT LOGON PROCESS.

    a.  Within the Winlogon key double-click on the System value
        which is located in the right windows pane.  The string
        editor box appears and the current value(s) is displayed.

    b.  Append the System entry to include the (.CMD) file
        on the startup command line. For example:

        c:\ORANT\DATABASE\STARTDB.CMD

NOTE:  Remember to separate the command with a comma (,) delimiter.

3.  CONFIGURING THE ORACLE SERVICES FOR MANUAL STARTUP.

    a.  Under the SERVICES APPLET in the CONTROL PANEL the
        Oracle services should be marked to start manually.

        NOTE:  The command file will be responsible for starting
               your services.

4.  CREATING THE STARTDB.CMD COMMAND FILE.

    a.  The following command should be placed in the STARTDB.CMD:

        Version 7.2.x:

          C:\ORANT\BIN\ORADIM72 -startup -sid ORCL -usrpwd ORACLE
                                -pfile C:\ORANT\DATABASE\initORCL.ora
                                -starttype SRVC, INST

                                -OR-
        Version 7.3.x:

          C:\ORANT\BIN\ORADIM73 -startup -sid ORCL -usrpwd ORACLE
                                -pfile C:\ORANT\DATABASE\initORCL.ora
                                -starttype SRVC, INST

        NOTE:  This is a sample that assumes that the Oracle SID
               is ORCL and the database INTERNAL (authorization)
               password is ORACLE and starting both the services
               and the instance with the same command.

This will startup the database after the Windows NT server has
booted, but before anyone logs on.

OTHER ORADIM72 & ORADIM73 COMMANDS:

-NEW:

         -NEW -SID <sid>
              -INTPWD <internal_pwd>
              -STARTMODE <auto, manual>
              -PFILE <path & filename>

     NOTE: This creates your Service at the same time it creates the
           instance.

-STARTUP:

         -STARTUP -SID <sid>
            -PFILE <path & filename>
            -USRPWD <user_pwd>
            -STARTTYPE <SRVC, INST>

-SHUTDOWN:

         -SHUTDOWN -SID <sid>
            -SURPWD <usr_pwd>
            -SHUTTYPE <SRVC, INST>
            -SHUTMODE <a, i, n>

-DELETE:

         -DELETE -SID <sida, sidb, sidc,...>
         -DELETE -SRVC <srvca, srvcb, srvcc,...>

Keywords:            STARTUP;NT;WINDOWS;AUTO;AUTOMATIC;ORACLE;ORADIM