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

[Matthew H. <mat...@ve...>]

Thanks Angel and Steve for your replies to my previous message.  

I am however still struggling with this installation!  I am still getting 
errors when running create-db.sh.  Angel advises me to 'use the schema.prop 
file for setting appropriate logins and tablespace usage' but I don't 
understand how schema.prop and create-db.sh could  interact.  schema.prop is 
referrred to in GUS/build.xml and is used by ant in the build - but this is 
not where I am having my problem.  As explained in installguide.html the 
build must be run three times.  Between build 2 and build 3 the createdb.sh 
script is run.  How is create-db.sh supposed to read any of the information 
in schema.prop?  

Having created some more tablespaces (answering my own previous question) the 
first error reported by create-db.sh is now:


SQL> DROP USER @oracle_rad@ CASCADE;
DROP USER @oracle_rad@ CASCADE
          *
ERROR at line 1:
ORA-01935: missing user or role name 


This is the first place in the input sql file that '@' notation is 
encountered.  I guess @oracle_rad@ is a variable but SQL*Plus doesn't know 
its value.  Is the value is supposed to be read from schema.prop (a wild 
guess but schema.prop does seem to have assignemnts of values to similar 
names like 'oracle_rad3')???


Again I would be grateful for help.


Thanks,


Matthew




-- 
Matthew Hobbs         Research Fellow in Bioinformatics
Faculty of Veterinary Science
Building B19, University of Sydney, NSW 2006, Australia
Phone: +61 2 9351 3154              Fax: +61 2 93513957