README.md

oranif

Oracle Call Interface driver using dirty NIFs. Requires Erlang/OTP 20 or later with full dirty nif support.

Development

Currently builds in Window, Linux and OS X

Compile (all OSs)

# embed odpic source (default)
rebar3 compile
# link with compiled odpic library
# (c_src/odpi/lib/ needed at runtime for NIF load)
LINKODPI=true rebar3 compile
ORANIF_DEBUG=_verbosity_ rebar3 compile # debug log verbosity >= 1
# see dpi_nif.h for ORANIF_DEBUG values and debug log granularities

OSX/Linux

• Requires Oracle Client library installed, see https://oracle.github.io/odpi/doc/installation.html for installation instructions.
• For OSX use basic as basic-lite didn't work in our tests.
• Requires a C compiler supporting the c11 standard.
• code coverage

gcov -o ./ c_src/*.c

Ubuntu (Windows Subsystem for Linux)

$ uname -a
Linux WKS006 4.4.0-17763-Microsoft #379-Microsoft Wed Mar 06 19:16:00 PST 2019 x86_64 x86_64 x86_64 GNU/Linux
$ sudo apt-get install libaio1
$ export OTP_ERTS_DIR=/usr/lib/erlang/erts-10.4.4/
$ export LD_LIBRARY_PATH=$ROOT/oranif/c_src/odpi/lib/
$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/19.3/client64/lib/ # or `sudo ldconfig`

code coverage setup (first time)

$ wget http://ftp.de.debian.org/debian/pool/main/l/lcov/lcov_1.11.orig.tar.gz
$ tar xf lcov_1.11.orig.tar.gz
$ sudo make -C lcov-1.11/ install

code coverage report

lcov --directory . --capture --output-file coverage.info
lcov --list coverage.info

Create Environment variables

OTP_ERTS_DIR       = path to erlang run time system
ERL_INTERFACE_DIR  = path to erl_interface or erlang installation

Example .bashrc snippet:

...
export OTP_ERTS_DIR=$(find /usr/lib/erlang/ -maxdepth 1 -type d -name erts-*)
export ERL_INTERFACE_DIR=$(find /usr/lib/erlang/lib/ -maxdepth 1 -type d -name erl_interface-*)
...

Testing

There are some eunit tests which can be executed through rebar3 do clean, compile, eunit (Oracle Server connect info MUST be supplied through tests/connect.config first).

DB Init SQL (XE)

C:\> sqlplus system

EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
create user scott identified by tiger;
alter session set "_ORACLE_SCRIPT"=true; -- if 'create user scott...' results into ORA-65096

grant alter system to scott;
grant create session to scott;
grant unlimited tablespace to scott;
grant create table to scott;
grant create cluster to scott;
grant create view to scott;
grant create sequence to scott;
grant create procedure to scott;
grant create trigger to scott;
grant create any directory to scott;
grant drop any directory to scott;
grant create type to scott;
grant create operator to scott;
grant create indextype to scott;

exit

C:\> sqlplus scott/tiger@192.168.1.49:1521/xe

select * from session_privs;

Increase amount of processes, sessions and transactions

Extensive database usage may exhaust the connection limits that have defaults around 100. If that happens, any attempts to establish further connections may fail, resulting in an error such as "ORA-12516: TNS:listener could not find available handler with matching protocol stack". To prevent this, the limit should be raised so the database can establish more simultaneous connections.

To do this, log into the database as SYSDBA. Normal users aren't privileged enough.

sqlplus sys as sysdba

Then, set the new limits:

alter system set processes=1000 scope=spfile
alter system set sessions=1000 scope=spfile
alter system set transactions=1000 scope=spfile

In this example, the limits are set to 1000. The actual values might be even higher because there are constraints regarding the size of those numbers. For instance, "sessions" might be set to 1524 instead.

Then, the database must be restarted for this change to take effect:

Windows Menu --> Oracle Database 11g Express Edition --> Stop database

This takes a while, as indicated by the console window that opens. When it is done, start the database:

Windows Menu --> Oracle Database 11g Express Edition --> Start database

Verify that the change took effect using sqlplus:

show parameter sessions 

A result similar to this should be printed:

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size           integer     0
java_soft_sessionspace_limit         integer     0
license_max_sessions                 integer     0
license_sessions_warning             integer     0
sessions                             integer     1524
shared_server_sessions               integer