Skip Headers
Oracle® Database Lite Administration and Deployment Guide
10g (10.3.0)

Part Number B28922-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  Z 

A

access
defining access, 4.1.1.3
grant, 3.6, 4.2.1
revoke, 3.6, 4.2.1
Adding New Groups, 4.1.6
administrator
definition, 4.1.1, 4.1.1.1
functions, 4.1.1.1
password, 11.2
privilege, 4.1.1.1
alerts
synchronization, 5.3.2
All Databases section
parameters, F.2
SQL compatibility, F.2.17
application
accessing through Workspace, 2.3.1.1.1
adding WAR file, 3.8
deleting, 3.3
executing from Workspace, 2.3.1.2
grant access, 3.6, 4.2.1
performance, 3.4
properties
modify, 3.4
revoke access, 3.6, 4.2.1
setting parameter values, 3.5, 4.3
synchronization, 2.2, 2.3.1.1.2
synchronization configuration, 2.3.1.1.2
applications
access, 4, 4.1.1.3
scheduling to execute, 6
security, 4.1.1.3
user, 4.1.1.2
apply
behavior, 5.1.1, 5.1.1, A.7.1, A.7.1
authentication
certificate rejection, 11.5.1.4.4, F.5.1
authorization, 4.1.1.3
AUTO_COMMIT_COUNT parameter, F.3.2.4
automatic synchronization, 5.4
enable, F.3.2.13
platform rules, 5.4.1
conditions, 5.4.1
network setttings, 5.4.1
system events, 5.4.1

B

BC4J
remote access, 2.3.1.1.2
BLOB
file size limitations, 2.3.7
storing, 2.3.7
bookmarks
add, 14.1
BOS.INF file, 8.2.3, 11.6
Branch Office
administration, 8.4
architecture, 8.3, 8.3.1
changing port number, 8.2.6
concepts, 8.2.1
configuration, 8.2
connecting clients, 8.3.2
downloading files, 3.7
enabling on Windows Service Pack 2, 8.2.5
installation, 8.2
locale, 8.2.8
OracleDatabaseLiteUser
password, 8.2.3, 11.6
overview, 8.1
remote access, 2.3.1.1.2
services installed, 8.2.3, 11.6
terms, 8.2.1
user account, 8.2.3, 11.6

C

CAB file
SDK version, 7.5.4.3
CAB files
registering, 7.5.4.3
cache
size, F.2.1
CACHE_SIZE parameter, F.2.1
cached user, 5.6
catalog views
Mobile client, D.2
system, D.1
certificate
rejection, 11.5.1.4.4, F.5.1
self-signed, 11.5.1.4.4, F.5.1
SSL, 11.3.3
using temporary, F.3.2.14
certificate authority
examples, 11.3.1
character
encoding, F.3.2.9
character set
specifying, F.2.4
checkstatus command, 9.6.4
checksum error
diagnosing, F.2.16
cleanup command, 9.6.3
client
catalog views, D.2
character encoding, F.3.2.9
device management, 2.3.5, 7.9
dmagent, 7.9
managing Web, 2.3.1
ODB filename, 2.2
proxy, 11.5.2
scheduling synchronization, 2.3.1.4
software update request, 2.3.6
static or DHCP setting, A.2
synchronization, 2.2, 2.3.1.1.5
synchronization GUI, 2.3.2
synchronization job, 2.3.1.1.2
timeout, A.7.1, F.3.2.6
updates
automatic, 7.2.1, F.4.1
using reverse proxy, 11.5.1
client initiated, 2.3.1.1.5
clients
downloading files, 3.7
collation sequence
data, F.2.12
columns
defining number of, F.2.7
commit
automatic commit count, F.3.2.4
compose
behavior, 5.1.1, 5.1.1, A.7.1, A.7.1
conditions
automatic synchronization
platform rules, 5.4.1
configuration
Mobile Server, A.2
webtogo.ora, A.2
connection
pooling, 3.4
connection_timeout parameter, 3.4
ConsolidatorManager
Job creation API, 6.4
ConsolidatorManager class, 6.4, 6.5
Consperf utility, 5.10.3

D

data
sizing, A.7.1, F.3.2.7
data subsetting, 3.5, 4.3
Data Synchronization
DML locks, C.2
init.ora parameters, C.1
Data Synchronization, see synchronization
DATA_DIRECTORY parameter, F.2.2
database
defragment, 2.3.7
encryption, 5.7, F.3.2.12
flushing file buffers, F.2.6
limit connections, 3.4
temporary directory location, F.2.19
users, 4.1.1
validate, F.3.2.11
volume id, F.2.3
DATABASE_ID parameter, F.2.3
date
format definition, F.2.10
DB_CHAR_ENCODING parameter, F.2.4
DB_ENCODING parameter, F.3.2.9
DEBUG parameter, F.3.2.3
defragdb utility, 2.3.7
defragment
Oracle Lite databases, 2.3.7
device
client management, 2.3.5
listening port, F.4.2
management
client, 7.9
registration, 4.1.3.3
software update, 7.8.1
software updates, 7.8
update software, 4.1.3.3
webtogo.inf file, 7.2.2
Device Management
proxy, F.5.2
device management
configuration, 7.2.1
device manager
client, 2.3.5
device policy
users
defining, 4.1.3.3
DHCP
configuring client, A.2
directory
temporary directory, F.2.19
DISABLE_PROMPT parameter, 7.2.1, F.4.1
DISABLE_REMOTE_ACCESS parameter, 2.3.1.1.2
DISABLE_SSL_CHECK parameter, 11.5.1.4.4, F.5.1
DISABLED_DML, 5.6
dmagent, 7.9
dmc.inf file, 7.2.1
DML
tracing, F.3.2.2
DML locks, C.2
DO_APPLY_BFR_COMPOSE parameter, 5.1.1, A.7.1
download
JAR or ZIP files, 7.11.5

E

ENCRYPT_DB parameter, 5.7.1, F.3.2.12
encryption
database, 5.7
password, 11.2
plug-in custom module, F.2.5
snapshots, 5.7
error
reporting, F.3.2.8
Error queue
fixing synchronization errors, 5.9.4.3
synchronization, 5.1
ERROR_REPORT parameter, F.3.2.8
EXTERNAL_ENCRYPTION_DLL parameter, F.2.5

F

farm
Mobile Server, 4.1.2
Mobile Servers, 1.2
synchronization configuration, 5.5
firewall
communication through proxy, 11.5
FLUSH_AFTER_WRITE parameter, F.2.6

G

group
add new, 4.1.6
add users, 4.2.2
delete, 4.1.5
grant application access, 4.2.3
remove users, 4.2.2
revoke access, 3.6, 4.2.1
revoke application access, 4.2.3
groups
access applications, 4
managing, 4
search, 4.1.2.2

H

heap memory size, 5.3.4
history
purging, 6.3.5.2
HTTP_PROXY parameter, F.5.2

I

index
defining number of columns, F.2.7
In-Queue
synchronization, 5.1
viewing transactions, 5.9.4.1
install
distributing multiple clients, 9.1
distribution for multiple users, 9.7
Installation CD, 9.7
instance parameters
configuration, 5.5
internet
communication from inside intranet, 11.5.2
Internet Connection Firewall
enabling ports, 8.2.5
IP address, 5.3.4
configuring client, A.2
IP_CONFIG parameter, A.2

J

JAR
download, 7.11.5
inflate, 7.11.5
Java
character encoding, F.3.2.9
Java classpath, 5.3.4
Java support
Mobile client, 7.5.4.3
job
client, 2.3.1.1.2
creating, 6.3.1
define execution schedule, 6.3.1
definition, 6.1
displaying history, 6.2.4
scheduling, 6
Job engine
alerts, 6.2.2
start from API, 6.4.1
job history
purging, 6.3.5.2
Job Scheduler, 6
alerts, 6.2.2
engine management, 6.2
history, 6.2.4
managing active jobs, 6.2.3
separate thread from Mobile Server, 6.4.1
start, 6.2.1
JobEngine class, 6.4.1
jobs
create using API, 6.4
create using APIs, 6.5
delete, 6.3.4
disabling, 6.3.3
enabling, 6.3.3
manage using APIs, 6.4
managing, 6.2.3, 6.3
modifying, 6.3.2
JVM
version on Mobile Server host, 5.3.4

K

keystore
creating, 11.3.1
example, 11.3.1
keytool utility, 11.3.1
tester, 11.3.1
keytool utility, 11.3.1

L

linguistic sort, F.2.12
locale
Branch Office client, 8.2.8
locale data
specification, F.2.11

M

makeodb command, 9.6.1
max_connections parameter, 3.4
MAX_INDEX_COLUMNS parameter, F.2.7
MEM_THRESHOLD parameter, F.3.2.10
memory
threshold value, F.3.2.10
MESSAGE_FILE parameter, F.2.9
MGP
alerts, 5.3.2
composing transaction, 5.1
create new MGP, 6.3.1
default process, 6.3.5.1
define execution schedule, 6.3.1
enabling
MGP, 6.3.3
execution process, 5.1
managing, 6.3
modifying schedule, 6.3.2
purge history, 6.3.5.2
scheduled job, 6.1
statistics, 5.10.2
Mobile client
configuring reverse proxy, 11.5.1.3
custom platform, 7.5.4.3
distributing multiple clients, 9.1
installation CD, 9.7
Java support, 7.5.4.3
managing Web, 2.3.1
msql, 7.5.4.3
proxy, 11.5.2, 11.5.2.2
remote access, 2.3.1.1.2
SSL, 11.3.5
synchroniztion, 2.2
Mobile Device, 7.8
applying patches, 7.8.2
Mobile device
create commands, 1.2.2.2
customizing platforms, 1.2.2.2
Mobile devices
viewing information, 1.2.2
Mobile Manager
access, 4.1.1.1
how to use, 1
log on, 1.2
view active users, 13.2
Mobile repository
password, 11.2
Mobile Server
catalog views, D.1
configuration, A.2
configuring reverse proxy, 11.5.1.2
configuring SSL, 11.3.2
connect, 1.2
farm, 1.2, 4.1.2
information, 1.2.1
manage, 1.2
manage applications, 1.2.1.2
manage users, 1.2.1.3
management tool, 1
password, 11.2
SSL, 11.3
starting, 1.2.1
synchronization configuration, 5.5
tracing, 1.2.1.4
view active sessions, 1.2.1.4
view active users, 13.2
viewing, 1.2.1
Mobile Server Configuration Parameters
CONSOLIDATOR, A.7
DEBUG, A.4
FILESYSTEM, A.3
PUBLIC, A.5
SERVLET_PARAMETERS, A.6
WEBTOGO, A.2
Mobile Workspace
Web client, 2.3.1
msql
Mobile client, 7.5.4.3
msync
Client API (OCAPI), F.3
proxy, 11.5.2.2
msync executable, 2.3.2
Multi-User Service
debug, F.2.14
logging, F.2.13

N

network
failure
automatic synchronization, 5.4.3
network settings
automatic synchronization, 5.4.1
NLS_DATE_FORMAT parameter, F.2.10
NLS_LOCALE parameter, F.2.11
NLS_SORT parameter, F.2.12

O

object
cache size, F.2.1
obs file, 2.3.7
OCAPI, F.3
configuration parameters, F.3
overview, F.3.1
ODB file, 2.2
password, 11.2
odbc.ini
location, 7.2
Offline Instantiation
Deploying on Client Machines, 9.7
Setting Up the Mobile Client Root Directory, 9.3
Setting Up the Mobile Server Host and Mobile Development Kit Host, 9.2
The OLI CD's Directory, 9.4
The OLI Configuration File
Oli.ini, 9.5
Using the OLI Engine, 9.6
offline instantiation, 9.1
tool, 9.5
OID
migrating to use, 4.1.7
migrating users, 4.1.7
users, 4.1.2, 4.1.2.1, 4.1.7
oli.ini file, 9.5
OLITE_SERVER_LOG parameter, F.2.13
OLITE_SERVER_TRACE parameter, F.2.14
OLITE_SQL_TRACE parameter, F.2.15
OLITE_WRITE_VERIFY parameter, F.2.16
olmig executable, 2.3.7
operating system
version on Mobile Server host, 5.3.4
Oracle Internet Directory, see OID
Oracle Lite database
defragment, 2.3.7
password, 11.2
Oracle Tag Language, see OTL
OracleDatabaseLite user
setting password, 8.2.3, 11.6
OTL, 7.12
data types, 7.12.1
database connection, 7.12.6
DeviceManager, 7.12.7.2
HTTP request parameters, 7.12.7.1.1
HTTP session values, 7.12.7.1.1
operators, 7.12.2
sample, 7.12.10
Out-Queue
synchronization, 5.1
viewing subscriptions, 5.9.4.2

P

package command, 9.6.2
parameter
value, 3.5, 4.3
password
allowed characters, 4.1.3.1
OracleDatabaseLite user, 8.2.3, 11.6
reset, 2.3.4
summary, 11.2
patch
applying, 7.8.2
perfomance
analyzing synchronization, 5.10.3
performance
connection pooling, 3.4
Consperf utility, 5.10.3
limit database connections, 3.4
MGP, 5.10.2
Sync Server, 5.10.1
synchronization, 5.10
using temporary tables, F.2.18
WinCE, F.2.2
platform
custom, 7.5.4.3
platform rules
automatic synchronization, 5.4.1
POL-3207 message, F.2.16
policy
setting attributes, 7.8.3.2
polite.ini, 5.7.1
configuring reverse proxy, 11.5.1.3
location, 7.2
service_port parameter, 8.2.4, 8.2.6, F.2.20
service_wdir, 8.2.6
service_wdir parameter, F.2.21
polite.ini file
All Databases section, F.2
overview, F.1
parameters, F
synchronization parameters, F.3
polite.txt
description, F.1
port
device listener, F.4.2
ports
enabling on Windows Service Pack 2, 8.2.5
privilege
administrator, 4.1.1.1
defining, 4.1.3.1, 4.1.3.2
user, 4.1.1.2
provisioning, 4.1.1.3
proxy
configuration, F.5.2
Device Management, F.5.2
device port, F.4.2
reverse, 11.5, 11.5.2
Web-to-Go client, 11.5.2.1
publication item
setting parameter values, 3.5, 4.3
publication items
view as listed in repository, 5.9.3
publications
performance, 5.10.3
view as listed in repository, 5.9.2
publishing, 4.1.1.1
PUSH_PORT parameter, F.4.2

Q

queues
involved in synchronization, 5.1

R

registry entries, 3.9
REGISTRY_TAB, 3.9
reports
system summary, 13.1
repository
browsing publication items, 5.9
browsing publications, 5.9
browsing synchronization queues, 5.9
browsing users, 5.9
migrating users to OID, 4.1.7
password, 11.2
Resource Manager
setting attributes, 7.8.3.1
resume file, A.7.1
sizing, A.7.1
RESUME_CLIENT_MAXSEND parameter, A.7.1, F.3.2.7
RESUME_CLIENT_TIMEOUT parameter, A.7.1, F.3.2.6
RESUME_FILE parameter, A.7.1
RESUME_FILE_SIZE parameter, A.7.1
RESUME_MAXACTIVE parameter
synchronization
resuming interrupted, A.7.1
RESUME_MAXCHUNK parameter, A.7.1
RESUME_TIMEOUT parameter, A.7.1
retry
automatic synchronization, 5.4.3
reverse proxy, 11.5, 11.5.1, 11.5.2
configuring Mobile client, 11.5.1.3
SSL, 11.5.1.4
reverse_proxy parameter, 11.5.1.2
role
adding user, 4.4

S

Scripting Language for the Mobile Server
Description of the Syntax, B.1, B.1
Examples, B.3
Running a Script INI File, B.2
security, 4.1.1.3
sequence
collation, F.2.12
SERVER_URL parameter
reverse proxy, 11.5.1.3
SERVICE_PORT parameter, 8.2.4, 8.2.6, F.2.20
SERVICE_WDIR parameter, 8.2.4, 8.2.6, F.2.21
sessions
view active users, 13.2
setAttribute method, 7.8.3.1
setup.exe, 9.3
shared parameters
configuration, 5.5
SKIP_INQ_CHK_BFR_COMPOSE parameter, 5.1.1, A.7.1
SLEEP_TIME parameter, A.7.1
snapshot
accessing ODB, 2.2
snapshots
encryption, 5.7
software
request update, 2.3.6
update, 7.8.1
update time, F.4.3
SQL
compatibility, F.2.17
create database volume id, F.2.3
tracing, F.2.15
SQLCOMPATIBILITY parameter, F.2.17
SSL, 11.3
configuring Mobile Server, 11.3.2
creating certificate, 11.3.1
creating keystore, 11.3.1
disabling, 11.3.2.2
mixing secure and non-secure sites, 11.3.4
Mobile client, 11.3.5
No available certificate, 11.3.4
reverse proxy, 11.5.1.4
temporary certificate, F.3.2.14
troubleshooting, 11.3.4
upload certificate, 11.3.3
SSL_IGNORE_CERT, F.3.2.14
subscriptions
profiling, 5.10.3
swap space
temporary tables, F.2.18
sychronization
analyzing performance, 5.10.3
Sync Client
downloading data, 5.1, 5.1
SYNC section, F.3, F.3
Sync Server
alerts, 5.3.2
execution process, 5.1
history, 5.3.3
managing, 5.3
start, 5.3.1
statistics, 5.10.1
uploading data, 5.1
user sessions, 5.3.3
SYNC_AGENT, F.3.2.13
SYNC_HISTORY parameter, 5.3.3
synchronization, 2.3.1.1.5
alerts, 5.3.2
application, 2.3.1.1.2
automatic, 2.3.1.1.2, 2.3.1.1.2
retry after failure, 5.4.3
browsing repository, 5.9
client configuration, 2.3.1.1.2
client GUI, 2.3.2
client job, 2.3.1.1.2
composing transaction, 5.1
configuration, F.3
instance parameters, 5.5
shared parameters, 5.5
conflict, 5.9.4.3
correcting errors, 5.9.4.3
downloading data, 5.1, 5.1
error
re-execute transaction, 5.9.4.3
execution steps, 5.1
history, 5.3.3
memory threshold, F.3.2.10
Mobile client, 2.2
monitor with SQL scripts, 5.10.4
performance, 5.10
purge history, 6.3.5.2
queues, 5.1
view, 5.9.4
reaching client, A.2
scheduling, 2.3.1.4
sharing data among clients, 5.6
tracing, 5.8
DML operations, F.3.2.2
enabling debug messages, F.3.2.3
error reporting, F.3.2.8
timing, F.3.2.1
uploading data, 5.1
syncronization
overview, 5.1
system events
automatic synchronization, 5.4.1

T

tables
temporary, F.2.18
TEMP_DB parameter, F.2.18
TEMP_DIR parameter, F.2.19, F.3.2.5
temporary files
setting directory, F.3.2.5
threshold
memory, F.3.2.10
TIME_LOG parameter, F.3.2.1
timeout
client, A.7.1, A.7.1, F.3.2.6
TO_CHAR
format definition, F.2.10
TO_DATE
format definition, F.2.10
tracing
enabling debug messages, F.3.2.3
SQL, F.2.15
synchronization
DML operations, F.3.2.2
error reporting, F.3.2.8
timing, F.3.2.1

U

update
software for device, 4.1.3.3
UPDATE_DAY parameter, F.4.3
UPDATE_LOG parameter, F.3.2.2
update_software_apps attribute, 7.8.3.1, 7.8.3.2
update_software_platform attribute, 7.8.3.1
UPDATE_TIME parameter
device
specify time for next update, F.4.3
updating software, 7.8.1
Upgradable, 7.8.3.1
upgrade
software, 7.8.1
user
cached, 5.6
definition, 4.1.1
listed in repository, 5.9.1
password, 11.2
reset, 2.3.4
software update, 7.8.1
users
access applications, 4
add new, 4.1.3
adding roles, 4.4
administrator, 4.1.1.1
allowed characters in name, 4.1.3.1
application user, 4.1.1.2
authorization, 4.1.1.3
database users, 4.1.1
define display name, 4.1.3.1
define password, 4.1.3.1
define username, 4.1.3.1
delete, 4.1.5
device policy, 4.1.3.3
display, 4.1.2, 4.1.2
duplicating, 4.1.4
enabled, 4.1.2.1
managing, 4
migrating to OID, 4.1.7
OID, 4.1.2, 4.1.2.1, 4.1.7
privilege, 4.1.3.1, 4.1.3.2
privileges, 4.1.1
properties, 4.1.3
repository, 4.1.2
revoke access, 3.6, 4.2.1
search, 4.1.2.2
types of, 4.1.1
view active, 13.2
Using the JDBC Driver
Upload the Oracle JDBC Driver, E.1
Using the JDBC Thin Driver
Change the Applet Tag, E.2
UTF8 encoding, F.2.4

V

VALIDATEDB parameter, F.3.2.11
variable
setting, 3.5, 4.3
volume id
database, F.2.3

W

WAR
adding WAR file to application, 3.8
Web
Workspace options, 2.3.1.1.2
Web Application Archive, see WAR
Web client
remote access, 2.3.1.1.2
Web-to-Go
configuring SSL, 11.3.5
downloading files, 3.7
enable connection pooling, 3.4
performance, 3.4
proxy communication, 11.5.2.1
set database connection limit, 3.4
SSL certificate, 11.3.3
synchronization options, 2.3.1.1.2
webtogo.inf file
configuration, 7.2.2
webtogo.ora, A.2
configuration, 5.5
configuring reverse proxy, 11.5.1.2
WinCE
define database location, F.2.2
temporary files directory, F.3.2.5
Windows
Service Pack 2, 8.2.5
Workspace
Applications tab, 2.3.1.1.1
configuration, 2.3.1.1.2
Configuration tab, 2.3.1.1.2
directions, 2.3.1.1
executing applications, 2.3.1.2
Log Off tab, 2.3.1.1.6
logging on, 2.1.2
Mobile Manager, 1
password, 2.3.1.1.2
scheduling synchronization, 2.3.1.4
Sync tab, 2.3.1.1.5
Web client, 2.3.1

Z

ZIP
download, 7.11.5
inflate, 7.11.5