Setup Oracle credentials with Onepoint

From Onepoint Systems Integration
Revision as of 13:20, 14 April 2020 by Pedro Ferreira (talk | contribs)
Jump to: navigation, search

Assumption

This article's assumption is that you correctly installed Onepoint through this link or this link.

Install Dependencies

On Onepoint servers, you need install some dependencies

 ]# yum install python-devel libaio

Install Oracle Instant Client

From Oracle website (link below), download Oracle Instant Client RPM package. If you want, you can also install Oracle SQL*Plus optional package, for testing purposes.

https://www.oracle.com/br/database/technologies/instant-client/linux-x86-64-downloads.html

 ]# yum localinstall oracle-instantclient<VERSION>-basic-<VERSION>.x86_64.rpm

Optional:

 ]# yum localinstall oracle-instantclient<VERSION>-sqlplus-<VERSION>.x86_64.rpm

Install cx_Oracle

You need to install cx_Oracle library through Python pip utility. Earlier in onepoint installation, you installed pip utility.

 ]# pip install cx_Oracle

Create Oracle Instance Asset

You need to create an OracleDB asset, whose name is <ADDRESS>::<SID>. Please, fill also the IPv4 field with server's IP address New Oracle DB asset

Create Delegate Credential for this instance

You need to use a delegate credential for this instance. Let's create the account svc_admin in Oracle for managing credentials

Creating admin user in Oracle

Connect as SYSDBA for creating the user

 ]$ sqlplus SYS AS SYSDBA
 
 Enter password:
 
 SQL>


 SQL> ALTER SESSION SET "_ORACLE_SCRIPT" = true;
 Session updated
 
 SQL> CREATE USER svc_admin identified by <PASSWORD>;
 User created
 SQL> GRANT CREATE SESSION TO svc_admin;
 Grant succeeded
 
 SQL> GRANT ALTER USER TO svc_admin;
 Grant succeeded

Creating Deletage credential in Onepoint

aa