Re: Oracle Start

Gaby wrote:

> Hi,
> my Oracle DB don't start automatically when i start the Server (w2k).
> I don't know why. Can anybody help me?
>
> --
> Gaby
> gspiessl_at_gmx.at

3 methods:

1. use a GUI
2. edit the registry
3. use a command line tool
4. use a GUI Do you have the Oracle Administrative Assistant for Windows NT installed?

if yes, use the following - else - use method 'b'

Start - programs - Oracle/OraHome81 - Database Administration - Oracle Administrative Assistant for Windows NT. expand the tree to where the level "Databases" appears on the left hand panel.
right click on the database in question and select "startup/shutdown options"
2 panels exist:

    Oracle Instance

        X - Startup instance when service is started
        X - Shutdown instance when service is stopped
                Shutdown Mode
                - shutdown normal
        X     - shutdown immediate
                - shutdown abort
    Oracle NT Service Starup Options
        Oracle NT Service Startup Type
             X - Automatic
                 - Manual

b. edit the registry

start - run - regedt32

under HKLM\Software\ORACLE\HOME<n>
 edit the value for ORA_%ORACLE_SID%_AUTOSTART  it should read 'TRUE'

where %ORACLE_SID% is the ORACLE_SID for the database that is not starting at system start.

c. command line

D:\Oracle\Ora81\bin>oradim -EDIT -SID EMS -STARTMODE auto

hth,

Paul Received on Sat Jul 21 2001 - 16:31:16 CDT