|
|
(3 intermediate revisions by one other user not shown) |
Line 1: |
Line 1: |
| ==Oracle database as back-end==
| | {{deprecated}}#REDIRECT [[From_src#Oracle_libs]] |
| *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
| |