ORA-01033:ORACLE INITIALIZATION OR SHUTDOWN IN PROGRESS
hi
i hav login problem,i m using oracle9i in winxp,
i can able to connect as '/ as sysdba'
when i try to connect as any other user i m unable to connect it throws the error
ORA-01033:ORACLE INITIALIZATION OR SHUTDOWN IN PROGRESS.
this is wat i did
connect / as sysdba
then try to connect
sql>connect scott/tiger
ERROR:ORA-01033:ORACLE INITIALIZATION OR SHUTDOWN IN PROGRESS
connect / as sysdba
SELECT * FROM V$LOG;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 756 10485760 1 NO INACTIVE
705383 10-MAR-06
2 1 757 10485760 1 NO INVALIDATED
704310 10-MAR-06
SELECT * FROM V$LOGFILE;
GROUP# STATUS TYPE
---------- ------- ----
MEMBER
--------------------------------------------------------------------------------
2 STALE ONLINE
D:\ORACLE\ORADATA\BOSS\REDO\redo02.log
1 ONLINE
D:\ORACLE\ORADATA\BOSS\REDO\redo01.log
Then i gave SHUTDOWN ABORT
AND RESTARTED THE DATABASE
AT THAT TIME DATABASE IS ONLY MOUNTED BUT NOT OPEN
database mounted
IT SHOWS ERROR:
ORA-16038:log 5 sequence# 756 cannot be archived
ORA-19504:failed to create file ""
ORA-00312:online log5 thread 1 'D:\oracle\oradata\boss\redo\redo01.log'
so wat i hav to do at this stage,did i need to relocate the redo logs file to new location and want clear the logfile ?
or do i want
to create the new redo log file and drop the old one
plz help me to solve this