ORACLE Startup Problem

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.

Is this part of a cluster or is it a standalone?

Check hidden parameter:

select name, value from v$parameter
where name= '_kgl_debug'

If this is a RAC instance, pl check the value of parameter _KGL_DEBUG. It should be different across all instances. However, I would recomend do not set this para
meter directly without consulting Oracle support

Harvinder

Please refer this Oracle metalink note, it will be helpful. (Doc ID 1604879.1)