Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

end of file communication error

Received Response
41
Views
13
Comments
Anirban1
Anirban1 Rank 4 - Community Specialist
edited Aug 13, 2024 5:26PM in Oracle Analytics Cloud and Server

Hi,

We are getting ora-03113 end of file communication channel process id error in one of the dashboard which contain 3,4  reports. All the reports giving the same error. If I restart the services it is coming fine, but after some time again we are getting same errir. Can you please suggest what might be the problem and how can we fix this. We are using OBIEE 12c.

Thanks

Anirban

«1

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Take a look at this thread - Obiee General Problem

  • Anirban1
    Anirban1 Rank 4 - Community Specialist

    Hi Joel,

    Thanks for your reply. This solved my problem. I will monitor this for couple of days and will update you.

    Thanks once again for your help.

    Thanks

    Anirban

  • Joel
    Joel Rank 8 - Analytics Strategist

    No problem. Happy to help.

  • Anirban1
    Anirban1 Rank 4 - Community Specialist

    Hi Joel,

    We are still facing the same issue again, we have implemented the same mention in the link and bounce OBIEE. Can you please suggest.

    Thanks

    Anirban

  • Joel
    Joel Rank 8 - Analytics Strategist

    Did you Disable Out Of Band Breaks (OOB)?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    The fastest s/gun/support entry finder in the west :-)

  • Joel
    Joel Rank 8 - Analytics Strategist

  • Anirban1
    Anirban1 Rank 4 - Community Specialist

    Hi Christian,

    Correct .

    @Joel

    DISABLE_OOB=ON

    SQLNET.SEND_TIMEOUT=900

    SQLNET.RECV_TIMEOUT=900

    This is the entry currently in sqlnet.ora file.

    Do I need to change anything in this.

    Thanks

    Anirban

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Normally that is the solution, yes.

  • Anirban1
    Anirban1 Rank 4 - Community Specialist

    Thanks Christian,

    It is already in place, I have restart OBIEE services, then cleared cache from my browser, in some of the reports I am getting error, but while trying using inprivate browsing it is perfectly working fine.

    Assuming it is the problem with cache for local browser, is it right?

    Thanks

    Anirban