Changes for page Oracle Installation

Last modified by Vincent Massol on 2023/12/07

<
From version < 9.1 >
edited by Vincent Massol
on 2013/04/11
To version < 10.1 >
edited by Vincent Massol
on 2013/04/12
>
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -85,3 +85,21 @@
85 85  <property name="hibernate.connection.SetBigStringTryClob">true</property>
86 86  <property name="hibernate.jdbc.batch_size">0</property>
87 87  {{/code}}
88 +
89 += Installing Oracle from a VM =
90 +
91 +An easy to test Oracle is to use a VM. Here are some easy steps:
92 +* [[Download the VM from the Oracle web site>>http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html]]
93 +* Install [[VirtualBox>>https://www.virtualbox.org/]] and import the VM in it
94 +* 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
95 +* Start the VM and log in as ##oracle##/##oracle##
96 +* Note that IP address printed in the shell that opens up, for example: 192.168.0.49
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##)
99 +* From your host machine, point your browser on http:~/~/192.168.0.49:1158/em and connect as ##system/oracle##
100 +* In your XWiki's ##hibernate.cfg.xml##, use:(((
101 +{{code}}
102 +<property name="connection.url">jdbc:oracle:thin:@192.168.0.49:1521:orcl</property>
103 +{{/code}}
104 +* Enjoy ;)
105 +)))

Get Connected