advanced code snippet search

Posted By

geekzspot on 01/24/13


Tagged

DBA


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

geekzspot


Bounce Oracle

 / Published in: SQL
 

How to "bounce" an Oracle database

Expand | Embed | Plain Text 
  1. connect / AS sysdba
  2.  
  3. shutdown
  4. -- New login's will get: ORA-16403 shutdown in progress - remote connection is not permitted, or ORA-01033 ORACLE initialization or shutdown in progress
  5. -- If you cannot wait, try:
  6. shutdown transactional
  7. -- If still you cannot wait, now warn users they will lose transactions.. then try:
  8. shutdown immediate
  9. -- If still you cannot wait, try:
  10. shutdown abort
  11.  
  12. startup

Report this snippet  

You need to login to post a comment.