We have often seen prospects and customers have some challenges when configuring the repository in Oracle.
This article aims to demystify the installation process:
For the?Repository?to communicate with the database, the machine running?Team Server?must also have the corresponding RDBMS client utility installed.
- 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 upgrade using Oracle, increase the number of processes (connections) to 200 before running.
- Minimum permissions for the 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
- EXECUTE ON DBMS_SQL
- EXECUTE ON DBMS_LOB
- EXECUTE ON DBMS_RANDOM
- The above permissions can be set using a script
- Installation Script For Oracle Permissions
- With the new user make sure you can connect via SQL*Plus and ensure that you can create some objects.
- Then remove the objects you just created and run the Configurator.
- When running the Configurator
- Very Important
- In the Configurator for the section on using ServiceName, please make sure it is the same name as the tnsnames. ora.
- For example: If your Tnsnames entry has ORCLPDB1, the exact needs to be entered in the SERVICENAME field in the configurator.
- Validating The User Permissions:
- You can validate user privileges using a script
- Validate User Privileges Script For Oracle
Once you have completed the above steps: You shouldn't run into any issues with the installation.
