Changes for page Oracle Installation

Last modified by Vincent Massol on 2023/12/07

<
From version < 14.3 >
edited by Vincent Massol
on 2017/09/06
To version < 16.1 >
edited by Thomas Mortagne
on 2019/06/03
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.VincentMassol
1 +XWiki.ThomasMortagne
Content
... ... @@ -7,7 +7,7 @@
7 7  Steps:
8 8  
9 9  * Download and install a version of Oracle Database. For example [[Oracle Express>>http://www.oracle.com/technetwork/products/express-edition/downloads/index.html]].
10 -* Download the corresponding [[Oracle JDBC Drivers>>http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html]] and copy the JAR (e.g. ##ojdbc6.jar## in ##WEB-INF/lib/##)
10 +* Download the corresponding [[Oracle JDBC Drivers>>https://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html]] and copy the JAR (e.g. ##ojdbc8.jar## in ##WEB-INF/lib/##)
11 11  * Start Oracle and connect to it with a DBA or system user. For example use the Oracle SQL*Plus command-line tool: {{code}}connect system;{{/code}}
12 12  * Create the wiki user and schema:(((
13 13  {{code}}
... ... @@ -43,9 +43,9 @@
43 43  )))
44 44  * Give sufficient privileges to the ##xwiki## user:(((
45 45  {{code}}
46 -grant create session to xwiki;
47 -grant create table to xwiki;
48 -grant create sequence to xwiki;
46 +grant connect to xwiki;
47 +grant resource to xwiki;
48 +grant dba to xwiki;
49 49  {{/code}}
50 50  )))
51 51  * Tell XWiki to use Oracle. To do this, edit the ##WEB-INF/hibernate.cfg.xml## file where you have expanded the XWiki WAR file and uncommented the Oracle part. Make sure to review the ##connection.url## property. For example a typical Oracle Express would be:{{code}}<property name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>{{/code}}(((

Get Connected