[ic] Setting up Oracle database for InterChange

[Jeff Gill]

Thanks for insights Dan.


>From: Dan Browning <dbml@kavod.com>
>To: interchange-users@icdevgroup.org
>CC: zzjg1@hotmail.com
>Subject: Re: [ic] Setting up Oracle database for InterChange
>Date: Wed, 07 Aug 2002 17:15:23 -0700
>
>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.




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com