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.
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)
|(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
- 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:
- 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