Navigation: Pre-required activities > Database configuration > Oracle >

Oracle configuration

This section covers the procedure to create and configure the Schema in Oracle. See the steps below:

This procedure assumes Oracle is installed with an instance created and that the TNSNames is configured correctly on the server where SE Suite will be installed.

1.Start SQLPlus;

# sqlplus@<tnsnames>

2.Connect to the server using a DBA user.

Creating the tablespaces

3.Create a tablespace called SOFTEXPERT_DATA:

CREATE TABLESPACE SOFTEXPERT_DATA LOGGING DATAFILE '<tablespaces_directory>\SOFTEXPERT_DATA.DBF' SIZE 2000M AUTOEXTEND ON NEXT 200M MAXSIZE UNLIMITED;

Substitute <tablespaces_directory> for the path where the tablespace should be created on the Oracle server.

2000M is the initial recommended size for the data tablespace.

4.Create a tablespace called SOFTEXPERT_INDEXES:

CREATE TABLESPACE SOFTEXPERT_INDEXES LOGGING DATAFILE '<tablespaces_directory>\SOFTEXPERT_INDEXES.DBF' SIZE 200M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;

Substitute <tablespaces_directory> for the path where the tablespace should be created on the Oracle server.

200M is the initial recommended size for the indexes tablespace.

Creating a user for SE Suite

5.Create a user for SE Suite:

CREATE USER <user> PROFILE DEFAULT IDENTIFIED BY <password> DEFAULT TABLESPACE SOFTEXPERT_DATA ACCOUNT UNLOCK;

Substitute <user> and <password> with the user's name and password respectively.

6.Define the required Grants for the user created in step 5:

ALTER USER <user> QUOTA UNLIMITED ON SOFTEXPERT_DATA;

ALTER USER <user> QUOTA UNLIMITED ON SOFTEXPERT_INDEXES;

GRANT CREATE SESSION TO <user>;

GRANT CREATE TABLE TO <user>;

GRANT CREATE VIEW TO <user>;

GRANT CREATE SEQUENCE TO <user>;

GRANT CREATE PROCEDURE TO <user>;

GRANT CREATE TRIGGER TO <user>;

GRANT SELECT_CATALOG_ROLE TO <user>;

7.Exit the SQLPlus.

exit

If it is not necessary to configure another database, continue with the SE Suite installation from the Installation activity section.