[Spacewalk-devel] Automating Oracle-xe Setup
-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 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
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
Re: [Spacewalk-devel] Automating Oracle-xe Setup
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Consider my day made. :) Thanks Michael. Devan On Wed, 18 Feb 2009 17:13:13 +0100 Michael Mraka wrote: > 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 < 9000 > 1521 > spacewalk > spacewalk > y > ORA > > % And the creation of the spacewalk user / permissions? > > su - oracle -c 'sqlplus / as sysdba' < 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 - -- Devan Goodwin Software Engineer Spacewalk / RHN Satellite Halifax, Canada 650.567.9039x79267 -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.9 (GNU/Linux) iEYEARECAAYFAkmcOMAACgkQAyHWaPV9my4fowCfco8xZ34UX+EkJ249aMsh9jMg 0PwAn2jmGyydZwmfFVVMkczSoCBMNTtG =Geab -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
Michael Mraka wrote: 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
Re: [Spacewalk-devel] Automating Oracle-xe Setup
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' <> 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
Re: [Spacewalk-devel] Automating Oracle-xe Setup
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'
Re: [Spacewalk-devel] Automating Oracle-xe Setup
On Tue, Feb 24, 2009 at 11:48:36AM -0800, Mike McCune wrote: su - oracle -c 'sqlplus / as sysdba' <>>> 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
> > 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 agree this shouldn't be the default. Maybe a contrib script in %doc or something. That way if you're just testing SW, you can get running quickly . Most likely if your running in production, you have some customization to perform on database connections and security anyway... > > I've added the "create user spacewalk" SQL to > > https://fedorahosted.org/spacewalk/wiki/OracleXeSetup Awesome. > > 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. I vote remove it. If you have command line utils, GUIs just get in the way. Especially if this can be easily automated. ___ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
Re: [Spacewalk-devel] Automating Oracle-xe Setup
On Tue, Mar 03, 2009 at 08:59:19PM -0600, Michael Stahnke wrote: > > > > I've added the "create user spacewalk" SQL to > > > > https://fedorahosted.org/spacewalk/wiki/OracleXeSetup > > Awesome. > > 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. > > I vote remove it. If you have command line utils, GUIs just get in Done. I've also did other changes to the page, to hopefully make it easier to read. Anything else we could remove from that page? ;-) -- Jan Pazdziora Senior Software Engineer, Satellite Engineering, Red Hat ___ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel