Difference between revisions of "Oracle"

From NetXMS Wiki
Jump to navigation Jump to search
(Created page with "==Oracle database as back-end== *Install driver netxms-server-oracle_YOUR_NETXMS_VERSION_amd64.deb *Download drivers Download <code>instantclient-basic-linux</code> from [http...")
 
m (Text replacement - "^" to "{{deprecated}}")
 
(4 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_amd64.deb
*Download drivers
Download <code>instantclient-basic-linux</code> from [http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.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

Latest revision as of 16:13, 13 September 2022

This Wiki is deprecated and we are are currrently migrating remaining pages into product documentation (Admin Guide, NXSL Guide)

#REDIRECT From_src#Oracle_libs

Retrieved from "https://wiki.netxms.org/index.php?title=Oracle&oldid=1974"