[ic] Setting up Oracle database for InterChange

[interchange-users@icdevgroup.org (Dan Browning)]

At 04:21 PM 8/7/2002 -0700, Jeff Gill wrote:
>Environment
>RedHat 7.3
>Oracle Release 1 (9.0.1) 9iRAC
>InterChange 4.8
>
>I am looking for hints/documentation on setting up Oracle for InterChange 
>with the sample foundation database.

If you can setup Oracle on Red Hat 7.3, then Interchange will be a cakewalk.

>I have searched the interchange.redhat.com and the Internet for faqs and 
>docs but I could not find anything.  With a postgres database the makecat 
>script does everything (table creation, index creation, and populating db 
>with foundation data) for you after you a create a database and a user 
>with privileges.

The indices can be autocreated for Oracle as well.

>I am trying to figure what preconfiguration i.e data tablespaces and index 
>tablespaces need to be preallocated (shared disk storage - for logical 
>volume creation) created before installing Oracle and creating an initial 
>database.

Perhaps someone with experience setting up IC on Oracle can answer this, 
but I don't believe that makecat will do these steps for you.  The 
foundation template is rather simple, so you can start with pretty skimpy 
tablespaces if you need to.

>I don't know if makecat will do everything required or not? Has anyone 
>successfully created an Oracle 9i RAC with InterChange?  Your insights 
>will be sincerely appreciated.

It has been done.  Please note the dbconf/oracle/*.ora files for 
information about the fields and indices.

+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| Dan Browning, Kavod Technologies <db@kavod.com>
+~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
In Seattle, Washington, it is illegal to carry a concealed weapon that
is over six feet in length.