Re: ORACLE_ON_NT !!!!

For the Oracle database to -run- the OracleServiceTEST (created with the oradim80 command below) must be running, so I infer that you're missing the OracleStartTEST service.

You can try:

oradim80 -edit -sid SID -intpwd PASSWORD -startmode AUTO -pfile PATH/initSID.ora

and that might create it, or it will do no harm if it fails. I know the -startmode AUTO is the important part, and needs to be included in the creation if this doesn't work.

Doing the delete/add cycle certainly requires downtime, but the good news is you don't have to re-create the database, so you should be down only long enough to stop, run these commands, and start. (take a backup first, though!)

Jackson Dumas wrote:

> In order to automatically start Oracle on NT, OracleServiceSID and
> OracleStartSID must be started. They should be set to AUTOMATIC in
> control panel, on NT.Now my case is that both those services are not
> available or created. Now I read that I have to create those services.
> e.g.
> oradim80 -delete -sid TEST
> oradim80 -new -sid TEST -intpwd ORACLE -startmode AUTO -pfile
> c:\ORANT\DATABASE\INITTEST.ORA
>
> The version of Oracle is 806 and the version of NT is 4.0 Service pack
> 5. As to who installed and created the database, that one I don't
> know, maybe someone who was here before I joined the Oracle Team and
> he left already.
>
> The question is whether is there a way of implemeting this without
> having to ask for down time, in other words shutdown the Production
> database ? I think the question is clear now Kevin. Is there another
> way perhaps of creating this without having impact on the business by
> shuting down the database ?
>
> On Thu, 01 Mar 2001 05:41:50 -0800 Kevin Kostyszyn (kevin_at_dulcian.com)
> wrote:
>
> >What exactly are you asking? What version of Oracle, What version of
> NT?
> >Who installed and created the DB?
> >Kev
> >
> >-----Original Message-----
> >Dumas
> >Sent: Thursday, March 01, 2001 8:15 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >
> >
> >I would like to find out how I can make a Oracle database running on
> >NT to start up automatically if there is a power failure or something
> >on the box without having to down that database. I read another
> >article about Oradim and how to include the startup file if it's not
> >there on Services running on NT. Actually I did check that there is
> no
> >startup service for database to be automatically started. Now my
> >problem is whether it's possible for me to incorporate this without
> >having to get down time, because this is a 24X7 system and it will
> >take a long time before getting approval and things like those
> >Please help me, I am new on these thangs.
> >Ya help please ...... !!!!
> >_______________________________________________________________
> > http://www.webmail.co.za the South-African free email service
> > WIN R10 000 by registering for free online options for EasyMoney in
> > http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it -
> Now!!!
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Jackson Dumas
> > INET: tjaros_at_webmail.co.za
> >
> >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: Kevin Kostyszyn
> > INET: kevin_at_dulcian.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).
>
> _______________________________________________________________
> http://www.webmail.co.za the South-African free email service
> WIN R10 000 by registering for free online options for EasyMoney in
> http://www.easyinfo.co.za/easymoney/wmindex.asp - Easy Does it - Now!!!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jackson Dumas
> INET: tjaros_at_webmail.co.za
>
> 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 02 2001 - 08:21:48 CST