Re: [GUSDEV] Gus Build problems

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

There's not an easy way to do this at the moment... There should be a
deinstall script in the trunk by EOD

Here's what I do (in Oracle):

drop user core cascade;
drop user prot cascade;
drop user study cascade;
drop user dots cascade;
drop user tess cascade;
drop user rad cascade;
drop user sres cascade;

drop user corever cascade;
drop user protver cascade;
drop user studyver cascade;
drop user dotsver cascade;
drop user tessver cascade;
drop user radver cascade;
drop user sresver cascade;



--Mike




On 10/19/05 1:55 PM, "Juan Carlos Perin" <bi...@ge...> wrote:

> Mike,
> 
> This is a clean install, on a brand new instance of oracle.  If anything is
> in there from GUS, it'd be from a previous attempt to build.  In any case, I
> assume a cleanout would do the trick.  Is there an easy way to do that?
> 
> THANKS
> 
> 
> On 10/19/05 1:09 PM, "Michael Saffitz" <msa...@pc...> wrote:
> 
>> 
>> Hi Juan,
>> 
>> It looks like there's an existing GUS instance.  Make sure to completely
>> clean out the database (by dropping all GUS users-- Core, DoTS, SResVer,
>> DoTSVer, and so on) an then reinstalling.  (Note:  You will loose any data
>> in these schemas when you drop them!).
>> 
>> --Mike
>> 
>> 
>> On 10/19/05 11:08 AM, "Juan Carlos Perin" <bi...@ge...> wrote:
>> 
>>> Hello, I'm very new to oracle and have had a few issues building GUS.  I'm
>>> running Oracle 10g on a Poweredge server running Redhat AS3.  I've created a
>>> tablespace called GUS to build into, and finally got past some 'connect'
>>> errors.  I get the following error when running build:
>>> 
>>> BUILD FAILED
>>> /home/oracle/GUS/project_home/install/build.xml:28: The following error
>>> occurred while executing this line:
>>> /home/oracle/GUS/project_home/GUS/build.xml:92: java.io.IOException: Error
>>> executing SQL: '
>>> CREATE USER SResVer IDENTIFIED BY temppass PASSWORD EXPIRE ACCOUNT LOCK
>>> QUOTA UNLIMITED ON USERS DEFAULT TABLESPACE USERS' Error: ORA-01920: user
>>> name 'SRESVER' conflicts with another user or role name
>>> 
>>> The last time I tried, it gave me this error when trying to create User
>>> PROT.  I'm not sure why it got to different points, nothing changed.  I am
>>> using an oracle account I created that I gave all privileges to.  I assume
>>> maybe I'm getting this error because of multiple attempts to build, but I'm
>>> not sure how to clear things off to start again, if that's the case.  Any
>>> pointers would be great.  I'm happy to read documentation, just wish I knew
>>> where to start.  Thanks all!
>>> 
>>> Juan Perin
>>> 
>>> 
>>> 
>>> 
>>> -------------------------------------------------------
>>> This SF.Net email is sponsored by:
>>> Power Architecture Resource Center: Free content, downloads, discussions,
>>> and more. http://solutions.newsforge.com/ibmarch.tmpl
>>> _______________________________________________
>>> Gusdev-gusdev mailing list
>>> Gus...@li...
>>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>> 
>> 
>> 
>