Changes for page Oracle Installation

Last modified by Vincent Massol on 2023/12/07

<
From version < 13.2 >
edited by Vincent Massol
on 2017/01/09
To version < 14.1 >
edited by Vincent Massol
on 2017/09/06
>
Change comment: Copied from platform:AdminGuide.InstallationOracle

Summary

Details

Page properties
Content
... ... @@ -9,15 +9,13 @@
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 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/##)
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 -* Create the wiki user and schema:
13 -(((
12 +* Create the wiki user and schema:(((
14 14  {{code}}
15 15  create user xwiki
16 16  identified by xwiki;
17 17  {{/code}}
18 18  )))
19 -* Create a tablespace (which is the Oracle term for what you know as a "database" on Microsoft SQL Server):
20 -(((
18 +* Create a tablespace (which is the Oracle term for what you know as a "database" on Microsoft SQL Server):(((
21 21  {{code}}
22 22  select *
23 23  from dba_data_files
... ... @@ -33,8 +33,7 @@
33 33  ;
34 34  {{/code}}
35 35  )))
36 -* Create tables of the ##xwiki## user by default in the new tablespace:
37 -(((
34 +* Create tables of the ##xwiki## user by default in the new tablespace:(((
38 38  {{code}}
39 39  alter user xwiki
40 40  default tablespace xwiki
... ... @@ -51,12 +51,12 @@
51 51  grant create sequence to xwiki;
52 52  {{/code}}
53 53  )))
54 -* 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}}
55 -(((
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}}(((
56 56  {{info}}
57 57  **XE** is the default name of the ORACLE SID created by default by the installation for Oracle Express. If it is another you should change it. You can find the correct SID in ##app/oracle/product/10.2.0/server/NETWORK/ADMIN/tnsnames.ora## in the Oracle installation directory (for Windows).
58 58  {{/info}}
59 59  )))
56 +
60 60  = Troubleshooting =
61 61  
62 62  == ORA-01400: cannot insert NULL into ("XWIKI"."XWIKILARGESTRINGS"."XWL_ID") ==
... ... @@ -93,6 +93,7 @@
93 93  = Installing Oracle from a VM =
94 94  
95 95  An easy to test Oracle is to use a VM. Here are some easy steps:
93 +
96 96  * [[Download the VM from the Oracle web site>>http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html]]
97 97  * Install [[VirtualBox>>https://www.virtualbox.org/]] and import the VM in it
98 98  * Note: I had to configure the VM network settings to use the "Bridged Adapter" instead of "NAT" in order to be able see it from my host machine
XWiki.XWikiComments[4]
Comment
... ... @@ -22,7 +22,7 @@
22 22  
23 23  is becoming for me:
24 24  
25 -jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=slds821-vip) (PORT=1523))(ADDRESS=(PROTOCOL=TCP)(HOST=slds822-vip) (PORT=1523))(CONNECT_DATA=(SERVICE_NAME=SADND1)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5~))))
25 +jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=slds821-vip) (PORT=1523))(ADDRESS=(PROTOCOL=TCP)(HOST=slds822-vip) (PORT=1523))(CONNECT_DATA=(SERVICE_NAME=SADND1)(FAILOVER_MODE=(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5~)~)~))
26 26  
27 27  Adapt for you, the:
28 28  
XWiki.XWikiComments[6]
Comment
... ... @@ -8,5 +8,3 @@
8 8  What do you think ?
9 9  
10 10  Thanks
11 -
12 -

Get Connected