4 Replies Latest reply on Nov 29, 2012 1:58 PM by Adi Md

    Demantra Installation insufficient privileges error

    Adi Md
      Hi All,

      I am trying to install standalone Demantra on my machine.
      I have successfully installed Database on the machine.

      However while trying to install Demantra I am getting error 'ORA-01031: insufficient privileges'.
      Now the DB user 'SYSTEM' that I am entering at the start of installation for database validation has all the permissions set.

      Appreciate if any one can help on this.

      Regards
        • 1. Re: Demantra Installation insufficient privileges error
          Hussein Sawwan-Oracle
          Please see these docs.

          Demantra 7.3 Installation Unable To Create Db Objects In Database - ORA -01031 [ID 1339139.1]
          Insufficient Privileges Error encountered in Demantra BUILD_TEMP_TABLE ORA-01031: Insufficient Privileges [ID 730297.1]

          Thanks,
          Hussein
          1 person found this helpful
          • 2. Re: Demantra Installation insufficient privileges error
            Adi Md
            Thanks Hussein,

            The document has following line -
            If you are not allow to use sys, you may use another DBA_ADMIN user . Please add the following grants to DEM_TEST user:

            I am confused on this. Do I need to create DBA_ADMIN and DM_TEST both the users and allow grants to both the users?
            Then which one I am supposed to enter as DBA user for Demantra installation?

            Appreciate if you can clarify.

            Regards
            • 3. Re: Demantra Installation insufficient privileges error
              Hussein Sawwan-Oracle
              968951 wrote:
              Thanks Hussein,

              The document has following line -
              If you are not allow to use sys, you may use another DBA_ADMIN user . Please add the following grants to DEM_TEST user:

              I am confused on this. Do I need to create DBA_ADMIN and DM_TEST both the users and allow grants to both the users?
              Then which one I am supposed to enter as DBA user for Demantra installation?

              Appreciate if you can clarify.

              Regards
              Use sys user. If you do not want to use sys user then you need to follow the steps in the doc. If you are getting this ORA error as sys user, then please see these docs.

              Troubleshooting ORA-1031: Insufficient Privileges While Connecting As SYSDBA [ID 730067.1]
              ORA-1031 When Connecting Remotely AS SYSDBA [ID 470832.1]
              Checklist for Resolving CONNECT AS SYSDBA (INTERNAL) Issues [ID 233223.1]

              Thanks,
              Hussein
              1 person found this helpful
              • 4. Re: Demantra Installation insufficient privileges error
                Adi Md
                Hi,

                I granted SYSDBA to the user SCOTT and granted following permissions as well to this user -
                grant create any synonym to SCOTT;
                grant ALTER any INDEX TO SCOTT;
                grant ALTER any PROCEDURE TO SCOTT;
                grant ALTER any TABLE TO SCOTT;
                grant CREATE any PROCEDURE TO SCOTT;
                grant CREATE any VIEW TO SCOTT;
                grant CREATE SEQUENCE TO SCOTT;
                grant CREATE TABLE TO SCOTT;
                grant DELETE any TABLE TO SCOTT;
                grant INSERT any TABLE TO SCOTT;
                grant select any table to SCOTT;
                GRANT CREATE any SNAPSHOT TO SCOTT;
                grant execute any procedure to SCOTT;
                GRANT CREATE USER TO SCOTT;
                GRANT SELECT_CATALOG_ROLE TO SCOTT;
                GRANT SELECT ANY DICTIONARY TO SCOTT;
                grant create any trigger to SCOTT;
                grant connect to SCOTT WITH ADMIN OPTION;
                grant create any synonym to SCOTT;
                grant ALTER any INDEX TO SCOTT;
                grant ALTER any PROCEDURE TO SCOTT;
                grant ALTER any TABLE TO SCOTT;
                grant CREATE any PROCEDURE TO SCOTT;
                grant CREATE any VIEW TO SCOTT;
                grant CREATE SEQUENCE TO SCOTT;
                grant CREATE TABLE TO SCOTT;
                grant DELETE any TABLE TO SCOTT;
                grant INSERT any TABLE TO SCOTT;
                grant select any table to SCOTT;
                GRANT CREATE any SNAPSHOT TO SCOTT;
                grant execute any procedure to SCOTT;
                GRANT CREATE USER TO SCOTT;
                GRANT SELECT_CATALOG_ROLE TO SCOTT;
                GRANT SELECT ANY DICTIONARY TO SCOTT;
                ALTER USER SCOTT QUOTA UNLIMITED ON USERS;
                ALTER USER SCOTT QUOTA UNLIMITED ON SYSAUX;

                I am still getting error in Demantra installation for 'Recreate User' insufficient privileges.