Technical Support

Caution: BioStar2 discontinued to support Oracle DB. This document is for BioStar2 v2.4.1 user.

BioStar2 v2.4.1 supports Oracle DB for small size project only.

Please be aware that BioStar2 performance of Oracle DB will be slower than Maria DB or MS SQL.

	Small
Total Users	500
Total Devices	50

Direction

1. Install Oracle Server 11g or 12 c (x86)

Supported Oracle version:

Oracle Database 11g , Oracle Database 11g Express, Oracle Database 12c

2. Run SQL Plus to create oracle User and table space

2-1. Log on SQL plus

3. Create BioStar2 AC and BioStar2 TA as follows

- Create BioStar2 folder after referring Oracle installation path and 3-1 DATAFile if you would like to keep the 3-1&3-2 query below.

- Set a password for BioStar2_AC_User and BioStar2_TA_User

3-1. Copy the following query and run to SQL plus

CREATE TABLESPACE BIOSTAR2_AC
DATAFILE 'C:\oraclexe\app\oracle\oradata\BioStar2\Datafile\BIOSTATR2_AC_00.DBF'

SIZE 500M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON
/
CREATE USER BIOSTAR2_AC_USER IDENTIFIED BY "BIOSTAR2_AC_PW"
/
ALTER USER BIOSTAR2_AC_USER DEFAULT TABLESPACE BIOSTAR2_AC_USER
/
ALTER USER BIOSTAR2_AC_USER TEMPORARY TABLESPACE TEMP
/
ALTER USER biostar2_ac_user QUOTA UNLIMITED ON BIOSTAR2
/
GRANT RESOURCE, CONNECT, DBA TO BIOSTAR2_AC_USER
/
GRANT CREATE DATABASE LINK,
CREATE PUBLIC SYNONYM,
CREATE SYNONYM,
CREATE TYPE,
CREATE MATERIALIZED VIEW,
CREATE ROLE,
CREATE TABLE, CREATE ANY TABLE, ALTER ANY TABLE, DROP ANY TABLE,
CREATE ANY INDEX, ALTER ANY INDEX, DROP ANY INDEX,
CREATE SESSION, ALTER SESSION, RESTRICTED SESSION,
CREATE TABLESPACE, UNLIMITED TABLESPACE,
CREATE VIEW,
CREATE PROCEDURE,
CREATE SEQUENCE,
CREATE TRIGGER TO BIOSTAR2_AC_USER
/

(Result)

3-2. Copy the following query and run to SQL plus

CREATE TABLESPACE BIOSTAR2_TA
DATAFILE 'C:\oraclexe\app\oracle\oradata\BioStar2\Datafile\BIOSTATR2_TA_00.DBF'

SIZE 500M
AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON
/
CREATE USER BIOSTAR2_TA_USER IDENTIFIED BY "BIOSTAR2_TA_PW"
/
ALTER USER BIOSTAR2_TA_USER DEFAULT TABLESPACE BIOSTAR2_TA_USER
/
ALTER USER BIOSTAR2_TA_USER TEMPORARY TABLESPACE TEMP
/
ALTER USER biostar2_TA_user QUOTA UNLIMITED ON BIOSTAR2
/
GRANT RESOURCE, CONNECT, DBA TO BIOSTAR2_TA_USER
/
GRANT CREATE DATABASE LINK,
CREATE PUBLIC SYNONYM,
CREATE SYNONYM,
CREATE TYPE,
CREATE MATERIALIZED VIEW,
CREATE ROLE,
CREATE TABLE, CREATE ANY TABLE, ALTER ANY TABLE, DROP ANY TABLE,
CREATE ANY INDEX, ALTER ANY INDEX, DROP ANY INDEX,
CREATE SESSION, ALTER SESSION, RESTRICTED SESSION,
CREATE TABLESPACE, UNLIMITED TABLESPACE,
CREATE VIEW,
CREATE PROCEDURE,
CREATE SEQUENCE,
CREATE TRIGGER TO BIOSTAR2_TA_USER
/