HomeНаука и техникаRelated VideosMore From: Techies Digest

ORA-01033: ORACLE initialization or shutdown in progress

59 ratings | 16127 views
ORA-01033: ORACLE initialization or shutdown in progress - How to fix this issue? You can fix ORA-01033: ORACLE initialization or shutdown in progress issue using following commands. Error Message: ORA-01033: ORACLE initialization or shutdown in progress Resolution: As a DBA, you must know the Shutdown, Shutdown Immediate or Startup commands that are issued by database administrator with SYSDBA privileges. 1) select status, database_status from v$instance; 2) select open_mode from v$database; 3) alter database mount; 4) select status, database_status from v$instance; 5) select open_mode from v$database; 6) / as sysdba 7) alter database open; 8) select status, database_status from v$instance; 9) select open_mode from v$database; Check out this entire video and you will see the database is opened in read write mode and your database issue is resolved. Now you can login with your user name and password to access your database. You can also follow below step by step guide to resolve ORA-01033: ORACLE initialization or shutdown in progress issue. http://techiesdigest.com/ora-01033-oracle-initialization-or-shutdown-in-progress/ Share your LOVE by Liking & Sharing this Video and SUBSCRIBE to our YouTube channel for more interesting and useful Tech videos. LIKE - SHARE - SUBSCRIBE Subscribe - https://goo.gl/Z4No32 Website: http://techiesdigest.com/ Twitter: http://www.twitter.com/techiesdigest Facebook: http://www.facebook.com/techiesdigest Google+ - https://plus.google.com/100074553945448527181 YouTube: http://www.youtube.com/techiesdigest Thank you so much! We appreciate your continued extended support, enthusiasm, dedication and passion to LOVE our channel.
Html code for embedding videos on your blog
Text Comments (13)
Abir Dhali (2 months ago)
i am getting error like this.. SQL> alter database open; alter database open * ERROR at line 1: ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [99], [16276], [16984], [], [], [], [], [], [], [] how can i solved this please help me..
Nilesh Mankar (7 months ago)
ERROR ORA00600 Internet error code orgument [kcrater_nab_less_than_odr],[1],785,[9040],[9041],[],[] please guide
HIEU HAU (9 months ago)
Thanks for the great video. it helped me a lot
Suparna pai (11 months ago)
SQL> alter database open; alter database open * ERROR at line 1: ORA-01172: recovery of thread 1 stuck at block 25 of file 2 ORA-01151: use media recovery to recover block, restore backup if needed How to overcome this?
vaibhav patil (11 months ago)
when i try to open database..it shows an internal error
Naveen Kumar (3 months ago)
do you find solution for this??
Naveen Kumar (3 months ago)
yes for me too
sivaranjani ravi (11 months ago)
thank you sir
Swati Das (1 year ago)
sir i did.... SQL> select status, database_status from v$instance; STATUS DATABASE_STATUS ------------ ----------------- STARTED ACTIVE SQL> select open_mode from v$database; select open_mode from v$database * ERROR at line 1: ORA-01507: database not mounted SQL> alter database mount; alter database mount * ERROR at line 1: ORA-00214: control file 'E:\APP\USER\ORADATA\ORCL\CONTROL01.CTL' version 20195 inconsistent with file 'E:\APP\USER\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL' version 20193 what i ll do now could u resolve this error plz reply soon...........................
Shreeraj Nair (1 year ago)
SQL> alter database open; alter database open * ERROR at line 1: ORA-00742: Log read detects lost write in thread 1 sequence 211 block 59392 ORA-00312: online log 1 thread 1: 'D:\ORACLE\APP\ORACLEUSER1\ORADATA\ORCL\REDO01.LOG' this error is coming ....can you pls help
Jean Freitas (1 year ago)
/ as sysdba > select open_mode from v$database; ORA-01507: database not mouted > alter database mout; Database altered. > select status, database_status from v$instance; STATUS, DATABASE_STATUS > select open_mode from v$instance; OPEN_MODE MOUNTED > alter database open; Data base altered. > select open_mode from v$instance; OPEN_MODE READ_WRITE /* outer instance of cmd */ > select status,database_status from v$instance; > select open_mode from v$database;
Vimal Patel (1 year ago)
how to fix ORA-65054: Cannot open a pluggable database in the desired mode ?
Techies Digest (1 year ago)
Thanks Jeans for writing entire solution.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.