[Spacewalk-list] Spacewalk + Oracle SE1

[Michael Mraka]

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