Home » RDBMS Server » Server Administration » Script for automating Oracle database startup & shutdown in NT
Script for automating Oracle database startup & shutdown in NT [message #19390] Thu, 14 March 2002 01:45 Go to next message
Aswin Kumar
Messages: 4
Registered: January 2002
Junior Member
Can anyone help me out with the script for automating startup/shutdown of Oracle database in WIN. NT ?

Report message to a moderator

Re: Script for automating Oracle database startup & shutdown in NT [message #19393 is a reply to message #19390] Thu, 14 March 2002 03:53 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
set instance db_name
connect internal/.....
startup pfile=.........

set instance db_name
connect internal/......
shutdown immediate

Report message to a moderator

Re: Script for automating Oracle database startup & shutdown in NT [message #19410 is a reply to message #19393] Thu, 14 March 2002 21:00 Go to previous message
Arun Srivastav
Messages: 1
Registered: March 2002
Junior Member
create a file..say AUTOSTART.BAT
text in
set ORACLE_SID=ORCL
svrmgrl @C:Ora81start.sql
exit

create a file..say AUTOSTOP.BAT
text in
set ORACLE_SID=ORCL
svrmgrl @C:Ora81stop.sql
exit

start.sql:
connect internal
startup
exit

stop.sql
connect internal
shutdown immediate
exit

Then use windows schedular to get the time and date and run the consequetive bat files

Report message to a moderator

Previous Topic: Re: PCT_FREE/PCT_USED
Next Topic: Re: TNS-12500 Error 11: resource temporarily unavailable
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 12 01:38:26 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.