My Oracle Support Banner

HOWTO : Understand ProC and OCI Connection Protocol And Syntax For TimesTen (Doc ID 790284.1)

Last updated on APRIL 13, 2020

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1 and later
Information in this document applies to any platform.
All compiled Pro*C and OCI programs connecting to TimesTen.
***Checked for relevance on 24-Jan-2011***
***Checked for relevance on 24-Dec-2012***


Goal

This docNote discusses how OCI and ProC programs connect to TimesTen datastores.

Critical to understanding the implementation of OCI and Pro*C in a TimesTen environment is the fact that these programs use a completely different connection protocol then that used by OCI and Pro*C when connecting to Oracle. When connecting to Oracle databases, either locally or on a remote machine, OCI and Pro*C use the sqlnet two-task protocol: this protocol results in the creation of  a 2nd executable "shadow process" which attaches to the oracle SGA and communication from the client to Oracle is conducted via the shadow process.

ProC and OCI programs connecting to TimesTen do not use the sqlnet two-task protocol. Rather these executables use the TimesTen ODBC direct and client drivers to enable direct connections to datastores on the local machine or client connections to datastores on remote machines. TimesTen connections do not use shadow processes; rather the executable connects directly to the TimesTen shared memory segment. This document examines the syntax to use when specifying TimesTen connections for Pro*C and OCI executables. All of the examples use ProC code; equivalent connection syntax is available in OCI for all of these examples. 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.