Difference between revisions of "Setup Oracle credentials with Onepoint"
(Created page with "= Install Dependencies = On Onepoint servers, you need install some dependencies ]# yum install python-devel libaio = Install Oracle Instant Client = From Oracle website (...") |
|||
| Line 1: | Line 1: | ||
| + | = Assumption = | ||
| + | This article's assumption is that you correctly installed Onepoint through [[Installing Onepoint on CentOS 7 with Hashicorp Vault|this link]] or [[Installing Onepoint on CentOS 7|this link]]. | ||
| + | |||
= Install Dependencies = | = Install Dependencies = | ||
On Onepoint servers, you need install some dependencies | On Onepoint servers, you need install some dependencies | ||
| Line 19: | Line 22: | ||
]# pip install cx_Oracle | ]# 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 | ||
| + | [[File:Newassetoracledb.jpg|frameless|600px|New Oracle DB asset]] | ||
Revision as of 13:11, 14 April 2020
Contents
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
