Salesforce

Why do size scaling runs get exception ORA-03113?

Printable View
« Go Back

Information

 
TitleWhy do size scaling runs get exception ORA-03113?
SummaryAfter submitting size scaling runs they are failing with Oracle error ORA-03113.
URL NameWhy-do-size-scaling-runs-get-exception-ORA-03113
Resolution
 This only applies in a non-RAC environment, Oracle Net Services - Version 10.2.0.1 to 12.1.0.2 .
  1. Go to the database server.
  2. Edit the listener.ora file of the corresponding oracle installation.
  3. Add the following parameter to the file:  SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF
  4. Save the listener.ora file.
  5. Restart the listener in the Services screen.
ProductsSize Scaling
ModuleSize Scaling Run
Version8.0
Error Message Code
"Oracle.DataAccess.Client.OracleException ORA-03113 : end-of-file on communication channel."
Cause
Additional Information
In the listener.log of the corresponding oracle installation may display the warning:
"
WARNING: Subscription for node down event still pending'.
These messages are related to the Oracle TNS Listener's default subscription to the Oracle Notification Service (ONS).
"
documenting that the listener hangs.
Publication StatusPublished
Powered by