ORACLE Startup Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORACLE Startup Problem

  1. #1
    Join Date
    Aug 2014
    Posts
    1

    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.

  2. #2
    Join Date
    Feb 2014
    Posts
    22
    Is this part of a cluster or is it a standalone?

    Check hidden parameter:

    select name, value from v$parameter
    where name= '_kgl_debug'
    Last edited by ora_venlo; 08-12-2014 at 09:13 AM.

  3. #3
    Join Date
    Aug 2014
    Posts
    2
    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

  4. #4
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Please refer this Oracle metalink note, it will be helpful. (Doc ID 1604879.1)
    Thanks/Gopu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width