4 Replies Latest reply on Jul 12, 2016 9:31 AM by Hari_639

    Problem while installing Oracle REST Data Services schema

    Hari_639

      Dear All,

       

      I'm trying to install ORDS 3.0 (ords.3.0.5.124.10.54) using below command

       

      java -jar ords.war install advanced
      

       

      When prompted whether to install ORDS schema or not, I chose to install..

       

      Enter the username with SYSDBA privileges to verify the installation [SYS]:
      

       

      When prompted for user with SYSDBA access I have given ADMIN_USER who has SYSDBA access (not SYS user)

       

      But with this user, I'm getting below error..

       

      ...
      Error starting at line : 6 in command -
      declare
          l_version varchar2(30) := null;
          invalid_alter_sess exception;
          pragma exception_init(invalid_alter_sess,-02248);
      begin
        if (sys.dbms_db_version.VERSION = 12) then
            execute immediate
              'select version from sys.registry$ where cid = ''CATPROC'''
              into l_version;
            
            -- dbms_output.put_line('Version: '||l_version||' CDB Install: '||'^2');
            if (l_version = '12.1.0.1.0') AND ('^2' = 'FALSE') then
              -- Non-CDB install. Do not use _ORACLE_SCRIPT parameter for 12.1.0.1.0
              null;
            else
              execute immediate 'alter session set "_ORACLE_SCRIPT"=^1';
            end if;
        end if;
      exception
        when invalid_alter_sess then
          null;
      end;
      Error report -
      ORA-02097: Parameter kann nicht verändert werden, da angegebener Wert ungültig ist
      ORA-01031: Nicht ausreichende Berechtigungen
      ORA-06512: in Zeile 16
      

       

      Question: Why am I getting this error even though provided user has SYSDBA role? Is it mandatory that I shall run this installation step only with SYS user? Please support.

       

      Database: Oracle DB EE 12.1.0.2.0 (No multi-tenant architecture)

      APEX: APEX 5.0.3

       

      Best Regards,

      Hari