My Oracle Support Banner

How to Synchronize Data with Berkeley DB and Oracle Mobile Server (Doc ID 1195354.1)

Last updated on JANUARY 08, 2020

Applies to:

Oracle Lite - Version to [Release 10.3]
Information in this document applies to any platform.
***Checked for relevance on 29-Aug-2013***


Oracle Mobile Server support to Synchronize the data from  Berkeley DB (BDB) 5.0 and higher.

NOTE: The data used below are not actual PRODUCTION or Customer Data.  They are being used ONLY to demonstrate the problem/solution discussed in this note.

But there is no simple Mobile Client for BDB, here the steps to do it:


Step 1: download BDB 5.0.26 from
I used the zip file: Berkeley DB, with AES encryption (39M)
Building the Berkeley DB using these Doc

Step 2: Rename Binaries
Once you have built the binaries (libdb_sql50.dll and dbsql.exe) rename those files to sqlite3.dll and sqlite3.exe.

Step 3: Copy File to the Mobile Server
Copy those files to the Mobile Server under the following path:

Modify the following file:

Add the following entry that is in bold lettering:


This is optional. The sqlite3.exe is equivalent to msql or sql*plus.

Step 4: Install the mobile client for SQLite WIN32 and configure a Mobile Application for SQLite WIN32 with a publication and a Publication Item for SQLite based on select * from scott.dept.

Step5: Synchronize using msync

Step6:  Open An Ms Dos box:
cd C:\mobileclient\sqlite\sqlite_db\<NAME>
sqlite3 PUB_BDB.db
Berkeley DB 11g Release 2, library version (June 25, 2010)
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
dbsql> select * from dept;

The other option is to apply the one-off  <Patch 11671293> + <Patch11837664> which will create a new Mobile client for BDB. It is best option to configure the Mobile Server.


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

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