38
edits
(Blanked the page) |
|||
Line 1: | Line 1: | ||
==Oracle database as back-end== | |||
*Install driver | |||
netxms-server-oracle_YOUR_NETXMS_VERSION.deb | |||
*Download drivers | |||
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 | |||
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 | |||
<pre> | |||
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 | |||
</pre> | |||
*Create database user | |||
<pre> | |||
-- 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; | |||
</pre> | |||
*create initial shema | |||
nxdbmgr init /usr/share/netxms/sql/dbinit_oracle.sql |
edits