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