oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01722: invalid number

Oracle Community | 974057 | 3 years ago
  1. 0

    which timezone DST Patch to apply in order to upgrade to 11.2.0.3 DB

    Oracle Community | 3 years ago | 974057
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01722: invalid number
  2. 0

    Failure in Oracle 11.2.3.0 upgrade

    Oracle Community | 3 years ago | JamesW
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01078: failure in processing system parameters
  3. 0

    ORA 03113

    Oracle Community | 5 years ago | 911294
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-03113: end-of-file on communication channel
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Upgrade from 10.2.0.5 to 11.2.0.4 fails

    Oracle Community | 1 year ago | goj
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-06550: line 5, column 38: PLS-00302: component 'JOB_TYPE_ID' must be declared ORA-06550: line 5, column 19: PL/SQL: Item ignored ORA-06550: line 6, column 40: PLS-00302: component 'MAJOR_VERSION' must be declared ORA-06550: line 6, column 21: PL/SQL: Item ignored ORA-06550: line 7, column 41: PLS-00302: component 'MINOR_VERSION1' must be declared ORA-06550: line 7, column 22: PL/SQL: Item ignored ORA-06550: line 8, column 41: PLS-00302: component 'MINOR_VERSION2' must be declared ORA-06550: line 8, column 22: PL/SQL: Item ignored ORA-06550: line 14, column 17: PLS-00302: component 'FIX_FLATTEN_STEPS' must be declared ORA-06550: line 14, column 1: PL/SQL: Statement ignored ORA-06550: line 15, column 51: PLS-00320: the declaration of the type of this expression is incomplete or
  6. 0

    error while installing oracle 10.2.0.1

    Oracle Community | 9 years ago | 577835
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12547: TNS:lost contact

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException

      ORA-01722: invalid number

      at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl()
    2. oracle.sysman.assistants
      StepContext$ModeRunner.run
      1. oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1658)
      2. oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1008)
      3. oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339)
      4. oracle.sysman.assistants.dbma.backend.component.ScriptDirective.processDirective(ScriptDirective.java:162)
      5. oracle.sysman.assistants.dbma.backend.component.SubComponent.executeSubStepImpl(SubComponent.java:679)
      6. oracle.sysman.assistants.dbma.backend.component.SubComponent.executeStepImpl(SubComponent.java:585)
      7. oracle.sysman.assistants.dbma.backend.component.Component.executeStepImpl(Component.java:317)
      8. oracle.sysman.assistants.dbma.backend.SummarizableStep.executeImpl(SummarizableStep.java:183)
      9. oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:210)
      10. oracle.sysman.assistants.util.step.Step.execute(Step.java:140)
      11. oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2708)
      11 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:637)
      1 frame