Oracle

From NetXMS Wiki
Revision as of 20:09, 10 March 2014 by AndreyKP (talk | contribs) (Undo revision 1131 by AndreyKP (talk))
Jump to navigation Jump to search

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
Retrieved from "https://wiki.netxms.org/index.php?title=Oracle&oldid=1132"