Error after database upgrade, Job Server Status error: "The underlying connection was closed: An unexpected error occurred on a receive."

Hi All,

This morning we had a DB upgrade from SQL Server 13.0.5893.48  to 14.0.3451.2. Running OneIM 7.1.3.

After restart the Develop system gave an error in the JobQueueInfo.net - Job Server Status - Job Server: The underlying connection was closed: An unexpected error occurred on a receive.

Anybody a clue?

Regards, Hans

Parents
  • Use these troubleshooting tips to address errors or issues that you may encounter while upgrading your database.

    Also review the related links to learn about changes that affect this release, which may be related to errors you receive, and to see how to rerun the upgrade after you resolve errors.

    About Starting Oracle Database in Upgrade Mode
    When you start Oracle Database in upgrade mode, you can only run queries on fixed views. If you attempt to run other views or PL/SQL, then you receive errors.
    Running DBUA with Different ORACLE_HOME Owner
    Review this topic if your Oracle Database homes are owned by different operating system user accounts, or you encounter an upgrade.xml not found error.
    Invalid Object Warnings and DBA Registry Errors
    Before you start your upgrade, Oracle strongly recommends that you run the preupgrade information tool (preupgrd.jar).
    Invalid Objects and Premature Use of Postupgrade Tool
    Never run the postupgrade status tool for the new Oracle Database release (utlusts.sql) until after you complete the upgrade.
    Resolving Oracle Database Upgrade Script Termination Errors
    Review this section if you encounter ORA-00942, ORA-00904, or ORA-01722 errors.
    Troubleshooting Causes of Resource Limits Errors while Upgrading Oracle Database
    Review this section if you encounter ORA-01650, ORA-01651, ORA-01652, ORA-01653, ORA-01654, ORA-01655, ORA-0431, ORA-01562, ORA-19815, or other errors that suggest resource limit errors.
    Resolving SQL*Plus Edition Session Startup Error for Oracle Database
    Use this section to understand and resolve SP2–1540: "Oracle Database cannot startup in an Edition session."
    Error ORA-00020 Maximum Number of Processes Exceeded When Running utlrp.sql
    This error may indicate that your Oracle configuration does not have sufficient number of processes available for the recompile.
    Fixing ORA-28365: Wallet Is Not Open Error
    If you use Oracle wallet with Transparent Data Encryption (TDE), and you use Database Upgrade Assistant (DBUA) to upgrade the database, then you can encounter an ORA-28365 "wallet is not open" error.
    Resolving issues with view CDB_JAVA_POLICY
    If the view CDB_JAVA_POLICY becomes invalid, then use this procedure.
    Continuing Upgrades After Server Restarts (ADVM/ACFS Driver Error)
    On Windows platforms, an error may occur related to ADVM or ACFS drivers if a server restarts during an upgrade.
    Component Status and Upgrades
    Component status settings are affected both by the components that you previously installed, and by the support of those components for upgrades.
    Standard Edition Starter Database and Components with Status OPTION OFF
    Starting in Oracle Database 18c (18.1), all OPTION OFF components are upgraded to the new release, but these options are disabled for Oracle Database Standard Edition (SE) remain OPTION OFF.
    Adjusting Oracle ASM Password File Location After Upgrade
    You must create a new password file for Oracle ASM after an Oracle Grid Infrastructure upgrade.
    Fixing "Warning XDB Now Invalid" Errors with Pluggable Database Upgrades
    Review this topic if you encounter "Warning: XDB now invalid, invalid objects found” errors when upgrading pluggable databases (PDBs).
    Fixing ORA-27248: sys.dra_reevaluate_open_failures is running
    Use this procedure to identify DRA_REEVALUATE_OPEN_FAILURES jobs that block upgrades.
    Fixing Failed Upgrades Where Only Datapatch Fails
    If only datapatch fails during an upgrade, then rerun datapatch directly.

    This may help you,

    Rachel Gomez

Reply
  • Use these troubleshooting tips to address errors or issues that you may encounter while upgrading your database.

    Also review the related links to learn about changes that affect this release, which may be related to errors you receive, and to see how to rerun the upgrade after you resolve errors.

    About Starting Oracle Database in Upgrade Mode
    When you start Oracle Database in upgrade mode, you can only run queries on fixed views. If you attempt to run other views or PL/SQL, then you receive errors.
    Running DBUA with Different ORACLE_HOME Owner
    Review this topic if your Oracle Database homes are owned by different operating system user accounts, or you encounter an upgrade.xml not found error.
    Invalid Object Warnings and DBA Registry Errors
    Before you start your upgrade, Oracle strongly recommends that you run the preupgrade information tool (preupgrd.jar).
    Invalid Objects and Premature Use of Postupgrade Tool
    Never run the postupgrade status tool for the new Oracle Database release (utlusts.sql) until after you complete the upgrade.
    Resolving Oracle Database Upgrade Script Termination Errors
    Review this section if you encounter ORA-00942, ORA-00904, or ORA-01722 errors.
    Troubleshooting Causes of Resource Limits Errors while Upgrading Oracle Database
    Review this section if you encounter ORA-01650, ORA-01651, ORA-01652, ORA-01653, ORA-01654, ORA-01655, ORA-0431, ORA-01562, ORA-19815, or other errors that suggest resource limit errors.
    Resolving SQL*Plus Edition Session Startup Error for Oracle Database
    Use this section to understand and resolve SP2–1540: "Oracle Database cannot startup in an Edition session."
    Error ORA-00020 Maximum Number of Processes Exceeded When Running utlrp.sql
    This error may indicate that your Oracle configuration does not have sufficient number of processes available for the recompile.
    Fixing ORA-28365: Wallet Is Not Open Error
    If you use Oracle wallet with Transparent Data Encryption (TDE), and you use Database Upgrade Assistant (DBUA) to upgrade the database, then you can encounter an ORA-28365 "wallet is not open" error.
    Resolving issues with view CDB_JAVA_POLICY
    If the view CDB_JAVA_POLICY becomes invalid, then use this procedure.
    Continuing Upgrades After Server Restarts (ADVM/ACFS Driver Error)
    On Windows platforms, an error may occur related to ADVM or ACFS drivers if a server restarts during an upgrade.
    Component Status and Upgrades
    Component status settings are affected both by the components that you previously installed, and by the support of those components for upgrades.
    Standard Edition Starter Database and Components with Status OPTION OFF
    Starting in Oracle Database 18c (18.1), all OPTION OFF components are upgraded to the new release, but these options are disabled for Oracle Database Standard Edition (SE) remain OPTION OFF.
    Adjusting Oracle ASM Password File Location After Upgrade
    You must create a new password file for Oracle ASM after an Oracle Grid Infrastructure upgrade.
    Fixing "Warning XDB Now Invalid" Errors with Pluggable Database Upgrades
    Review this topic if you encounter "Warning: XDB now invalid, invalid objects found” errors when upgrading pluggable databases (PDBs).
    Fixing ORA-27248: sys.dra_reevaluate_open_failures is running
    Use this procedure to identify DRA_REEVALUATE_OPEN_FAILURES jobs that block upgrades.
    Fixing Failed Upgrades Where Only Datapatch Fails
    If only datapatch fails during an upgrade, then rerun datapatch directly.

    This may help you,

    Rachel Gomez

Children
No Data