Difference between revisions of "Oracle"
Jump to navigation
Jump to search
(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 | |||
Revision as of 20:09, 10 March 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