Oracle

Within this section are the necessary steps for the installation of the LumisXP database on the Oracle Server:

1. Open the database server manager, create a new schema, and execute the script db_oracle.sql.
2. In the file lumisdata/config/lumishibernate.cfg.xml, change the connection information with the database.

   <!-- Oracle --> <property name="dialect">lumis.portal.dao.hibernate.Oracle10gDialect</property> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="connection.username">DB_USERNAME</property> <property name="connection.password">DB_PASSWORD</property> <property name="connection.url">jdbc:oracle:thin:@HOST_NAME:1521:SID_NAME</property>

   Another alternative for connecting with the database is the configuration of the datasource on the application server;

3. Execute the file /setup/initializeportal.cmd, for Windows®, or initializeportal.sh, for Linux. This script runs a Java application that opens a connection with the database, utilizing the information from the file lumisdata/config/lumishibernate.cfg.xml. This script also inserts the initial data necessary for the operation of LumisXP.