Your browser does not allow this site to store cookies and other data. Some functionality on this site may not work without them. See Privacy Policy for details on how we would use cookies.

Tectia

Using an Oracle Database

As an alternative to the built-in SQL database, it is possible to use an Oracle database with Tectia Manager. 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 Tectia Manager using the initial configuration wizard. See Initial Configuration for Management Server.

===AUTO_SCHEMA_MARKUP===