This content has been marked as final. Show 18 replies
Oracle Restart improves the availability of your Oracle database. When you install Oracle Restart, various Oracle components can be automatically restarted after a hardware or software failure or whenever your database host computer restarts.
971957 wrote:Because you have alter database close to do the same . Check the documentation to understand that how it works.
Why oracle instance cannot perform following :
1. Go to mount mode after open;
"alter database mount" when db is in open mode
2. Why Oracle doesn't have restart command in databasestartup force is what probably you want to look at ?
"alter database restart"
when it can perform these operation behind very easily
3. Why sql prompt cannot repeat its command as terminal of linux can doBecause one is O/S and another is a database, different softwares with different capabilties. If you do want to have such option, you may want to use something like rlwrap .
Why not oracle
That said, not every feature is going to be there with just about every version of the oracle database. It may be possible that what you asking/expecting now is going to be ready for release in some future release. So either wait or send a feedback to oracle to include your desired feature.
reply are welcome also atIts a bad practice to put your email on internet , just saying!
I see so many why across.
1. Go to mount mode after open; "alter database mount" when db is in open mode 2. Why Oracle doesn't have restart command in database "alter database restart" when it can perform these operation behind very easily 3. Why sql prompt cannot repeat its command as terminal of linux can do Why not oracle
Have you understood the importance of existing funtionalties ? If yes, then you probably try to utilize in better way instead of looking for why.
- Pavan Kumar N
You really need to dig deep to understand how Oracle does its sequence before posing a question why this, why not that? You are basically asking to drive your car before starting it or you want to put your car in parking gear while driving. Think logically, there is reason why Oracle is works such a way and not the other way around. I suggest read Oracle documentation thoroughly.
Gentlemen u r not getting me what i want to say
after opening database is there any option to go to **mount state** without shutting down database
then giving command alter database mount, if not why ? oracle was not able to give this command
there is no logic of OS or Database command .everything is possible in oracle & by oracle
why oracle was not able to get this feature?,there must by logic in that
also is there any command of database restart
shut abort will not restart database we have to restart manually from nomount, mount, open state all three state
why oracle has not given three statement
alter database restart to mount,nomount,open;
there is always & every where some logic behind
this what oracle had told
by reading what is written is not the solution
thinking what is not written & why it is not written is important
reading documentation & understanding is basic things
i m asking on thing v r three commands for starting database
nomount mount & open
when v can give open cmd open it will perform all three satges rite
why oracle had not given the restart command to any state ,as it is it has to perform the same thing that it is performing above
logic is starting & stooping background process nothing more then that
No, there is not a such a way to restart Oracle with one command. You will have to shut it down first and then once shutdown you can do "startup" to start it up which will in background go throught nomoun,mount and then finally open stage. There is literrally a two commands to restart versus just one command that you are looking for. does that help?