top of page
Shareware software
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