8 Replies Latest reply: Jan 7, 2009 7:40 AM by EdStevens RSS

    Crash of QA instance

    Keith Jamieson
      I have a dev/qa instance that crashed this morning.
      Oracle 10.2.0.1 running on windows xp professional.

      Unfortunately, My metalink subscription has expired and has not yet been renewed. I intend bringing this issue up again.

      There is a memory dump in instance_name_pspo_xxxx.trc

      I will be bringing up the lack of metalink issue yet again.

      I have trace files generated for the following processes:

      mmon basic manageability
      psp process spawner
      q queue monitor

      Any idea of the likely causes of this error.
      The database was up and running for a few days.
      Its a basic standard install using oracle managed files and file system for database storage.
      It crashed at 3am so no-one was doing anything. There is generally not much activity on the db and it does have sufficient space, etc.
      Thread 1 advanced to log sequence 55
        Current log# 3 seq# 55 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\SCMS\ONLINELOG\O1_MF_3_4MWT2V6C_.LOG
        Current log# 3 seq# 55 mem# 1: C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\SCMS\ONLINELOG\O1_MF_3_4MWT2X5C_.LOG
      Tue Jan 06 06:00:00 2009
      Unable to restore resource manager plan to '':
      ORA-02097: Message 2097 not found; No message file for product=RDBMS, facility=ORA
      ORA-00439: Message 439 not found; No message file for product=RDBMS, facility=ORA; arguments: [Database resource manager]
      Wed Jan 07 03:00:06 2009
      Process startup failed, error stack:
      Wed Jan 07 03:00:06 2009
      Errors in file c:\oracle\product\10.2.0\admin\scms\bdump\scms_psp0_2364.trc:
      ORA-27300: Message 27300 not found; No message file for product=RDBMS, facility=ORA; arguments: [GetThreadTimes] [6]
      ORA-27301: Message 27301 not found; No message file for product=RDBMS, facility=ORA; arguments: [The handle is invalid.]
      ORA-27302: Message 27302 not found; No message file for product=RDBMS, facility=ORA; arguments: [skgpspawn]
      
      Wed Jan 07 03:00:06 2009
      Errors in file c:\oracle\product\10.2.0\admin\scms\bdump\scms_psp0_2364.trc:
      ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [784] [0x32A09868] [0x2F7B7B80] [1]
      
      Wed Jan 07 03:00:08 2009
      Errors in file c:\oracle\product\10.2.0\admin\scms\bdump\scms_psp0_2364.trc:
      ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [784] [0x32A09868] [0x2F7B7B80] [1]
      
      *PSP0: terminating instance due to error 490*