From kevin@dulcian.com Fri, 02 Mar 2001 09:41:58 -0800 From: "Kevin Kostyszyn" Date: Fri, 02 Mar 2001 09:41:58 -0800 Subject: Re: ORACLE_ON_NT !!!! Message-ID: MIME-Version: 1.0 Content-Type: text/plain Jackson and Don, I like Don's idea. I think it is strange though, I only have one more question. How is the database started and stopped? Can you only use svrmgl? I would have to go with Don's idea, if this is a 24/7 database I am afraid it would have to be recycled. I would think that if you went to your boss and explained this horrid situation there would be an understanding. Let me know what happens, I am very interested in this one. Sincerely, Kev ----- Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Friday, March 02, 2001 9:06 AM > 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@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@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@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@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@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@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@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@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@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).