Installation Notes
This page will walk you through the installation of Tascha.
Prerequisites
Tascha has been tested on Oracle 8i and 9i, it may work on previous and future versions but these have not been tested. Because Tascha runs inside Oracle the operations system should not come into play - if dbms_job works then Tascha should work.
To create the Tascha schema you will need access to a user who can grant certain privileges to the schema - probably sys or some other dba user. See install.sql in the install directory for details of the privileges required.
For Tascha to function you must have jobs enabled on your instance. See you administrator for details of this.
Before you can install Tascha you'll need to download the latest version. Once downloaded unzip/tar the file onto the server where the target Oracle instance resides.
Installing Tascha
To install tascha you simply need to connect to the privileged account described above and run install.sql in the install directory. The installation output will be logged to a file called "install.log", check this file for errors once the process is complete.
Below is an example of a Tascha installation.
{TEST:oracle}>ls -l
total 4
drwxr-x--- 2 oracle dba 512 18 Mar 08:57 Doc
drwxr-x--- 2 oracle dba 512 18 Mar 08:57 eg
drwxr-x--- 2 oracle dba 512 18 Mar 08:57 install
drwxr-x--- 2 oracle dba 512 18 Mar 08:57 utils
{TEST:oracle}>cd install
{TEST:oracle}>sqlplus /nolog
SQL*Plus: Release 9.2.0.6.0 - Production on Fri Mar 18 09:35:12 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> @install
Enter user name (XXTASCHA) :
Enter password (XXTASCHA) :
Enter tablespace (TOOLS) :
Enter temporary tablespace (TEMP) :
Enter mail smtp gateway (e.g. smtp.mydomain.com) : mailserv
Enter smtp gateway port (25) :
Enter email account to send mails from (e.g. support@mydomain.com) : bob.debolina@mydomain.co.uk
Enable debug logging? Y/N (N) :
Enable info logging? Y/N (Y) :
Enable error logging? Y/N (Y) :
DROP USER XXTASCHA CASCADE
*
ERROR at line 1:
ORA-01918: user 'XXTASCHA' does not exist
User created.
Grant succeeded.
Grant succeeded.
Connected.
Procedure created.
PL/SQL procedure successfully completed.
Table created.
Comment created.
Comment created.
Index created.
PL/SQL procedure successfully completed.
Sequence created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Table created.
Comment created.
1 row created.
1 row created.
1 row created.
Commit complete.
Table created.
Comment created.
PL/SQL procedure successfully completed.
Sequence created.
Table created.
Comment created.
Comment created.
Table created.
PL/SQL procedure successfully completed.
Sequence created.
Comment created.
Comment created.
Comment created.
Comment created.
Comment created.
Comment created.
Comment created.
Comment created.
Comment created.
Comment created.
Comment created.
Table created.
Comment created.
PL/SQL procedure successfully completed.
Sequence created.
PL/SQL procedure successfully completed.
Table created.
Comment created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Table created.
Comment created.
Comment created.
Comment created.
Comment created.
PL/SQL procedure successfully completed.
Table created.
Comment created.
PL/SQL procedure successfully completed.
Package created.
Package created.
Trigger created.
Trigger created.
Trigger created.
Trigger created.
Trigger created.
Trigger created.
Trigger created.
Package body created.
Package body created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
Commit complete.
PL/SQL procedure successfully completed.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Producti
on
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production