Free oracle data provider software for linux

Firebird .NET Data Provider is an ADO.NET data provider for Firebird. Firebird .NET Data Provider is written in C# and provides a high-performance native implementation of the Firebird API. It also includes an implementation of the Firebird Services API and Firebird array datatype support.

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981.

Firebird is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000 under the InterBase Public License v.1.0

Oracle::CAPI is a Perl XS wrapper extension for the Oracle Collaboration Suite CAPI SDK.

SYNOPSIS

use Oracle::CAPI;
use Text::vCard;

Oracle::CAPI::SetConfigFile($CAPI_INI_FNAME,$CAPI_LOG_FNAME) && die("Cant init/log CAPI");
$capi_session = Oracle::CAPI::CreateSession() || die("Cant create CAPI session");

# Authenticate to OCS
$rv = Oracle::CAPI::ReconnectAuthUser($capi_session,$HOSTNAME,$nodeid,$pass,$uname);

$rv = Oracle::CAPI::FetchContactsFile($capi_session,$VCARD_NAME_TYPE,$VCARD_STARTSWITH_OP,$chr,$filename);
$rv = Oracle::CAPI::CreateContact($capi_session,$vcard);
$rv = Oracle::CAPI::DeleteContact($capi_session,$uid);

$rv = Oracle::CAPI::DestroyPerlSession($capi_session);

A perl XS wrapper to ctapi.h from the Oracle Collaboration Suite CAPI SDK. This was built and tested against OCS version 9.0.4.2 on Linux.

Oracle client is a simplistic Perl-based Oracle client that tries to mimic some of the functionality of PostgreSQL and MySQLs text-based SQL clients.

It is relatively simplistic, but much more useful than dbishell or sqlplus.

The project supports readline, history, desc, and various shorthand commands like d, , c, etc.

Direct Access Provider Library in short DAPL is a transport-independent, platform-independent, high-performance API for using the remote direct memory access (RDMA) capabilities of modern interconnect technologies such as InfiniBand, the Virtual Interface Architecture, and iWARP.
This is the reference implementation of that specification by the DAT Collaborative who maintain the DAPL API.
Enhancements:
- Support was added for new IB verbs client register event.
- Some problems supporting create qp without recv cq handle or recv qp resources were fixed.
- Some timeout and long disconnect delay issues exposed during scalability tests were fixed.
- Minor build problems were fixed.
- Support for multiple IB devices was added to dat.conf to support IPoIB HA failover.
- Support for returning local and remote port information was added.
- The RPM spec file was cleaned up.
- Enviroment variables to configure connection management timers were added.

Agata Report is a cross-platform database reporting tool with graph generation and a query tool that allows you to get data from PostgreSQL, MySQL, SQLite, Oracle, DB2, MS-SQL, Informix, InterBase, Sybase, or Frontbase and export that data as PostScript, plain text, HTML, XML, PDF, or spreadsheet (CSV) formats through its graphical interface.

You can also define subtotals, levels and a grand total for the report, merge the data into a document, generate address labels, or even generate a complete ER-diagram from your database.

Oracle::Sqlldr is a Perl wrapper around Oracles sqlldr utility.
SYNOPSIS
use Oracle::Sqlldr;
my $sqlldr = Oracle::Sqlldr->new(); # get new sqlldr object
Oracle::Sqlldr is an object-oriented class that provides a convenient Perl wrapper around Oracles sqlldr utility.
SQL*Loader (sqlldr) is the utility to use for high performance data loading from a text file into a an Oracle database.
Version restrictions:
- No WIN32 support
- No fixed format record support
- Assumes table owner and user to load data as are the same
- No support for parameter file

Oracle Aggregate C++ Library allows C++ programmers to easily create new aggregate functions for Oracle.

Oracle Aggregate C++ Library can be used as a glue library to existing C++ and C libraries. Detailed knowledge of the OCI aggregate interface is not required to use the library.

With automatic conversion of Oracle built-in types to C++ types it is possible to use the library without using any OCI functions directly.

The Oracle OCI interface for aggregate functions provides a straightforward way to implement aggregate functions in C or C++. There is, however, a certain amount of bookkeeping that needs to be performed in order to use the interface. The goal of this library is to take care of all the bookkeeping details for your, all you need to provide is the aggregate function itself. This makes it particularly easy to use existing C++ code and libraries in Oracle aggregate functions.

Design

The way the library works is that it defines the shared library entry point functions required by Oracle. The entry point functions simply forward all arguments to the static functions of the Aggregate class.

The Aggregate class along with a number of helper classes and functions takes care of converting arguments, configuring the environment, creating implementation instances and such. When everything is ready the arguments originally sent by Oracle are passed to your aggregate implementation.

GTK Oracle is a GTK+ 2 interface to Oracle that aids in Oracle application development and testing.
Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting.
For SQL statement analysis and tuning there is a tree-style SQL statement "explain plan" facility and the ability to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, and the Oracle Automatic Workload Repository in Oracle version 10g. Full statistics are available on loaded statements.
Main features:
- manually running your applications SQL, outside of the application itself
- trying to find out what queries your application is even running
- checking and gathering statistics
- comparing plans
- running statspack to evaluate results
- autotracing
- peeking in AWR
- peeking the shared pool / v$sqlarea / statspack SQL
- identifying high-resource SQL then this might be of some help.
Usage:
- SQL in the text buffer (anything that gets run via the Execute button) is run on its own thread in the background so it will not block the GUI part, and you can cancel it. This execution thread is started when you start up the program, hopefully never exits, and receives commands via a GLib asynchronous queue, so you can safely keep hitting Execute while a command is running, it will just execute them in order.
- If you log in as SYSDBA you will get a combo box just under the main menubar. Changing the value will execute ALTER SESSION SET CURRENT_SCHEMA=somebody; so when you browse it will be as if you were this user. Be aware that any SQL you execute will result in SYS being recorded as the parsing user in the cursor cache, however.
- If you want to access the cursor cache or statspack or AWR you will need to log in with SYSDBA privileges. You might be able to get away with simply having SELECT on SYS.V$SQLAREA and SYS.V$SQLTEXT.
- SYS is excluded from the cursor cache browsing results. Otherwise you end up with a mass of recursive SQL, which you are not going to be able to tune and that is the point here. If youre a masochist and you do want to browse recursives I suppose you can just modify the relevant SQL so that SYS is not exculded and recompile. Have fun.
- AWR features are only available on 10G servers.
- DBMS_OUTPUT works, go to Edit->DBMS OUTPUT Enable