======================================= DBFTP Copyright (c) 2001 Bear Claw, Inc. All Rights Reserved ======================================= DBFTP Requirements: 1. Java 1.2 or higher to be installed in the database prior to installing DBFTP. 2. Database Version: Oracle 8i (8.1.6) or higher. If these requirements have already been met skip to step 2. 1) Review Oracle documentation on how to install Java Server in the database at: Oracle 9.2.x - http://download-west.oracle.com/docs/cd/B10501_01/java.920/a96656/config.htm#1008482 (Under Section 4). To install Java Server review initjvm.sql, found in $ORACLE_HOME/javavm directory. 2) Next Install DBFTP: a) Go to the Command Line Prompt (e.g., Dos Prompt for Windows users). b) Move to the directory where you just unzipped the files (e.g., where ReadMeFirst.txt is located). c) Type: loadjava -u /@ -r -v DBFTP.jar d) Run sqlplus /nolog @installme.sql. e) Run sqlplus /@ @addkey.sql 3) Need to set Java Security Permissions: 3.1 Required Permissions for DBFTP: java.io.FilePermission - read, write, delete, execute java.net.SocketPermission - connect, resolve, listen, accept Example: execute DBMS_JAVA.GRANT_PERMISSION('TESTER', 'java.net.SocketPermission', '*', 'connect,resolve,listen,accept'); execute DBMS_JAVA.GRANT_PERMISSION('TESTER', 'java.io.FilePermission', '<>', 'read, write, delete, execute'); 4) To have additional USERS run DBFTP. Objects the user will need access to are: grant execute on fclient_j to grant execute on fclient_p to 5) Ready to run DBFTP: a) Run examples in examples.sql. 6) For licensing issues refer to license.txt (located in the installed directory). 7) Uninstall: a) dropjava -u username>/@ -v DBFTP.jar b) Run sqlplus /nolog @uninstallme.sql. c) delete the files from the disk. Installation/DeInstallation Problems: e-mail - support@bearclawinc.com call - (425) 268-8063 feedback - http://www.bearclawinc.com/feedback.htm bugs - http://www.bearclawinc.com/cgi-bin/bug_report.cgi