Installation of PLSQL toolkits

Oracle Web Server 3.x log with SQL/Plus, for example as scott/tiger, and type SQL> set scan off go to the admin directory under the $ORAWEB_HOME, and runs the script owains.sql typing: SQL> @owains.sql go to the plsql directory under the $DBPRISM_HOME, and runs the script xtp.sql typing: SQL> @xtp.sql DAD setting with Oracle 7x databases, sets dad.compat=7x and dad.toolkit=3x DAD setting with Oracle 8x databases, sets dad.compat=8i and dad.toolkit=3x Oracle Web DB log with SQL/Plus, as user sys create an user named owa_public with the command: SQL> create or replace user owa_public identified by owa_public go to the owa40 directory under the Web DB home directory, and runs the script owaload.sql typing: SQL> @owaload.sql OWA_PUBLIC users temp owaload.log OWA_PUBLIC connect with SQL/Plus as owa_public/owa_public@connect_string and go to the plsql directory under the $DBPRISM_HOME, and runs the script xtp_public.sql typing: @xtp_public.sql DAD setting with Oracle 7x databases, sets dad.compat=7x and dad.toolkit=4x DAD setting with Oracle 8x databases, sets dad.compat=8i and dad.toolkit=4x Oracle Web Server 4.x log with SQL/Plus, as user sys create an user named owa_public with the command: SQL> create or replace user owa_public identified by owa_public; SQL> grant connect, resource to owa_public identified by owa_public; SQL> alter user owa_public default tablespace users; SQL> alter user owa_public temporary tablespace temp; SQL> grant execute on DBMS_SYS_SQL to owa_public; SQL> grant drop public synonym to owa_public; SQL> grant create public synonym to owa_public; connect with SQL/Plus as owa_public/owa_public@connect_string and go to the cartx/plsql/admin directory under the OAS home directory, and runs the script ctowasyn.sql typing SQL> @ctowasyn.sql connect with SQL/Plus as owa_public/owa_public@connect_string and go to the plsql directory under the $DBPRISM_HOME, and runs the script xtp_public.sql typing: SQL> @xtp_public.sql DAD setting with Oracle 7x databases, sets dad.compat=7x and dad.toolkit=4x DAD setting with Oracle 8x databases, sets dad.compat=8i and dad.toolkit=4x Oracle Internet Application Server 1.0.x log with SQL/Plus as user sys go to the Apache/modplsql/owa directory under the $ORACLE_HOME, and runs the script owaload.sql typing: SQL> @owaload.sql change_on_install OWA_PUBLIC OWA_PUBLIC users temp connect_string owaload.log connect with SQL/Plus as owa_public/owa_public@connect_string and go to the plsql directory under the $DBPRISM_HOME, and runs the script xtp_public.sql typing: SQL> @xtp_public.sql DAD setting with Oracle 7x databases, sets dad.compat=7x and dad.toolkit=4x DAD setting with Oracle 8x databases, sets dad.compat=8i and dad.toolkit=4x Upload/Download support with IAS toolkit log with SQL/Plus as sys/change_on_install@connect_string go to the plsql directory under the $PRISM_HOME, and runs the script doctbl.sql, this script creates the tables used by upload/download functionality. Java XML Toolkit for Oracle 8i/9i go to "oi" directory under the $PRISM_HOME, and runs the script install-toolkit.sh or install-toolkit.bat, this script assumes sys as default schema, edits them if you need other schema. Jxtp toolkit requires XDK 9.0.x installed on sys schema and the script creates publics synonyms. Java XML Toolkit for Oracle Lite go to the "polite" directory under the $PRISM_HOME, and runs the script install-toolkit.bat, this script assumes system as default schema, edits them if you need other schema.