I have some sample code for oracle install that may be of use.
One of the main tasks was that I used fpm to create a rpm file of existing
oracle install.
I did handle the oratab but only to create a fact of known databases on
that system.
Corey
Give me about 24 hours to post my work.
···
On Oct 25, 2012 6:55 AM, "Gavin Williams" wrote:
Morning all
I’ve asked a similar question on the Puppet Users group, but thought it
might be good to get a view on how Foreman could be used to achieve the
following.
We’re looking to use Puppet to manage out Oracle DB server and relevant DB
instance configuration.
I’ve got an idea on how to handle the install of Oracle and the relevant
req fulfilment.
However what I’m not sure of is how to manage the instance specific
configuration. This includes things like the /etc/oratab file,
/etc/oranfstab (as we’re using dNFS), various NFS mounts that make up a
given database, and a few other bits and pieces…
We’re also likely to be needing to support multiple databases instances on
a given host.
My initial thoughts are to use Hiera or similar to manage the multiple
configuration instances. However could Foreman go in Hiera’s place?
Foreman would also be a bit easier for the DBA’s to get used to, versus
the flat files for hiera config.
Thoughts or suggestions welcome.
And thanks in advance for any responses.
Regards
Gavin
–
You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/foreman-users/-/hEdeBus7AfwJ.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.
Corey
Cool, that would be useful…
Cheers
Gavin
···
On Thursday, 25 October 2012 14:41:01 UTC+1, Corey Osman wrote:
>
> I have some sample code for oracle install that may be of use.
>
> One of the main tasks was that I used fpm to create a rpm file of existing
> oracle install.
>
> I did handle the oratab but only to create a fact of known databases on
> that system.
>
> Corey
>
> Give me about 24 hours to post my work.
> On Oct 25, 2012 6:55 AM, "Gavin Williams" <fatm...@gmail.com > > wrote:
>
>> Morning all
>>
>> I've asked a similar question on the Puppet Users group, but thought it
>> might be good to get a view on how Foreman could be used to achieve the
>> following.
>>
>> We're looking to use Puppet to manage out Oracle DB server and relevant
>> DB instance configuration.
>> I've got an idea on how to handle the install of Oracle and the relevant
>> req fulfilment.
>>
>> However what I'm not sure of is how to manage the instance specific
>> configuration. This includes things like the /etc/oratab file,
>> /etc/oranfstab (as we're using dNFS), various NFS mounts that make up a
>> given database, and a few other bits and pieces...
>> We're also likely to be needing to support multiple databases instances
>> on a given host.
>>
>> My initial thoughts are to use Hiera or similar to manage the multiple
>> configuration instances. However could Foreman go in Hiera's place?
>>
>> Foreman would also be a bit easier for the DBA's to get used to, versus
>> the flat files for hiera config.
>>
>> Thoughts or suggestions welcome.
>> And thanks in advance for any responses.
>>
>> Regards
>> Gavin
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Foreman users" group.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msg/foreman-users/-/hEdeBus7AfwJ.
>> To post to this group, send email to forema...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to
>> foreman-user...@googlegroups.com .
>> For more options, visit this group at
>> http://groups.google.com/group/foreman-users?hl=en.
>>
>
> I have some sample code for oracle install that may be of use.
>
> One of the main tasks was that I used fpm to create a rpm file of existing
> oracle install.
>
> I did handle the oratab but only to create a fact of known databases on
> that system.
>
> afair, oracle actually has an rpm with all the deps on basic scripts to
get you going quickly
Ohad
···
On Thu, Oct 25, 2012 at 3:40 PM, Corey Osman wrote:
Corey
Give me about 24 hours to post my work.
On Oct 25, 2012 6:55 AM, “Gavin Williams” fatmcgav@gmail.com wrote:
Morning all
I’ve asked a similar question on the Puppet Users group, but thought it
might be good to get a view on how Foreman could be used to achieve the
following.
We’re looking to use Puppet to manage out Oracle DB server and relevant
DB instance configuration.
I’ve got an idea on how to handle the install of Oracle and the relevant
req fulfilment.
However what I’m not sure of is how to manage the instance specific
configuration. This includes things like the /etc/oratab file,
/etc/oranfstab (as we’re using dNFS), various NFS mounts that make up a
given database, and a few other bits and pieces…
We’re also likely to be needing to support multiple databases instances
on a given host.
My initial thoughts are to use Hiera or similar to manage the multiple
configuration instances. However could Foreman go in Hiera’s place?
Foreman would also be a bit easier for the DBA’s to get used to, versus
the flat files for hiera config.
Thoughts or suggestions welcome.
And thanks in advance for any responses.
Regards
Gavin
–
You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/foreman-users/-/hEdeBus7AfwJ.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.
–
You received this message because you are subscribed to the Google Groups
"Foreman users" group.
To post to this group, send email to foreman-users@googlegroups.com.
To unsubscribe from this group, send email to
foreman-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/foreman-users?hl=en.
Ohad
Yep, there's a RPM in the OEL 6 yum repos called
'oracle-rdbms-server-11gR2-preinstall', which as you suggest handles all
the package dependencies, plus user creation, sysctl setup etc… However
we've got a few more settings that need to be tweaked following that that
are NetApp env specific…
As I see it, the install of Oracle is the easy bit - What's going to be
challenging is creating actual DB instances, along with all the NFS stuff,
ora*tab stuff, etc…
Cheers
Gavin
···
On Thursday, 25 October 2012 14:41:54 UTC+1, ohad wrote:
>
>
>
> On Thu, Oct 25, 2012 at 3:40 PM, Corey Osman <co...@logicminds.biz > > wrote:
>
>> I have some sample code for oracle install that may be of use.
>>
>> One of the main tasks was that I used fpm to create a rpm file of
>> existing oracle install.
>>
>> I did handle the oratab but only to create a fact of known databases on
>> that system.
>>
>> afair, oracle actually has an rpm with all the deps on basic scripts to
> get you going quickly
>
> Ohad
>
>> Corey
>>
>> Give me about 24 hours to post my work.
>> On Oct 25, 2012 6:55 AM, "Gavin Williams" <fatm...@gmail.com> >> wrote:
>>
>>> Morning all
>>>
>>> I've asked a similar question on the Puppet Users group, but thought it
>>> might be good to get a view on how Foreman could be used to achieve the
>>> following.
>>>
>>> We're looking to use Puppet to manage out Oracle DB server and relevant
>>> DB instance configuration.
>>> I've got an idea on how to handle the install of Oracle and the relevant
>>> req fulfilment.
>>>
>>> However what I'm not sure of is how to manage the instance specific
>>> configuration. This includes things like the /etc/oratab file,
>>> /etc/oranfstab (as we're using dNFS), various NFS mounts that make up a
>>> given database, and a few other bits and pieces...
>>> We're also likely to be needing to support multiple databases instances
>>> on a given host.
>>>
>>> My initial thoughts are to use Hiera or similar to manage the multiple
>>> configuration instances. However could Foreman go in Hiera's place?
>>>
>>> Foreman would also be a bit easier for the DBA's to get used to, versus
>>> the flat files for hiera config.
>>>
>>> Thoughts or suggestions welcome.
>>> And thanks in advance for any responses.
>>>
>>> Regards
>>> Gavin
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Foreman users" group.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msg/foreman-users/-/hEdeBus7AfwJ.
>>> To post to this group, send email to forema...@googlegroups.com
>>> .
>>> To unsubscribe from this group, send email to
>>> foreman-user...@googlegroups.com .
>>> For more options, visit this group at
>>> http://groups.google.com/group/foreman-users?hl=en.
>>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Foreman users" group.
>> To post to this group, send email to forema...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to
>> foreman-user...@googlegroups.com .
>> For more options, visit this group at
>> http://groups.google.com/group/foreman-users?hl=en.
>>
>
>