1. Create Tablespace. 

2. Create TrackStudio user 

3. Grant DBA and Resource role to created user. 

4. Configure the database connection properties:

• TrackStudio SA: Go to the Database Connectivity tab, enter the JDBC connection properties.
• TrackStudio WAR: Edit the trackstudio.hibernate.properties:

hibernate.dialect net.sf.hibernate.dialect.OracleDialect
hibernate.connection.url jdbc:oracle:thin:@localhost:1521:ORCL
hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
hibernate.connection.username trackstudio
hibernate.connection.password trackstudio

5. Initialize the database:

• TrackStudio SA: Go to the Database Management tab and click the Create Database button.
• TrackStudio WAR:

>sqlplus

SQL*Plus: Release 10.1.0.2.0 - Production

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Enter user-name: trackstudio
Enter password:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> set define off;
SQL> @@ trackstudio-oracle.sql

Oracle connection string includes database URL, JDBC driver, Login and Password. First part (before "@") of this URL is common, you have no need to modify it. After this character you need to enter your database location like HostAddress:Port:ORACLE_SID. If you are using locally installed version of Oracle, HostAddress is localhost. Default Oracle port is 1521, default ORACLE_SID is ORCL. In the JDBC driver field there is a default JDBC Driver for Oracle, that you don't usually need to modify.