top of page
logo-cerebrosql

ORACLE_LIST table

The table stores information necessary to connect to Oracle databases.

CREATE TABLE ORACLE_LIST (
    [id]        INTEGER PRIMARY KEY AUTOINCREMENT,
    [alias]     TEXT,
    [groupname] TEXT DEFAULT 'DEFAULT',
    [db_alias]  TEXT,
    [username]  TEXT,
    [passwd]    TEXT,
    [tns_block] TEXT,
    [ocipath]   TEXT,
    [tns_admin] TEXT,
    [nls_lang]  TEXT,
    [comment]   TEXT,
    [osauth]    INTEGER DEFAULT 0,
    [mode]      TEXT,
    [odbcuse]   INTEGER,
    [odbcname]  TEXT,
    [current]   INTEGER DEFAULT 0,
    UNIQUE (alias, groupname)
)

Description of the table fields

current
flag indicating the default connection for connecting to the database by the main monitoring kernel at the start of the program
odbcname
ODBC connection name
odbcuse
flag indicating the type of driver used, 0 - Oracle, 1 - ODBC
mode
connection mode (Normal, sysdba, ...)
osauth
OS account authentication
comment
a comment
nls_lang
connection encoding
tns_admin
path to the directory where the tnsnames.ora file is located
ocipath
path to oci.dll file
tns_block
block for connecting to the database (informational)
passwd
user password (stored in ASCII code with delimiter |)
username
Username
db_alias
connection alias from tnsnames file or connection string in the format server: port/service_name
groupname
group name (used to group entries in the connection manager)
alias
connection alias
id
sequence number of the record
bottom of page