Home > IDERA Team Server Repository Databases – Oracle Edition

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)

Download

Description

(64-bit) (924,022,453 bytes) (sha256sum – a7d5ba7d3dac84fcebc5ddb50aeed3125b52d94f26bab9924bdab6f6d00d2c7e )
(64-bit) (1,043,502,535 bytes) (sha256sum – 3fa278fe33e0cd3bbed6c84f34b5698962c1feeb74cced1c9713435ebdb2a24f )

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

Aligning complex data environments with business goals for over 30 years.
Copyright © 2024 Idera, Inc.