Difference between revisions of "Oracle"

Revision as of 21:27, 10 March 2014

Redirect to:

@@ Line 1: / Line 1: @@
-==Oracle database as back-end==
+#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