-
How to automate DB startup in windows
Hi folks,
How can i make the d/b to automatically start when the Windows starts and shutdown when the windows go down.
I think i need to create a service to do the same. Could somebody help me in this regard.
I am using windows2000 Professional and Oracle 8.1.7
sonia
Last edited by Sonia; 03-10-2003 at 06:14 AM.
-
Hi,
Use dbassist to create the database, it will create the service for you and by default it is set to startup automatically when the Machine starts. And will do a shutdown immediate when the machine goes down if you set the value of ORA_SID_SHUTDOWNTYPE to i in the registry.
HTH
Last edited by adewri; 03-10-2003 at 06:18 AM.
Amar
"There is a difference between knowing the path and walking the path."
-
Hi
Just create a new service with the followin command
ORADIM -NEW -SID TEST1
now go the services applet and make it auto start..that it
regards
Hrishy
-
hi,
No, already database is running.....and has been created manually.
now i cannot recreate the db.
I think there should be a way to do this.
-
ok....hrishy i will try that
thanx
-
Hi
Plaese refer to my post
regards
Hrishy
-
AFAIK, in windows 2000 if the database is running then the service must be there.
Go to services>OracleServiceSid.
double click it and in the startup type drop down menu choose automatic.
for shutdown immediate while the machine goes down set the value of ORA_SID_SHUTDOWNTYPE to i in the registry.
HTH
Amar
"There is a difference between knowing the path and walking the path."
-
drop the old service and recreate it with the following command:
DROP THE SERVICE
ORADIM -DELETE -SID SID_NAME
RECREATE THE SERVICE:
ORADIM -NEW -SID SID_NAME -STARTMODE AUTO -INTPWD PASSWORD -PFILE ....\PFILE\.INIT_SIDNAME.ORA
-
Originally posted by mike2000
ORADIM -NEW -SID SID_NAME -STARTMODE AUTO -INTPWD PASSWORD -PFILE ....\PFILE\.INIT_SIDNAME.ORA
(I'm prepared to be wrong on this . . .) I think that just makes the OracleServiceSID (i.e. the instance) startup as "Automatic". I've seen something else to startup the database - OracleStartSID I think - oradim does not seem to create this. (We didn't want this - so I deleted it ages ago). Amar usually knows what he is doing, check out dbassist . . .
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|