Re: Automatic Starting Oracle Instance on NT

Let us say that you have instance SID name as PROD.

Make sure you have NT services ( Start -> Control Panel -> Services ) settings as follows:-

1. OracleStartPROD set as Automatic Startup.
2. OracleServicePROD set as Manual.

Another thing you have to look is the command file "strtPROD.cmd" contains all the necessary information including PFILE ( parameter file ).

---Example of "StrtPROD.cmd" entry ---- Start ----

c:\orant\bin\oradim73.exe -startup -sid PROD -usrpwd internal_pwd -starttype srvc,inst -pfile c:\orant\database\initPROD.ora

---Example of "StrtPROD.cmd" entry ---- End ----

You should open this file using notepad to make sure it is coorect in all respects, as this will be used by service OracleStartPROD which starts automatically at the bootup time. The OracleStartPROD service then kicks the other service named OracleServicePROD.

Hope this helps,

Please let me know if this solution worked. Send me email at <manoj67_at_hotmail.com> or simply reply this message.

take care,
Manoj Jain
Oracle Certified Professional - DBA
Chauncey Certified Oracle7 DBA

In article <35DDA83F.2F2578E4_at_ibm.net>,   sbenyo_at_ibm.net wrote:
> Hello,
>
> I have created an instance of oracle 7.3.3 on NT 4.0 server.
> The instance was created using the command:
>
> oradim73 -new -sid XXX -intpwd YYY -startmode auto -pfile=ZZZ
>
> after that I created the database itself.
> When I restart the system the database dosent come up automatically.
>
> I tried deleting & recreating the instance again using oradim73. This
> time adding the line:
>
> oradim73 -startup -sid XXX -usrpwd YYY -starttype inst,srvc -pfile=ZZZ
>
> On other instances that had the two line it works.
> On the original it does not.
>
> Is there a way to get rid of an instance & recreate it so it come up
> automatically (without recreating the database) ?
> Or is there a way to get rid of the instance so oracle wont recognize it
> at all & recreate it correctly?
>
> It is at most importance to me since we have production databases that
> cant come up automatically and it causes lots of trouble when it
> happens.
>
> 10X
> Shaul.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 21 1998 - 18:48:18 CDT