Document ID:        29252.1
Subject:            WIN: STARTING PERSONAL ORACLE AUTOMATICALLY
Last Modifed:       25 September 1996
Author:             KJOHNSON


  QUESTION:
  ---------

  Under Windows it is possible to STARTUP Personal Oracle for
  Windows V7.1.4.1.0 automatically upon launching Windows?

  ANSWER:
  -------

  Steps to accomplish this are listed below:

  1) Launch Windows in enhanced mode

     C:\> win

  2) Bring up the "Personal Oracle7" Program Group.

  3) Double click on the Database Manager icon.

     a) click on "Configure..."

     b) click on the down arrow of the "Configuration:" box

     c) this is the list of configurations that you may use
        on the command line for the icon we are about to
        create. These are the pre-defined confiurations:

        *Windows 7.1 Default
        *Windows 7.1 No PL/SQL
        *Windows 7.1 PL/SQL

        You may also create your own configurations and they
        would be listed here also.

     d) click on "Cancel", then click on "Close" to exit.

  4) Bring up the "StartUp" Program Group.
  5) Press down on the "Ctrl" key, then with the mouse click and
     drag the "Database Manager" icon from the "Personal Oracle7"
     Program Group into the "StartUp" Program Group. You should
     now have a copy of the "Database Manager" icon in both
     Program Groups.

  6) Highlight the "Database Manager" icon in the
     "StartUp" Program Group by clicking on it once.

  7) In Program Manager click on "File", then click on "Properties...",
     (or with the icon highlighted press "ALT+ENTER") the
     "Program Item Properties" window pops up.
     Edit the "Description:" box to read
     "AutoStartUp Database Manager"
     this will avoid any confusion about having two Database Manager icons
     Edit the "Command Line:" box to read
     "C:\ORAWIN\BIN\vsmgr.exe password= action=startup
      configuration=Windows 7.1 PL/SQL"
     then click on OK.

     Note: The on-line helps show the text for the configuration
           parameter surrounded by double quotes and so does the
           IUG, but it works with or without quotes.
  8) EXIT windows

  9) Launch Windows again and the database should start automatically.
     You can verify this by going to the "Personal Oracle7" Program Group
     and double clicking on the "Database Manager" icon, then double
     clicking on the "Status" box - Host status: Available, running

  If you click on "Database Manager" icon from the "Personal Oracle7"
  Program Group and double click on the "Help" box, go to
  "Chapter 2 Using the Database Manager", go to "command-line option"
  you will see most of this information.

  If you follow the command line option given as in HELP
  "C:\ORAWIN\BIN\vsmgr.exe database= password=
   action=startup configuration=", you will get an ORA-3121.
  The workaround is not to include "database=oracle" on the command
  line. You have run into BUG 279974.

  Note: Follow steps 4 through 6 only stay within the "Personal Oracle7"
        Program Group to copy a new icon "AutoShutDown Database Manager"
        with this command line:

        C:\ORAWIN\BIN\vsmgr.exe password=oracle action=shutdown
        configuration="Windows 7.1 PL/SQL"

        Now you have an icon you can double click on to shutdown
        Personal Oracle without going through the several windows
        in Database Manager.

  Unfortunately Windows does not have a program group that will close
  down database applications gracefully when you exit windows so
  remember to SHUTDOWN Personal Oracle before you exit windows.
  Otherwise you will see an "ORAACLE7" message window with a red stop
  sign saying "An ORACLE7 instance is still running. Are you sure you
  want to stop it without shutting down cleanly?" with "Yes" "No"
  buttons. Click on "No" and you will return to the desktop giving
  you a chance to SHUTDOWN cleanly.