Hi,
Need some help in starting up an Oracle instance which was working fine a day ago.
Code:
SQL> startup
ORACLE instance started.
Total System Global Area 3140026368 bytes
Fixed Size 2257352 bytes
Variable Size 973082168 bytes
Database Buffers 2147483648 bytes
Redo Buffers 17203200 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01360: invalid token
Process ID: 30562
Session ID: 1030 Serial number: 5
Error from the alert log:
Code:
pid='30562'>
Errors in file /u01/app/oracle/diag/rdbms/mcsw/MCSW/trace/MCSW_ora_30562.trc:
ORA-01360: invalid token
Extract from trc file:
Code:
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 262144
Longest hash chain = 1
Average hash chain = 27/27 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 157/184 = 0.9
----------------------------------------------
*** 2014-08-09 02:22:07.195
KCRA: start recovery claims for 27 data blocks
*** 2014-08-09 02:22:07.199
KCRA: blocks processed = 27/27, claimed = 27, eliminated = 0
*** 2014-08-09 02:22:07.201
Recovery of Online Redo Log: Thread 1 Group 1 Seq 22 Reading mem 0
*** 2014-08-09 02:22:07.207
Completed redo application of 0.02MB
*** 2014-08-09 02:22:07.207
Completed recovery checkpoint
----- Recovery Hash Table Statistics ---------
Hash table buckets = 262144
Longest hash chain = 1
Average hash chain = 27/27 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 184/184 = 1.0
----------------------------------------------
Recovery sets nab of thread 1 seq 22 to 110 with 8 zeroblks
*** 2014-08-09 02:22:09.970
kwqmnich: current time:: 0: 22: 9: 0
kwqmnich: instance no 0 repartition flag 1
kwqmnich: initialized job cache structure
*** 2014-08-09 02:22:11.571
ORA-01360: invalid token
ORA-01360: invalid token
*** 2014-08-09 02:22:11.571
USER (ospid: 30562): terminating the instance due to error 1360
Any help is much appreciated.