Oracle 9i Lite for PocketPC Installation ======================================== A. Create an Install CD ----------------------- 1. If you do not already have Java SDK 1.3 installed on your PC, download and install the "J2SE v1.3.1_14 SDK" for Windows from: http://java.sun.com/products/archive/j2se/1.3.1_14/index.html 2. Download the Oracle 9i Lite install zip file from Oracle at: http://www.oracle.com/technology/software/products/lite/index.html The 9i Lite download is the 2nd item in the 2nd group of downloads: "Oracle9i Lite Release 5.0.2 for Windows CE, 95/98/NT/2000, Pocket PC, Palm Computing Platform, and EPOC". 3. Unzip the download file (using the "Use folder names" option) on a hard drive into a new folder such as C:\Oracle. 4. Burn an Oracle Lite Installation CD with the contents of the "disk1" folder and the Java 1.3.1 SDK install file. This is optional, but lets you install Oracle Lite on other PCs without doing another download. B. Install Oracle Lite on Staging PC --------------------------------------- 1. REBOOT YOUR PC AND STOP ALL NON-ESSENTIAL PROGRAMS, especially browsers, personal firewalls and anti-virus programs such as McAfee, Norton, Trend etc. as they may interfere with the Oracle installer process. Verify that you have already installed ActiveSync on this PC. 2. Insert the Oracle Lite Installation CD (if you created one after extracting the zipped install file). Otherwise, open Windows Explorer and navigate to the "disk1" folder in the extracted install folder. 3. The install program should autostart from the CD. If not, or if running from the hard drive, run setup.exe. 4. Accept the provided defaults for all folder names etc. 5. Select a "custom" install 6. Select the following to install by X'ing the boxes: Under Mobile Development Kit: - Win32 - WinCE Under Docs - 9i Lite Docs 7. This installs Win32 and WinCE software on the staging PC. C. Load Jargon Reader on PocketPC --------------------------------- 1. Start Windows Explorer on your PC. 2. Select the Jargon Reader executable (ReaderPPO.exe, ReaderSYO.exe, ReaderPSO.exe or ReaderWCO.exe) in your Jargon installation folder and copy it (Edit-->Copy or CTRL-C). 3. Open the Mobile Device/My PocketPC/Windows/Start Menu folder and paste the executable there (Edit-->Paste or CTRL-V). D. Install Oracle Lite on PocketPC ------------------------------------- 1. Open the Active Sync window on your PC 2. Select Tools-->Add/Remove Programs 2. Select PocketPC ARM 3. Click "OK" and it will install Oracle Lite on the Pocket PC. E. Create an Oracle Lite Database on PocketPC ------------------------------------------------ 1. On PocketPC, open File Explorer and go to /orace 2. Click MSQL.exe 3. At bottom, scroll over and open "tools" 4. Create db and assign your chosen DB name (e.g. "mydb") 5. Scroll to left and try to connect 6. If it can't find db, go to File Explorer and open the "odbc", "polite" or "mydb" documents and see if it is putting it in "\storage card" instead of "\orace". If so, edit the document and save it (autosave on close). 7. When you can connect to the db, it is ok, so end MSQL F. Load Schema and Data in PocketPC Database --------------------------------------- 1. Start the Jargon Reader executable (ReaderPPO.exe, ReaderSYO.exe, ReaderPSO.exe or ReaderWCO.exe) from the Start Menu. 2. Load and run odbcutil from your server. If you do not yet have this set up on your server, you can run a copy from: http://www.jargonsoft.com/V3/xml/util/odbcutil.ini 3. Connect to your database (e.g. "mydb"). If your database name is in the combobox list, select it. Otherwise, enter the db name, and enter "SYSTEM" for both UserID and Password. Note that combobox database name entries come from the "DBNames" parameter in the odbcutil.ini (or odbcwin.ini) file. 4. Click "SQL Updates" 5. Select an appropriate "SQL File Access Method" and a corresponding pathname for a text file containing SQL DDL statements that you have previously built, and click "Get SQL File": examples of each access method: Filename on Local Device: /Jargonsoft/Data/mydb_bld.sql Filename on Middleware Server: C:/Inetpub/wwwroot/sql/mydb_bld.sql File URL on Web Server: http://www.jargonsoft.com/sql/mydb_bld.sql 6. Check "Show SQL stmt detail in log" if you want to see each DDL statement, then click "Execute SQL" to load your database schema. When it ends, review the log to see if there were any errors. 7. Load other basic data such as system tables using similar sql files or by means of an application download program. You should probably NOT check the "Show SQL stmt detail in log" option for data file loads, as the number of statements may overflow the capacity of the text component used to show the log. G. Create an Oracle Lite Database on PC (optional) ----------------------------------------------------- For testing and performance reasons, you may wish to create an Oracle database on your PC and use it with apps running in the PDA Emulator. Note that databases can be created and populated on your PC and then copied to a PocketPC, which is very fast. The file formats are compatible. 1. On the PC, open a command prompt (Run-->CMD) and go to the folder where you installed Oracle in step B-4 above (such as "C:\ora90"). 2. In the command window, go to the MOBILE\SDK\BIN folder. CD MOBILE\SDK\BIN 3. type the following command (use your new db name) and press ENTER to create a new database in the MOBILE\SDK\OLDB40 folder: CREATEDB POLITE [new DB name] Example to create a new database named "mydb": C:\ORA90\MOBILE\SDK\BIN>createdb POLITE MYDB Database "C:\ORA90\MOBILE\SDK\OLDB40\MYDB.odb" created (VolID = 502) 4. To configure an ODBC data source for this new database, run the ODBC admin tool. On Windows XP, run: Start-->Control Panel-->Administrative Tools-->Data Sources(ODBC) 5. Click "Add", then select "Oracle Lite 40 ODBC Driver" and click "Finish". 6. In the Setup window that pops up, enter values as follows: - Data Source Name, Data Description and Database fields: enter your new database name (such as "MYDB") - Database Directory: click browse, then navigate to and select: [Oracle install folder]\Mobile\Sdk\OLDB40 For other parameters, select from combobox as follows: - Default Isolation Level: Single User - Autocommit: Off - Default Cursor Type: Dynamic Then click "OK" to finish configuring this new ODBC data source. 7. Add your db name to the "DBNames" parameter in the odbcutil.ini and odbcwin.ini parameter files to see it in the default db names combobox. example: DBNames=MYDB,JOE,POLITE 8. You can now run apps in ReaderPDA or ReaderWIN that specify this "MYDB" data source name and they should connect to your new database. Run odbcutil or odbcwin to verify this and to load schema and data values (as in step F above for the PocketPC).