1. Create Tablespace. 

2. Create TrackStudio user 

3. Grant DBA and Resource role to created user. 

4. Start SQLPlus Worksheet and login as TrackStudio user 

5. Execute sql\trackstudio-oracle.sql (TrackStudio/WAR) or use the Create Database button (TrackStudio/SA)

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.

Sample JDBC configuration.

ConnectionURL: jdbc:oracle:thin:@localhost:1521:ORCL
DriverClass: oracle.jdbc.driver.OracleDriver
UserName:TS
Password:TS