IDERA Team Server Repository Databases – Oracle Edition

Hi All,

Another exciting year to commence here at IDERA!

Today we will be covering the various options, our prospects and customers have to setup their Team Server Repository. This applies to both Professional and Enterprise Team Edition Offerings.

Today will be Oracle

1) Oracle 12c – 19c. 

Pre-requisites:

Oracle Full Administrative Client – You may contact your Oracle DBA or navigate to the Oracle's website below and download the Oracle 19c / 21c Client that will connect 

to Oracle 19c / 21c Database

Oracle Database 19c Client (19.3) for Microsoft Windows x64 (64-bit)

Contains the Oracle Client Libraries for Windows. Download if you want the client libraries only

The client needs to be installed on both the Client workstation of IDERA ER/Studio Data Architect and on the Team Server / Repository Machine.

Make sure you have installed and can connect to your Oracle DB Instance via SQL*Plus, once that is done, we know that we have established the connection, we can then create our

oracle user.

Oracle Characteristics

• Install the 64-bit version of Oracle Client Utilities.
• Configure your server in one of the Oracle configuration tools:
  • Net Easy Config
  • Net Configuration Assistant
• Create a connection alias.
• If you are upgrading using Oracle, increase the number of processes (connections) to 200 before running.
• Minimum permissions for owner of Repository and Team Server schema:
  • Roles:

    SELECT_CATALOG_ROLE

  • Privileges:

    CREATE INDEXTYPE

    CREATE PROCEDURE

    CREATE SEQUENCE

    CREATE SESSION

    CREATE SYNONYM

    CREATE TABLE

    CREATE TRIGGER

    CREATE TYPE

    CREATE VIEW

    UNLIMITED TABLESPACE

This concludes our Oracle Setup, we will cover SQL Server in the Next blog post