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.

Using an Oracle Database

Reduce Secure Shell risk. Get to know the NIST 7966.

ISACA Practitioner Guide for SSH