Forum Discussion

wilson_smyth's avatar
wilson_smyth
Icon for Post Patron rankPost Patron
7 years ago

Intermittently getting oracle ORA-03113 error

Im populating my data from an oracle database. Intermittently i am getting an "ORA-03113 end-of-file on communication channel process ID:12345 Session ID:12 Serial number:12345" error adn the refresh fails.

if i run it again, it generally works.

 

As it works some of the time, it indicates the quries are syntactically valid. Im unsure why this issue only happens intermittenly.

Appreciate any advice or theories

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi wilson_smyth,

     

    Based on my research, this error could be caused by several reasons, such as a server machine crashing, network issues, internal errors on the server, your server process being ended at the operating-system level, or a client having issues handling multiple connections. Reference: ORA-03113: End-of-file On Communication Channel

     

    Best regards,

    Yuliana Gu