8 Replies Latest reply: Oct 18, 2012 8:57 AM by Sunny kichloo RSS

    ORA-00472: PMON  process terminated with error

    581660
      Hello,

      We are using Oracle 10G (10.2.0.2.0) and after creating a materialized view (with aprox 32 GB in the TEMP Tablespace) we are getting the error ORA-00472: PMON process terminated with error, and we cannot make any transaction on the database.

      We can startup the database, however after aprox 51 sec the database shutdowns itself.

      The alert log shows the following:

      Starting ORACLE instance (normal)
      LICENSE_MAX_SESSION = 0
      LICENSE_SESSIONS_WARNING = 0
      Picked latch-free SCN scheme 2
      Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
      Autotune of undo retention is turned on.
      IMODE=BR
      ILAT =18
      LICENSE_MAX_USERS = 0
      SYS auditing is disabled
      ksdpec: called for event 13740 prior to event group initialization
      Starting up ORACLE RDBMS Version: 10.2.0.2.0.
      System parameters with non-default values:
      processes = 150
      __shared_pool_size = 150994944
      __large_pool_size = 4194304
      __java_pool_size = 12582912
      __streams_pool_size = 4194304
      sga_target = 775946240
      control_files = C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ORADATA\BIEPME\CONTROL01.CTL, C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ORADATA\BIEPME\CONTROL02.CTL, C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ORADATA\BIEPME\CONTROL03.CTL
      db_block_size = 8192
      __db_cache_size = 595591168
      compatible = 10.2.0.2.0
      db_file_multiblock_read_count= 16
      db_recovery_file_dest = c:\Programas\oracle\product\10.2.0\flash_recovery_area
      db_recovery_file_dest_size= 2147483648
      undo_management = AUTO
      undo_tablespace = UNDOTBS1
      remote_login_passwordfile= EXCLUSIVE
      db_domain =
      dispatchers = (PROTOCOL=TCP) (SERVICE=BIEPMEXDB)
      job_queue_processes = 10
      audit_file_dest = C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ADMIN\BIEPME\ADUMP
      background_dump_dest = C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ADMIN\BIEPME\BDUMP
      user_dump_dest = C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ADMIN\BIEPME\UDUMP
      core_dump_dest = C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ADMIN\BIEPME\CDUMP
      db_name = BIEPME
      open_cursors = 300
      pga_aggregate_target = 256901120
      PMON started with pid=2, OS id=4668
      PSP0 started with pid=3, OS id=4952
      MMAN started with pid=4, OS id=4080
      DBW0 started with pid=5, OS id=4956
      LGWR started with pid=6, OS id=2964
      CKPT started with pid=7, OS id=4972
      SMON started with pid=8, OS id=4228
      RECO started with pid=9, OS id=4692
      CJQ0 started with pid=10, OS id=3356
      MMON started with pid=11, OS id=3828
      MMNL started with pid=12, OS id=3728
      Thu Apr 09 20:17:37 2009
      starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
      starting up 1 shared server(s) ...
      Thu Apr 09 20:17:38 2009
      ALTER DATABASE MOUNT
      Thu Apr 09 20:17:42 2009
      Setting recovery target incarnation to 1
      Thu Apr 09 20:17:42 2009
      Successful mount of redo thread 1, with mount id 662539554
      Thu Apr 09 20:17:42 2009
      Database mounted in Exclusive Mode
      Completed: ALTER DATABASE MOUNT
      Thu Apr 09 20:17:43 2009
      ALTER DATABASE OPEN
      Thu Apr 09 20:17:43 2009
      Beginning crash recovery of 1 threads
      parallel recovery started with 2 processes
      Thu Apr 09 20:17:44 2009
      Started redo scan
      Thu Apr 09 20:17:45 2009
      Completed redo scan
      6831 redo blocks read, 663 data blocks need recovery
      Thu Apr 09 20:17:45 2009
      Started redo application at
      Thread 1: logseq 1016, block 3
      Thu Apr 09 20:17:45 2009
      Recovery of Online Redo Log: Thread 1 Group 2 Seq 1016 Reading mem 0
      Mem# 0 errs 0: C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ORADATA\BIEPME\REDO02.LOG
      Thu Apr 09 20:17:46 2009
      Completed redo application
      Thu Apr 09 20:17:46 2009
      Completed crash recovery at
      Thread 1: logseq 1016, block 6834, scn 120944929
      663 data blocks read, 663 data blocks written, 6831 redo blocks read
      Thu Apr 09 20:17:47 2009
      Thread 1 advanced to log sequence 1017
      Thread 1 opened at log sequence 1017
      Current log# 3 seq# 1017 mem# 0: C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ORADATA\BIEPME\REDO03.LOG
      Successful open of redo thread 1
      Thu Apr 09 20:17:47 2009
      MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
      Thu Apr 09 20:17:47 2009
      SMON: enabling cache recovery
      Thu Apr 09 20:17:48 2009
      Successfully onlined Undo Tablespace 1.
      Thu Apr 09 20:17:48 2009
      SMON: enabling tx recovery
      Thu Apr 09 20:17:49 2009
      Database Characterset is WE8MSWIN1252
      replication_dependency_tracking turned off (no async multimaster replication found)
      Starting background process QMNC
      QMNC started with pid=20, OS id=5092
      Thu Apr 09 20:17:52 2009
      Doing block recovery for file 4 block 41975
      Doing block recovery for file 4 block 41975
      Block recovery from logseq 1017, block 53 to scn 120944983
      Thu Apr 09 20:17:52 2009
      Recovery of Online Redo Log: Thread 1 Group 3 Seq 1017 Reading mem 0
      Mem# 0 errs 0: C:\PROGRAMAS\ORACLE\PRODUCT\10.2.0\ORADATA\BIEPME\REDO03.LOG
      Block recovery completed at rba 1017.57.16, scn 0.120944984
      Thu Apr 09 20:17:54 2009
      db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
      user-specified limit on the amount of space that will be used by this
      database for recovery-related files, and does not reflect the amount of
      space available in the underlying filesystem or ASM diskgroup.
      Thu Apr 09 20:17:55 2009
      Completed: ALTER DATABASE OPEN

      Then when after 51 sec, everytime that we try to make a query the alert log catches the following:

      Thu Apr 09 20:18:40 2009
      PSP0: terminating instance due to error 472
      Thu Apr 09 20:18:40 2009
      Errors in file c:\programas\oracle\product\10.2.0\admin\biepme\bdump\biepme_mman_4080.trc:
      ORA-00472: PMON process terminated with error

      Thu Apr 09 20:18:40 2009
      Errors in file c:\programas\oracle\product\10.2.0\admin\biepme\bdump\biepme_dbw0_4956.trc:
      ORA-00472: PMON process terminated with error

      Thu Apr 09 20:18:40 2009
      Errors in file c:\programas\oracle\product\10.2.0\admin\biepme\bdump\biepme_j003_4920.trc:
      ORA-00472: PMON process terminated with error

      Thu Apr 09 20:18:40 2009
      Errors in file c:\programas\oracle\product\10.2.0\admin\biepme\bdump\biepme_reco_4692.trc:
      ORA-00472: PMON process terminated with error

      Thu Apr 09 20:18:40 2009
      Errors in file c:\programas\oracle\product\10.2.0\admin\biepme\bdump\biepme_lgwr_2964.trc:
      ORA-00472: PMON process terminated with error

      Thu Apr 09 20:18:40 2009
      Errors in file c:\programas\oracle\product\10.2.0\admin\biepme\bdump\biepme_j002_3240.trc:
      ORA-00472: PMON process terminated with error

      Thu Apr 09 20:18:40 2009
      Errors in file c:\programas\oracle\product\10.2.0\admin\biepme\bdump\biepme_j001_5244.trc:
      ORA-00472: PMON process terminated with error

      Thu Apr 09 20:18:40 2009
      Errors in file c:\programas\oracle\product\10.2.0\admin\biepme\bdump\biepme_j000_5060.trc:
      ORA-00472: PMON process terminated with error

      Thu Apr 09 20:18:40 2009
      Doing block recovery for file 2 block 57
      Thu Apr 09 20:18:41 2009
      Errors in file c:\programas\oracle\product\10.2.0\admin\biepme\bdump\biepme_ckpt_4972.trc:
      ORA-00472: PMON process terminated with error

      Thu Apr 09 20:18:42 2009
      Instance terminated by PSP0, pid = 4952


      How can we solve this?

      Thanks for your help.

      NF
        • 1. Re: ORA-00472: PMON  process terminated with error
          678145
          What is in trace files? Post content of one file.
          Did You tried to drop that one created materialized view?
          Are there any ORA-600 errors in alert.log?
          • 2. Re: ORA-00472: PMON  process terminated with error
            581660
            Hello,

            In the trace files I have the following:

            -----------------
            Dump file c:\programas\oracle\product\10.2.0\admin\biepme\bdump\biepme_mman_4080.trc
            Thu Apr 09 20:18:40 2009
            ORACLE V10.2.0.2.0 - Production vsnsta=0
            vsnsql=14 vsnxtr=3
            Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
            With the Partitioning, OLAP and Data Mining options
            Windows NT Version V5.2 Service Pack 1
            CPU : 2 - type 586, 1 Physical Cores
            Process Affinity : 0x00000000
            Memory (Avail/Total): Ph:3266M/4095M, Ph+PgF:6803M/8024M, VA:1086M/2047M
            Instance name: biepme

            Redo thread mounted by this instance: 1

            Oracle process number: 4

            Windows thread id: 4080, image: ORACLE.EXE (MMAN)


            *** 2009-04-09 20:18:40.218
            *** SERVICE NAME:(SYS$BACKGROUND) 2009-04-09 20:18:40.218
            *** SESSION ID:(168.1) 2009-04-09 20:18:40.218
            error 472 detected in background process
            ORA-00472: PMON process terminated with error
            -----------------
            OR
            -----------------
            Dump file c:\programas\oracle\product\10.2.0\admin\biepme\bdump\biepme_dbw0_4956.trc
            Thu Apr 09 20:18:40 2009
            ORACLE V10.2.0.2.0 - Production vsnsta=0
            vsnsql=14 vsnxtr=3
            Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
            With the Partitioning, OLAP and Data Mining options
            Windows NT Version V5.2 Service Pack 1
            CPU : 2 - type 586, 1 Physical Cores
            Process Affinity : 0x00000000
            Memory (Avail/Total): Ph:3268M/4095M, Ph+PgF:6808M/8024M, VA:1094M/2047M
            Instance name: biepme

            Redo thread mounted by this instance: 1

            Oracle process number: 5

            Windows thread id: 4956, image: ORACLE.EXE (DBW0)


            *** 2009-04-09 20:18:40.281
            *** SERVICE NAME:(SYS$BACKGROUND) 2009-04-09 20:18:40.281
            *** SESSION ID:(167.1) 2009-04-09 20:18:40.281
            error 472 detected in background process
            ORA-00472: PMON process terminated with error

            -----------------

            I've tried to delete the Materialized View, but when I startup my database, after aprox 51 seconds, the instance shutdowns itself and it cannot delete the materialized view.

            In the alert.log there's no reference to ORA-600 errors.

            Do you have any suggestion?

            Thanks.

            NF
            • 3. Re: ORA-00472: PMON  process terminated with error
              581660
              Hello again,

              I've notice that one of the trace files has this:

              Redo thread mounted by this instance: 1

              Oracle process number: 22

              Windows thread id: 4948, image: ORACLE.EXE (J001)


              *** SERVICE NAME:(SYS$USERS) 2009-04-10 17:05:28.296
              *** SESSION ID:(146.1) 2009-04-10 17:05:28.296
              java.io.IOException: service early exit: code=1 : err=The system cannot find the path specified.

              : out=

                   at oracle.wh.runtime.server.Util.execRuntimeService(Util.java:122)

              *** 2009-04-10 17:06:07.406
              *** SERVICE NAME:(SYS$USERS) 2009-04-10 17:06:07.406
              *** SESSION ID:(146.3) 2009-04-10 17:06:07.406
              error 472 in job queue process
              ORA-00472: PMON process terminated with error

              What path is this?

              Thanks.

              NF
              • 4. Re: ORA-00472: PMON  process terminated with error
                user615239
                Hi,

                Our system generates the following trace file about every 6 minutes....... so lots of trace files generated. I have the same question: What path?

                Dump file d:\oracle\admin\asaods\bdump\asaods_j000_15484.trc
                Fri May 22 11:05:51 2009
                ORACLE V10.2.0.4.0 - Production vsnsta=0
                vsnsql=14 vsnxtr=3
                Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
                With the Partitioning, OLAP, Data Mining and Real Application Testing options
                Windows Server 2003 Version V5.2 Service Pack 1
                CPU : 2 - type 586, 1 Physical Cores
                Process Affinity : 0x00000000
                Memory (Avail/Total): Ph:4487M/8191M, Ph+PgF:6462M/9990M, VA:1615M/3071M
                Instance name: asaods

                Redo thread mounted by this instance: 1

                Oracle process number: 17

                Windows thread id: 15484, image: ORACLE.EXE (J000)


                *** 2009-05-22 11:05:51.722
                *** ACTION NAME:() 2009-05-22 11:05:51.691
                *** MODULE NAME:() 2009-05-22 11:05:51.691
                *** SERVICE NAME:(SYS$USERS) 2009-05-22 11:05:51.691
                *** SESSION ID:(311.19656) 2009-05-22 11:05:51.691
                java.io.IOException: service early exit: code=1 : err=The system cannot find the path specified.

                : out=

                     at oracle.wh.runtime.server.Util.execRuntimeService(Util.java:122)



                Thanks your help.

                CJ
                • 5. Re: ORA-00472: PMON  process terminated with error
                  959341
                  Hello
                  Reference to your error ORA-00472: PMON process terminated with error;
                  Since it is very old issue with your database, we are having the same problem, Have you got any solution over the issue or found any reasons behind the abnormal crashing.
                  Please share
                  Thanks
                  • 6. Re: ORA-00472: PMON  process terminated with error
                    969266
                    hi
                    i am getting same error as given below


                    ORA-00600: internal error code, arguments: [17112], [0x0B21580A8], [], [], [], [], [], [], [], [], [], []
                    PMON (ospid: 22081): terminating the instance due to error 472
                    Thu Oct 18 14:45:29 2012
                    Errors in file /u001/SIT/db/tech_st/11.1.0/admin/SIT_fech3251vm/diag/rdbms/sit/SIT/trace/SIT_m000_7584.trc:
                    ORA-00472: PMON process terminated with error
                    Instance terminated by PMON, pid = 22081
                    Thu Oct 18 14:51:16 2012


                    kindly help me ASAP..
                    • 7. Re: ORA-00472: PMON  process terminated with error
                      Fran
                      Did you check the date of the post?....
                      ....open a SR.....

                      ......*ASAP*
                      • 8. Re: ORA-00472: PMON  process terminated with error
                        Sunny kichloo
                        Its better if you create your Own Thread instead of posting in Some other User Thread and For ORA-00600 Raise an Oracle SR.