Using an Oracle Database

As an alternative to the built-in SQL database, it is possible to use an Oracle database with SSH Tectia Manager. SSH Tectia Manager accesses the database through a built-in Oracle client.

Note that the Oracle database installation or administration are not covered in this document. For instructions, refer to Oracle documentation.

To use an Oracle database, do the following:

Install the Oracle database (or use an existing installation).

Create a user in the Oracle database after logging in as a database administrator.

Oracle 9.x:

CREATE USER manager-user IDENTIFIED BY password
  DEFAULT TABLESPACE users
  TEMPORARY TABLESPACE temp
  QUOTA UNLIMITED ON users
  QUOTA UNLIMITED ON temp; 
GRANT CONNECT TO manager-user;
COMMIT;

Oracle 10.x and 11.1:

CREATE USER manager-user IDENTIFIED BY password
  DEFAULT TABLESPACE users
  TEMPORARY TABLESPACE temp
  QUOTA UNLIMITED ON users;
GRANT CONNECT TO manager-user;
GRANT RESOURCE TO manager-user;
COMMIT;

Configure SSH Tectia Manager using the initial configuration wizard. See Initial Configuration for Management Server.