Re: [Gusdev-gusdev] more help with installation please

[Angel P. <an...@pc...>]

I answer the second question.

Matthew Hobbs wrote:

>ii) More importantly I can't get create-db.sh to create the CORE user:
>
>
>SQL> 
>SQL> CREATE USER Core IDENTIFIED BY password1
>  2    TEMPORARY TABLESPACE TEMP
>  3    DEFAULT TABLESPACE tablespace1
>  4    QUOTA UNLIMITED ON TEMP
>  5    QUOTA UNLIMITED ON tablespace1;
>CREATE USER Core IDENTIFIED BY password1
>*
>ERROR at line 1:
>ORA-00959: tablespace 'TABLESPACE1' does not exist 
>
>  
>
"password1" and "tablespace1" should be replaces with appropriate values 
from your particular instance. These values are configurable from the 
GUS/Model/config/schema.prop prior to building GUS/Model/schema

 From that file:

# The names, passwords, and tablespaces for the new users.
# It is recommended that you do NOT change the default usernames
# as this feature has not been fully tested (the username is the
# first parameter in each group of four.)
#
oracle_core=Core
oracle_corePassword=password1
oracle_coreTablespace=tablespace1
oracle_coreIndexTablespace=indextablespace1

>
>Although I had created some tablespaces (gus_core, etc) using the  table 
>initialization script 'installguide02.sql' these did not include TABLESPACE1 
>et al.  Should I do something like:
>  
>
Yeah, I don't know much about that script, but db administration 
particulars are a little outside the scope of a GUS install. Please use 
the schema.prop file for setting appropriate logins and tablespace usage.
Angel

>
>create tablespace TABLESPACE1
>datafile '/usr/local/Oracle/oradata/gus/TABLESPACE1' size 200M
>default storage (initial 4M next 1M pctincrease 0);
>
>  
>