Oracle
Revision as of 16:14, 22 February 2014 by AndreyKP (talk | contribs) (→Oracle database as back-end)
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