Re: [GUSDEV] Re: GUS 3.5 installation failure

[Michael S. <msa...@pc...>]

You'll also need to comment out line 95 in
$PROJECT_HOME/GUS/Schema/src/java/org/gusdb/schema/InstallSchemaTask.java

This is experimental and "not supported"

Just out of curiosity, why do you want more than one tablespace?

--Mike


On 6/27/05 3:38 PM, "Jian Lu" <jl...@vb...> wrote:

> Yes, that is only change I made. Before I had ant 1.6.4.
> 
> So if I modify the gus_shema.xml for different tablespaces, the
> installation will skip tablespace defined in gus.config. Is that right?
> 
> 
> Michael Saffitz wrote:
> 
>> Hi Jian,
>> 
>> That's very strange-- I'm running with ant 1.6.2 here without issue.  Just
>> to confirm-- the only change you made was to move to ant 1.6.5?
>> 
>> GUS 3.5 by default installs into a single tablespace (as defined in the
>> gus.config file).  If you want it to install into more than one, you'd need
>> to update the gus_schema.xml to use the proper tablespaces for the relevant
>> objects, and comment out the lines in the DBAdmin sources that do tablespace
>> name translation.
>> 
>> If having more than one tablespace is a feature you'd like, submit a feature
>> request in the issue tracker.
>> 
>> Also, since you had a failed install, you'll need to make sure that any
>> objects that were created (i.e. Users) are deleted before trying again.
>> 
>> I'll create an issue to make sure that the documentation is updated to
>> include more details about configuring the tablespaces.
>> 
>> --Mike
>> 
>> On 6/27/05 3:17 PM, "Jian Lu" <jl...@vb...> wrote:
>> 
>>  
>> 
>>> I ran installation again under apache-ant 1.6.5. It went through for
>>> schema installation. I had the following error:
>>> 
>>> [InstallSchema] INFO: Writing Database
>>> 
>>> BUILD FAILED
>>> /home/brcgusts/GUS/project_home/install/build.xml:28: The following
>>> error occurred while executing this line:
>>> /home/brcgusts/GUS/project_home/GUS/build.xml:92: java.io.IOException:
>>> Error executing SQL: '
>>> ALTER USER PROT QUOTA UNLIMITED ON GUS' Error: ORA-00959: tablespace
>>> 'GUS' does not exist
>>> 
>>> It sounds like looking for tablespace called GUS which defined within
>>> gus.config file:
>>> 
>>> # Username, group, and project info from the relevant Core tables
>>> 
>>> userName=$ENV{USER}
>>> group=dba
>>> project=GUS
>>> 
>>> tablespace=GUS
>>> 
>>> My question: does GUS 3.5 uses only one tablespace called GUS? As I
>>> know, GUS 3.0 has at least 12 tablespaces. Please clarify it. Thanks.
>>> 
>>> 
>>> 
>>> -------------------------------------------------------
>>> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
>>> from IBM. Find simple to follow Roadmaps, straightforward articles,
>>> informative Webcasts and more! Get everything you need to get up to
>>> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
>>> _______________________________________________
>>> Gusdev-gusdev mailing list
>>> Gus...@li...
>>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>    
>>> 
>> 
>>  
>> 
>