I have Oracle 7.3 running on an NT 4.0 Server.
When I shutdown my server or stop the service - what happens ?
Is it making a shutdown immediate process or shutdown abort ?
If it is shutdown abort - how can I make it try shutdown immediate first ?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Nope! The answer is incorrect. When you shutdown the services, it does a shutdown abort in the back end. You'll find that it does an instance recovery on startup. This is what I implemented to shutdown gracefully.
1. From svrmgrxx do a shutdown immediate or shutdown .
2. Once you have done this you can stop the services.
Hope this helps.
According to junfeb's comment,
your answer is not correct.
This is what I heard too -
Shutting down the server (or the oracle service) will shutdown abort the instance.
The question is - How can I change it, so the service will try to make a
shutdown immediate before it stops (automatically, when I shutdown the server).
I found something I hope helps you.
To create an icon to start Oracle services and database:
1. From the Program Manager, select a Windows group to put start/stop icons, such as 'Oracle for Windows NT'. Click on that group to make it active.
2. From Program Manager toolbar menus:
a. Select File > New > Program Item
b. Type the following in the 'Description' field: Start TEST
c. Type the following in the 'Command line' field:
c:\orant\bin\oradim73.exe -startup -sid TEST -usrpwd oracle -starttype srvc,inst -pfile c:\orant\database\initTEST
To create an icon to stop Oracle services and database:
1. From the Program Manager, select a Windows group to put the
start/stop icons, such as 'Oracle for Windows NT'. Click on
that group to make it active.
2. From Program Manager toolbar menus:
a. Select File > New > Program Item
b. Type the following in the 'Description' field: Stop TEST
c. Type the following in the 'Command line' field:
c:\orant\bin\oradim73 -shutdown -sid TEST -usrpwd oracle -shuttype srvc,inst -shutmode i
NOTE: Shutmode of 'i' configures Oracle for an immediate shutdown which will rollback uncommitted transactions and disconnect users.
3. Press OK.
Answer is too easy if you want to startup your database when you boot your machine. Also if you want to schedule startup / shutdown of your instances (using AT command).
It's difficult to answer if you can shutdown your instances every time you shuts down your server. Give me some time to research and I'll give you an answer.
Thanks.
Go to the following url and download the 'OracleSafeShutdown' utility for NT. It will allow you to create a shutdown service for the database.
http://ourworld.compuserve
I'm not using it, since the time required for instance recovery on our database is insignificant.
The information that you essentially do a 'shutdown abort' is correct, in the sense that instruction is equivalent to a server crash. As far as the Oracle server is concerned, you might as well be flipping off the power to the NT box. Oracle really can't distinguish between the two when it restarts.
I traded some Email with the guy who wrote this service about 2 years ago. Oracle doesn't officially support this utility (they DID conside doing so) because there's no way to guarantee it will work for every database. NT allows 20 seconds for a shutdown operation to complete during an NT shutdown. If it hasn't completed in 20 seconds, the OS shutdown continues without waiting for the service to complete.
If your database shutdown can complete in this time, then this might work well for you. Don't forget, it'll be YOUR responsibility to test it whenever you do an NT or Oracle upgrade.
FWIW, I know of one DBA who tried this and liked it.
Final note: It doesn't work for the first shutdown - you have to install it, shutdown the NT server (Oracle crashes again), and it should work on the FOLLOWING NT shutdown to stop the database.
What I implemented was to schedule an offline backup, so I used a combination of at command, netstart, netstop and svrmgrxx.
It was very easy to implement.
You could try what frankr suggests and the doco does say that oracle supports this utility from version 8.0.4. Still the time frame is only 20 seconds.
If you would like to have the batch file that ran at a scheduled time to bring down oracle, I shall post it.
Thanks.
Hey! Hey!
Here is an NT tip, I found - Why don't you try this with the Orasafe utility, Maybe this will
give you a little more time to do a clean shutdown .
TIP : How to alter the time it takes Windows NT to shutdown.
Edit: HKEY_LOCAL_MACHINE\SYSTEM\
This key tells the service control manager how long to wait for services to complete the shut-down request. The default is 20000 milliseconds.
You must wait long enough for the services to complete an orderly shutdown.
Tell me how you go.
Thanks.
Business Accounts
Answer for Membership
by: hvetsaPosted on 1998-11-23 at 15:04:33ID: 1082718
When you shutdown or stop service the Instance will shutdown normal.
If you want to do immediate or abort you have to use svrmgr23 from the command line. The option NORMAL is default
There is no shutdown immediate first and shutdown abort next. All the three option do the same but differently. The order of preference should be
NORMAL
IMMEDIATE
ABORT( Only with an expert advise like Oracle Tech Support)