This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Feb 6, 2013 5:03 AM by yoonas RSS

Not able to log in: Initialization or shutdown in progress

988779 Newbie
Currently Being Moderated
I working with oracle sql for a long time and suddenly today I am not able to log in to it.
Here is what I get

C:/Users/....>sqlplus @orcl
SQL*Plus Release 11.2.0.1.0 Production on Sun Feb 3 17.05.52 2013
Copyright.........etc etc
Enter Password:
ERROR
ORA-01033: oracle initialization or shut down in progress
Process ID: 0
Session ID: 0
Serial ID: 0
Enter Username:

Then I run
sqlplus /nolog
connected
SQL>connect sys/manager as sysdba
Connected
SQL>shutdown immediate
ORA-01109: Database not open
Database Dismounted
oracle instance shutdown
SQL>startup
oracle instance started

Total System Global Area: 2522038272 bytes
Fixed Size 2178316 bytes
Variable Size ....(biig numbers)
Database Buffers ....(big numbers)
Redo Buffers .....(big numbers)
Database Mounted

ORA-00314: log 3 or thread 1, expected sequence #9 doesnt match 6
ORA-00312: online log 3 thread 1 'C:\App\Tarun\ORADATA\ORCL\REDO03.LOG'

what should I do? I am a beginner to SQL
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points