DBPrism - 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/10g

Go DBPrism distribution root directory and execute ant install-toolkit8i it will install DBPrism Java XML Toolkit on sys schema and it will create public synonyms using the dba username and password stored on common.xml file.

PLSQL XML Toolkit for Oracle 8i/9i/10g

Go DBPrism distribution root directory and execute ant install-xtp-public it will install DBPrism PLSQL XML Toolkit on sys schema and it will create public synonyms using the dba username and password stored on common.xml file.

Java XML Toolkit for Oracle Lite

Go DBPrism distribution root directory and execute ant install-toolkitLite it will install DBPrism Java XML Toolkit on sys schema and it will create public synonyms using the dba username and password stored on common.xml file.