Changes for page Oracle Installation

Last modified by Vincent Massol on 2023/12/07

<
From version < 11.1 >
edited by Vincent Massol
on 2015/04/02
To version < 12.1 >
edited by Vincent Massol
on 2015/08/25
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -95,7 +95,19 @@
95 95  * Start the VM and log in as ##oracle##/##oracle##
96 96  * Note that IP address printed in the shell that opens up, for example: 192.168.0.49
97 97  * In the shell, starts the manager: ##emctl start dbconsole##
98 -* Execute all the instructions above in the shell to create the ##xwiki## database (don't forget to download the JDBC driver and put it in ##WEB-INF/lib##)
98 +* Execute all the instructions above in the shell to create the ##xwiki## database (don't forget to download the JDBC driver and put it in ##WEB-INF/lib##). Tip: Put the following in a file (for example ##xwiki.sql## located on the Desktop) and execute {{code}}echo @Desktop/xwiki.sql | sqlplus system/oracle@orcl{{/code}}:(((
99 +{{code}}
100 +create user xwiki identified by xwiki;
101 +select * from dba_data_files;
102 +create tablespace xwiki datafile '/home/oracle/app/oracle/oradata/orcl/xwiki01.dbf' size 1m autoextend on maxsize 1g;
103 +alter user xwiki default tablespace xwiki temporary tablespace temp;
104 +alter user xwiki quota unlimited on xwiki;
105 +grant create session to xwiki;
106 +grant create table to xwiki;
107 +grant create sequence to xwiki;
108 +grant all privileges to xwiki;
109 +{{/code}}
110 +)))
99 99  * From your host machine, point your browser on http:~/~/192.168.0.49:1158/em and connect as ##system/oracle##
100 100  * In your XWiki's ##hibernate.cfg.xml##, use:(((
101 101  {{code}}

Get Connected