Santi Saez wrote: > Hi, > > We have reached the limit of maximum disk space for Oracle XE, so we're > going to buy "Oracle Standard" license. > > Anyone can confirm if *Oracle Standard One* license is valid for Spacewalk?
>From technical point of view - yes, any of Standard One, Standard and Enterprise Edition will work. As for Oracle's license - I don't know. > On the other hand, is there a manual/howto explaining how to change the > Oracle server? thanks!! Export spacewalk schema from your XE # su - oracle $ . /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh $ exp spacewalk/spacewalk owner=spacewalk consistent=y statistics=none file=spacewalk.dmp log=spacewalk.log Make sure you new databse is created with UTF8 charset. On new oracle server create spacewalk user: # su - oracle $ . oraenv ORACLE_SID = [11g] ? your_db_sid $ sqlplus '/ as sysdba' SQL> create user spacewalk identified by spacewalk default tablespace users; Grant necessary priviledges: SQL> grant create session to spacewalk; SQL> grant alter session to spacewalk; SQL> grant unlimited tablespace to spacewalk; SQL> grant create table to spacewalk; SQL> grant create synonym to spacewalk; SQL> grant create view to spacewalk; SQL> grant create sequence to spacewalk; SQL> grant create procedure to spacewalk; SQL> grant create trigger to spacewalk; SQL> grant create type to spacewalk; SQL> quit; And import dump: $ export NLS_LANG=english.AL32UTF8 $ imp '/ as sysdba' fromuser=spacewalk touser=spacewalk file=spacewalk.dmp log=spacewalk.imp.log ignore=y Finally put new entry to /etc/tnsnames.ora and change db name in /etc/rhn/* or if you didn't changes db username na password just edit current XE entry in tnsnames.ora to the new host/sid which let's your /etc/rhn/* untouched. > Regards, > > -- > Santi Saez > http://woop.es Regards, -- Michael Mráka Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
