Untitled

NAME

README.txt - ORACLE8 SERVER TIME SERIES CARTRIDGE RELEASE INFORMATION

VERSION=8.0.4.0.0 README FILE

ORACLE8 TIME SERIES CARTRIDGE RELEASE INFORMATION

=======================

Contents

========

Warnings

Installation Procedures

Installing the Demo

Quotas for Running Time Series Cartridge

Installing the Demo

Internationalization

Known Bugs (on all platforms)

Warnings

========

The Time Series Cartridge is installed under the database user ORDSYS. This

user is created during installation and is subject to change in future

beta or production releases.

THE FUNCTIONS, PACKAGES AND TYPES SUPPLIED BY THIS PACKAGE AND ITS EXTERNAL

INTERFACE ARE RESERVED BY ORACLE AND ARE SUBJECT TO CHANGE IN FUTURE RELEASES.

THESE PACKAGES MUST NOT BE MODIFIED BY THE CUSTOMER. DOING SO

COULD CAUSE INTERNAL ERRORS AND SECURITY VIOLATIONS IN THE DBMS.

If you created database objects during the installation of the Time Series

Cartridge, the password for the ORDSYS user may have been written to the log

file. Please check your installation log files for this and other important

information.

=======================

Installation Procedures

=======================

For Solaris, users have the option of installing the entire cartridge

including its database components automatically from within the

Oracle Installer. To do so, users simply need to install Oracle8 RDBMS,

the PL/SQL option, the Time Series Cartridge, and any other options

as appropriate, making sure to select the Create DB Objects option.

This section describes the steps required to manually install the

Time Series Cartridge and is intended for those wishing custom craft

their database installation, or those simply wishing to better understand

the Time Series installation process:

1 Cartridge Related Installation Decisions

During the installation process you will need to create

ORDSYS as a user for Oracle cartridges, if it does not already

exist. This user ID is the standard Oracle database account

with special privileges for data cartridges.

Users will need to decide on a password for the ORDSYS user.

2 Software Installation

Minimally, the following software components must be installed:

Oracle8 Enterprise Edition (RDBMS), PL/SQL (on platforms on which

it is a separate installation option), and the Oracle8 Time Series

Cartridge.

This software may be installed all at once, or the cartridge can

be added to an existing Oracle8 Enterprise Edition version 8.0.4

installation which includes PL/SQL.

3 Create and Startup the Database

The details of manual database creation are outside of the scope

of this README. Please refer to the Oracle8 Installation and

Configuration Guide for your operating system and to the Oracle8

Server Administrator's Guide and Server Concepts manuals for

detailed information about database creation and startup.

4 Install the UTLREF Package (needed by the cartridge)

As DBA, execute the following:

SVRMGR> @<ORACLE_HOME>\rdbms80\admin\utlrefld.sql

where <ORACLE_HOME> is the ORACLE_HOME directory.

5 Create the ORDSYS Account If Needed (It may already exist.)

As DBA, execute the following:

SVRMGR> create user ORDSYS identified by <ORDSYS password>;

6 Set Privileges for ORDSYS Account

As DBA, execute the following:

SVRMGR> grant connect,resource,create library to ORDSYS;

7 Install the Time Series Cartridge types and stored procedures:

SVRMGR> connect ORDSYS/<ORDSYS password>

SVRMGR> @<ORACLE_HOME>\ord80\ts\admin\ordtinst.sql

where <ORACLE_HOME> is the ORACLE_HOME directory.

Note: Execute privileges will be granted to PUBLIC for all Time Series

types and packages.

=======================

Quotas for Running Time Series Cartridge

========================================

It is recommended that "shared_pool_size" in the init.ora be set to

a large setting (at least 8000000). For this quota to take affect

you need to shutdown and restart the server.

=======================

Installing the Demo

===================

Once you have installed the Time Series cartridge, and set the

recommended "shared_pool_size" quota, you may choose to

install the Time Series cartridge demos.

The Time Series demo files are located in <ORACLE_HOME>\ord80\ts\demo.

This directory contains several demos each in its own subdirectory.

The "usage" demo shows how to build a time series object and call time

series functions. The "extend" demo shows how to write and

add customized time series functions. The "proc" demo demonstrates

accessing data stored with the cartridge using Pro*C. Similarly,

the "oci" demo demonstrates accessing data via the Oracle Call

Interface. And finally the "dev2k" demo includes a Developer 2000

form which retrieves data using the cartridge.See README.txt in the demo

directory for more information. Also see the README.txt file

in each demo directory for detailed information about that demo.

All demos utilize the context established by the "usage" demo, so

one will want to run it first to create sample time series schemas.

=======================

Internationalization

====================

Time Series tables and object tables supports the database character set.

Error messages and display functions have been fully internationalized.

=======================

Known Bugs (on all platforms)

=============================

o After connecting as a user of time series functions and invoking

a time series function, if one connects again (without disconnecting)

a communication pipe failure sometimes occurs. The workaround

is to disconnect before reconnecting.

o If the calendars are not consistent with the time series data sometimes

an internal error will be generated.

ORA-00600: internal error code, arguments: [koxsihread1], [], [], [], [], [], [], []

Workaround is to check the time series using ValidateTS. This will

give diagnostics as to how the time series is inconsistent.

o Using the CAST and MULTISET to instantiate a ORDTDateTab may fail when

the number of dates is larger than approximately 1000. This can

occur when using TimeSeries.DeriveException (Method 1, using

a ORDTCalendar and an ORDTDateTab as input.) The failure causes

an internal error:

SVRMGR> update my_calendars cal

2> set cal = (select ORDSYS.TimeSeries.DeriveExceptions(

3> value(cal),

4> cast(multiset(

5> select s.tstamp

6> from myiot s

7> where s.name = 'FOO') as ORDSYS.ORDTDateTab))

8> from dual

ORA-00600: internal error code, arguments: [kokbacel1], [11], [], [], [], [], [], []

Workaround is to use the second variation of TimeSeries.DeriveException

(Method 2) that takes in two time series refs.

This error also occurs when inserting into calendar using a constructor

with a large number of exceptions. The workaround in this case is to

construct the calendar in a PLSQL variable and then use the variable

as the value for the insert statement.

END OF README.txt