Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Automatically startup database

Re: Automatically startup database

From: shuan <shuan.tay_at_pci.co.id>
Date: Fri, 22 Mar 2002 00:03:22 -0800
Message-ID: <F001.004308B7.20020322000322@fatcity.com>


ah....is this an error message?
i also like tat....but i can do all my stuffs normally.

> Thanks for your help, I have checked that the
> Automatic Startup Type as Dave's said is set
> on the control panel service's.
>
> Also as Marin and Igor said to check the registry and this
> value are set as TRUE for ora_sid_autostart.
>
>
> If I run C>sqlplus internal/
> i got thiw error message "Connected to an idle instance"
>
> I am using Win2K SP 1,
> if I install this on WinNT ...I got no problem.
>
> Any suggestion....
>
>
> Ferry Situmorang:
> Using Oracle 8.1.7 Designer 6i R4
> PT Perkebunan Nusantara XIII (Persero)
> Pontianak-Indonesia
> http://www.ptpn13.com
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Friday, March 22, 2002 1:21 AM
>
>
> > In fact, you need both:
> >
> > 1) set your oracle<SID> service to startup automatically; you need this
in
> > order to start Oracle process on NT automatically, but this is not
enough
> to
> > "startup" the database automatically, when oracle process starts. In
order
> > to do this, you need to:
> > 2) set registry key ORA_sid_AUTOSTART to TRUE
> >
> > Igor Neyman, OCP DBA
> > ineyman_at_perceptron.com
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, March 21, 2002 12:18 PM
> >
> >
> > >
> > > ----- Original Message -----
> > >
> > > > How to make database instance on Win2K automatically startup when
the
> PC
> > > up?
> > >
> > > it is specified in the windows registry
> > >
> > > check HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
> > >
> > > there should be entries named ORA_sid_AUTOSTART for each instance in
> this
> > > ORACLE_HOME (where *sid* is the SID of the instance)
> > >
> > > if u set the value for some ORA_sid_AUTOSTART to TRUE the respective
> > > instance should be started automatically
> > >
> > > note that this is the default behaviour of the Oracle installation
(set
> > > autostart to true), so most probably the reason for your instance not
> > being
> > > autostarted is different
> > >
> > > hth,
> > >
> > > Marin
> > >
> > > ----
> > > "...what you brought from your past, is of no use in your present.
When
> > > you must choose a new path, do not bring old experiences with you.
> > > Those who strike out afresh, but who attempt to retain a little of the
> > > old life, end up torn apart by their own memories. "
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Marin Dimitrov
> > > INET: marin.dimitrov_at_sirma.bg
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Igor Neyman
> > INET: ineyman_at_perceptron.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ferry Situmorang
> INET: binsar_at_kalimantan.ptpn13.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: shuan
  INET: shuan.tay_at_pci.co.id

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Mar 22 2002 - 02:03:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US