Difference between revisions of "Oracle"
Jump to navigation
Jump to search
(Created page with "==Oracle database as back-end== *Install driver netxms-server-oracle_YOUR_NETXMS_VERSION_amd64.deb *Download drivers Download <code>instantclient-basic-linux</code> from [http...") |
|||
Line 1: | Line 1: | ||
==Oracle database as back-end== | ==Oracle database as back-end== | ||
*Install driver | *Install driver | ||
netxms-server- | netxms-server-oracle_YOUR_NETXMS_VERSION.deb | ||
*Download drivers | *Download drivers | ||
Download <code>instantclient-basic-linux</code> from [http://www.oracle.com/technetwork/ | Download <code>instantclient-basic-linux</code> from [http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html | oracle] website. | ||
*unzip to the folder | *unzip to the folder | ||
sudo unzip instantclient-basic-linux.YOUR_ORACLE_VERSION.zip -d /opt/ | sudo unzip instantclient-basic-linux.YOUR_ORACLE_VERSION.zip -d /opt/ |
Revision as of 16:14, 22 February 2014
Oracle database as back-end
- Install driver
netxms-server-oracle_YOUR_NETXMS_VERSION.deb
- Download drivers
Download instantclient-basic-linux
from | oracle website.
- unzip to the folder
sudo unzip instantclient-basic-linux.YOUR_ORACLE_VERSION.zip -d /opt/
- Link libraries
sudo echo '/opt/instantclient_YOUR_ORACLE_VERSION/' > /etc/ld.so.conf.d/oracle.conf
- Update system libraries
sudo ldconfig
- Edit /etc/netxmsd.conf
DBDriver = /usr/lib/netxms/dbdrv/oracle.ddr DBServer = ServerIP/ServerName.DomaiNname #Here is service (full database name), not SID DBName = netxms DBLogin = netxms DBPassword = PaSwD
- Create database user
-- USER SQL CREATE USER netxms IDENTIFIED BY PaSwD DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP; -- QUOTAS ALTER USER netxms QUOTA UNLIMITED ON USERS; -- ROLES GRANT RESOURCE TO netxms; GRANT CONNECT TO netxms;
- create initial shema
nxdbmgr init /usr/share/netxms/sql/dbinit_oracle.sql