Re: Oracle in NT environment

Ulf Pettersson <Ulf.Pettersson_at_ore.ims.se> wrote:

>Do any have one any suggestions how to start an instance automatically
>òn the NT platform ?
 

>Please answer to
>Ulf.Pettersson_at_ore.ims.se
 

>Thanks in advance

Command-Line Option

In certain situations, you may want to start up or shut down your Oracle7 database using a command-line option. For example, you may want to start up your Oracle7 database every time you start Windows. In this case, you can copy the Database Manager icon to your

Windows Startup program group and edit its properties as explained below.

Using the command-line option can save time and effort.

To use the startup and shutdown command-line option, simply add the options (described below) to the command line within the Program Item Properties dialog for the Database Manager icon.

To use the command-line option:

1. Select the Database Manager icon.
2. Choose File from the Windows menu bar, then choose Properties. The Program Item Properties dialog appears. Notice that the Command Line ends with "VSMGR.EXE".
3. Edit the Command Line so that it ends with the following:

VSMGR.EXE[DATABASE=dbname][PASSWORD=passwd][ACTION=act][CONFIGURATION=config]

where dbname equals the database name or alias, passwd equals the database password (not a user password), act equals either STARTUP or SHUTDOWN, and config is the name of the configuration to use the start

the database. If the configuration name includes any embedded spaces,

it should be enclosed in quotes.

 Example

The following example starts up the database:

VSMGR.EXE DATABASE=Accounting PASSWORD=manager ACTION=startup CONFIGURATION="NT Small"

Note: When using the command-line option, no spaces are allowed in the

option=action syntax.

The command-line syntax is not case-sensitive.

In most cases, the Database Manager will not appear. However, if any option--database, action, or password (if there is a database password)--is missing or incorrect, or if an error occurs, the Database Manager dialog will appear.

If action is set to SHUTDOWN and users are still connected, a dialog will appear prompting you to disconnect user sessions.