4 Replies Latest reply on Jun 8, 2018 12:22 PM by nydn

    SYS.VALIDATE_ORDS missing

    nydn

      Hey there,

       

      We are having a strange issue for quite some time now: we cannot upgrade from the actual version of ORDS (v3.0.4.60.12.48) in the Database to a newer version, because of a missing VALIDATE_ORDS object.

      It wasn't that much of an issue so far, because ORDS and APEX is working fine, but since APEX 18.1 is out now and we would want to use the new REST Enabled SQL feature eventually, it would be great if we could fix this problem.

       

      We tried to do an upgrade with almost every existing newer versions of ORDS, but the problem is the same always:

      Verify ORDS schema in Database Configuration apex with connection host: **** port: ***** sid: *****
      
      Please login with SYSDBA privileges to verify Oracle REST Data Services schema.
      
      Enter the username with SYSDBA privileges to verify the installation [SYS]:
      Enter the database password for SYS:
      Confirm password:
      Upgrading Oracle REST Data Services schema 3.0.4.60.12.48 to version 3.0.6.176.08.46
      ... Log file written to /root/ords36/logs/ords_upgrade_2018-05-31_113146_00545.log
      Upgrading ORDS schema to 3.0.5
      java.io.IOException: Error executing script: upg_ords_grant_privs.sql Error: ORA-04042: procedure, function, package, or package body does not exist
      
      
      Error starting at line : 49 in command -
      grant execute on sys.validate_ords       to ^ORDSUSER
      Error report -
      ORA-04042: procedure, function, package, or package body does not exist
      
       Refer to log file /root/ords36/logs/ords_upgrade_2018-05-31_113146_00545.log for details
          at oracle.dbtools.installer.Runner.executeSQLScript(Runner.java:152)
          at oracle.dbtools.installer.Runner.executeScripts(Runner.java:94)
          at oracle.dbtools.installer.Runner.executeScripts(Runner.java:48)
          at oracle.dbtools.installer.Installer.upgradeORDS(Installer.java:482)
          at oracle.dbtools.installer.Installer.pdbOrNonCDBProcessing(Installer.java:112)
          at oracle.dbtools.installer.Installer.execute(Installer.java:78)
          at oracle.dbtools.rt.config.setup.SchemaSetup.install(SchemaSetup.java:53)
          at oracle.dbtools.rt.config.setup.VerifySchema.execute(VerifySchema.java:86)
          at oracle.dbtools.cmdline.DefaultCommand.execute(DefaultCommand.java:98)
          at oracle.dbtools.cmdline.Commands.execute(Commands.java:195)
          at oracle.dbtools.cmdline.Commands.main(Commands.java:155)
          at oracle.dbtools.cmdline.Commands.main(Commands.java:348)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:497)
          at oracle.dbtools.jarcl.Entrypoint.main(Entrypoint.java:58)
      May 31, 2018 11:31:50 AM oracle.dbtools.installer.Installer pdbOrNonCDBProcessing
      SEVERE: Error executing script: upg_ords_grant_privs.sql Error: ORA-04042: procedure, function, package, or package body does not exist
      
      
      Error starting at line : 49 in command -
      grant execute on sys.validate_ords       to ^ORDSUSER
      Error report -
      ORA-04042: procedure, function, package, or package body does not exist
      
       Refer to log file /root/ords36/logs/ords_upgrade_2018-05-31_113146_00545.log for details
      

       

      Log file contains no further informations, see https://pastebin.com/apAWqBj3

       

      Validation runs into the same error.

       

      ORDS: v3.0.4.60.12.48

      DB: Oracle Database 12c Release 12.1.0.1.0 - 64bit Production

      However, it was upgraded from 11.2 a few years ago.

       

      Thanks for any input on this.