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.
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.