8 Replies Latest reply: Apr 19, 2014 9:20 AM by 912595 RSS

    Reg: Exadata database error-

    ranit B

      Hi Experts,

       

      I am having some issues regarding ETL code being moved to an Exadata machine.

       

      Log:

      ORA-12801: error signaled in parallel query server P026, instance cccccc.bbb.aaaaa.com:prodx1 (1)

      ORA-01114: IO error writing block to file  (block # )

      ORA-01114: IO error writing block to file 1025 (block # 18048)

      ORA-29701: unable to connect to Cluster Synchronization Service

      ORA-29701: unable to connect to Cluster Synchronization Service

      ORA-29701: unable to connect to Cluster Synchronization Service

      ORA-29701: unable to connect to Cluster Synchronization Service

      ORA-29701: unable to connect to Cluster Synchronization Service

       

      My thinking says -

      1)

       

      ORA-12801: error signaled in parallel query server P026

       

      This error never comes alone, and always followed by other specific ORAs.

       

      2)

      ORA-01114: IO error writing block to file  (block # )

      (probably) When some process can't write data on to disk/file.

       

      3)

      ORA-29701: unable to connect to Cluster Synchronization Service

      Encounterd and read regarding this for the first time - ORACLE ACE DBA: ORA-29701: unable to connect to Cluster Synchronization Service

      and seems like I need to check the CSS status.

      Something looks like being offline and point (2) also points the same.

       

      Please advise on this.

       

      At this moment, I have very limited information. Please let me know if you need any specific info regarding this.

       

      Thanks,

      -- Ranit