Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-16327

Cannot create subwiki with Oracle database: ORA-01950: no privileges on tablespace 'USERS'

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 12.8, 12.6.3, 11.10.11
    • 8.4.4, 9.11.8, 11.2, 10.11.5
    • Old Core
    • Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production under Oracle Linux (developer instance running in Virtual Box Version 5.2.18_Ubuntu r123745) but also reported for Oracle DB 12.2.0.1
    • Unknown
    • N/A

    Description

      If trying to create a subwiki (here just named "subwiki") with Oracle DB set up as described in https://www.xwiki.org/xwiki/bin/view/Documentation/AdminGuide/Installation/InstallationWAR/InstallationOracle/, the last step creates an error message:

      The wiki subwiki has been created but some pages have not been installed. Consequently, the wiki might behave erroneously and you should probably delete it. 
      

      The install log output starts with:

          Starting job of type [wikicreationjob] with identifier [wikicreation/createandinstall/subwiki]
          SQL Error: 1950, SQLState: 42000
          ORA-01950: no privileges on tablespace 'USERS'
          ORA-01950: no privileges on tablespace 'USERS'
      

      Full log in error-log-ui-xwiki-11.2.txt

      If one checks the database before deleting the broken wiki, one gets the following result:

      SQL> SELECT DISTINCT TABLESPACE_NAME FROM DBA_TABLES WHERE OWNER = 'SUBWIKI';
      
      TABLESPACE_NAME               
      ------------------------------
      USERS                         
      

      Checking for select table_name, tablespace_name, owner from dba_tables where owner = 'SUBXWIKI' shows that all tables for the XWiki DB have been created, but in the tablespace USERS instead of the prepared tablespace XWIKI where the tables (and data) for the main wiki resides, too.

      Attachments

        1. 2019_04_12.output_dba.log
          263 kB
          Ilie Andriuta
        2. Create_sub_Oracle_12_dba.jpg
          127 kB
          Ilie Andriuta
        3. Create_sub_Oracle_12_non_dba.jpg
          278 kB
          Ilie Andriuta
        4. error-log-ui-xwiki-11.2.txt
          17 kB
          Clemens Robbenhaar

        Issue Links

          Activity

            People

              vmassol Vincent Massol
              camil7 Clemens Robbenhaar
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: