Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting error 00355 00353

Poor-BoyNov 19 2016 — edited Nov 21 2016

I just Simply open My System and when try to login with user name but getting error.... M using Dtabase 10g

SQL> connect

Enter user-name: sys as sysdba

Enter password:

Connected.

SQL> Shutdown immidaite

SP2-0717: illegal SHUTDOWN option

SQL> Shutdown immedaite

SP2-0717: illegal SHUTDOWN option

SQL> Shutdown immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> Startup

ORACLE instance started.

Total System Global Area  599785472 bytes

Fixed Size                  1288820 bytes

Variable Size             163579276 bytes

Database Buffers          432013312 bytes

Redo Buffers                2904064 bytes

Database mounted.

ORA-00355: change numbers out of order

ORA-00353: log corruption near block 1630 change 3116483 time 11/17/2016

04:34:28

ORA-00312: online log 2 thread 1:

'C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_CZ7D1ONB_.LOG

SQL> Connect

Enter user-name: gm/gm

ERROR:

ORA-01033: ORACLE initialization or shutdown in progress

Warning: You are no longer connected to ORACLE.

SQL>

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 19 2016
Added on Nov 19 2016
15 comments
1,354 views