Re: [Spacewalk-devel] Automating Oracle-xe Setup

2009-02-24 Thread Mike McCune 

Jan Pazdziora wrote:

On Wed, Feb 18, 2009 at 11:30:30AM -0800, Mike McCune wrote:

% And the creation of the spacewalk user / permissions?

su - oracle -c 'sqlplus / as sysdba' EOS
create user spacewalk identified by spacewalk default tablespace users;
grant dba to spacewalk;
alter system set processes = 400 scope=spfile;
alter system set _optimizer_filter_pred_pullup=false scope=spfile;  
alter system set _optimizer_cost_based_transformation=off 
scope=spfile; EOS

we should consider adding the user creation steps to spacewalk-setup


Do you mean spacewalk-setup the package, or spacewalk-setup the file
in /usr/bin?



The file in /usr/bin :)

Mike
--
Mike McCune
mmccune AT redhat.com
Engineering   | Portland, OR
RHN Satellite | 650.567.9039x79248

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] Automating Oracle-xe Setup

2009-02-24 Thread Jan Pazdziora 
On Tue, Feb 24, 2009 at 11:48:36AM -0800, Mike McCune wrote:

 su - oracle -c 'sqlplus / as sysdba' EOS
 create user spacewalk identified by spacewalk default tablespace users;
 grant dba to spacewalk;
 alter system set processes = 400 scope=spfile;
 alter system set _optimizer_filter_pred_pullup=false 
 scope=spfile;  alter system set 
 _optimizer_cost_based_transformation=off scope=spfile; EOS
 we should consider adding the user creation steps to spacewalk-setup

 Do you mean spacewalk-setup the package, or spacewalk-setup the file
 in /usr/bin?

 The file in /usr/bin :)

That's what I feared.

Ideally, spacewalk-setup (the file, and the Spacewalk/Setup.pm) should
how have anything embedded database or XE specific. That
spacewalk-setup should receive connect string to use, and that connect
string should point to a working, setup database user account.

We could do something like oracle-xe-utils or spacewalk-oracle-xe
(package) to hold any helper scripts. But we should aim at removing
even the last embedded db bits away from spacewalk-setup, not add new
ones.

I've added the create user spacewalk SQL to

https://fedorahosted.org/spacewalk/wiki/OracleXeSetup

and I'm actually considering removing the part about
http://127.0.0.1:9000/apex from that page, so the list of steps that
you need to do on Oracle XE prior to running spacewalk-setup should
get pretty short.

-- 
Jan Pazdziora
Satellite Engineering, Red Hat

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] Automating Oracle-xe Setup

2009-02-19 Thread Jan Pazdziora 
On Wed, Feb 18, 2009 at 11:30:30AM -0800, Mike McCune wrote:

 % And the creation of the spacewalk user / permissions?

 su - oracle -c 'sqlplus / as sysdba' EOS
 create user spacewalk identified by spacewalk default tablespace users;
 grant dba to spacewalk;
 alter system set processes = 400 scope=spfile;
 alter system set _optimizer_filter_pred_pullup=false scope=spfile;  
 alter system set _optimizer_cost_based_transformation=off 
 scope=spfile; EOS

 we should consider adding the user creation steps to spacewalk-setup

Do you mean spacewalk-setup the package, or spacewalk-setup the file
in /usr/bin?

-- 
Jan Pazdziora
Satellite Engineering, Red Hat

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

[Spacewalk-devel] Automating Oracle-xe Setup

2009-02-18 Thread Devan Goodwin 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Has anyone figured out a way to automate the steps in the install guide
for:

/etc/init.d/oracle-xe configure

And the creation of the spacewalk user / permissions?

Have a cobbler setup here to create guests for testing but it'd save me
a lot of hassle if I could script these and have the box nearly ready
to go with spacewalk after kickstart.

Cheers,

Devan

- -- 
  Devan Goodwin dgood...@redhat.com
  Software Engineer Spacewalk / RHN Satellite
  Halifax, Canada   650.567.9039x79267
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.9 (GNU/Linux)

iEYEARECAAYFAkmcMoUACgkQAyHWaPV9my5ZBQCg7b7NYv0aWSSXjGR54Gu/qc7O
NgMAn3kC4I2gQKBamRv8aRzucZjAUtPA
=xtla
-END PGP SIGNATURE-

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Re: [Spacewalk-devel] Automating Oracle-xe Setup

2009-02-18 Thread Michael Mraka 
Devan Goodwin wrote:
% -BEGIN PGP SIGNED MESSAGE-
% Hash: SHA1
% 
% Has anyone figured out a way to automate the steps in the install guide
% for:
% 
% /etc/init.d/oracle-xe configure

/etc/init.d/oracle-xe configure ORA
9000
1521
spacewalk
spacewalk
y
ORA

% And the creation of the spacewalk user / permissions?

su - oracle -c 'sqlplus / as sysdba' EOS
create user spacewalk identified by spacewalk default tablespace users;
grant dba to spacewalk;
alter system set processes = 400 scope=spfile;
alter system set _optimizer_filter_pred_pullup=false scope=spfile; 
alter system set _optimizer_cost_based_transformation=off scope=spfile; 
EOS

% Have a cobbler setup here to create guests for testing but it'd save me
% a lot of hassle if I could script these and have the box nearly ready
% to go with spacewalk after kickstart.
% 
% Cheers,
% 
% Devan

--
Michael Mráka
Satellite Engineering, Red Hat

___
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel