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 ([EMAIL PROTECTED]) > 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: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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).
begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
