Your browser does not allow storing cookies. We recommend enabling them.

SSH Tectia

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:

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

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

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


 

 
PrivX
 

 

 
What to read next:

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



    The NISTIR 7966 guideline from the Computer Security Division of NIST is a direct call to action for organizations regardless of industry and is a mandate for the US Federal government.
    Download now
  • ISACA Practitioner Guide for SSH



    With contributions from practitioners, specialists and SSH.COM experts, the ISACA “SSH: Practitioner Considerations” guide is vital best practice from the compliance and audit community.
    Download now