Change comment:
Copied from platform:AdminGuide.InstallationOracle
Summary
-
Page properties (1 modified, 0 added, 0 removed)
-
Objects (2 modified, 0 added, 0 removed)
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 -