oradbhosting.com Digital Solutions

Ansibel Oracel DB Automation

ansible-oracle

  • Installs Oracle RAC, RAC One Node and normal single instances.
  • Start with one or more clean machine(s), end up with a fully configured RAC Cluster.

Getting started

Pre-requisites:

  • Ansible >= 2.4
  • Oracle Linux (or any RHEL-based Linux System) >= 6.4
  • Oracle Database/Grid Infrastructure 18.3.0.0, 12.2.0.1, 12.1.0.1, 12.1.0.2, 11.2.0.4, 11.2.0.3
  • For example configurations, look in: 
    SI/FS:   group_vars/vbox-si-fs.  - vagrant config: http://github.com/oravirt/vagrant-vbox-si-fs
SI/ASM:  group_vars/vbox-si-asm  - vagrant config: http://github.com/oravirt/vagrant-vbox-si-asm
RAC/ASM: group_vars/vbox-rac-dc1 - vagrant config: http://github.com/oravirt/vagrant-vbox-rac

By default, installs a single instance 18.3.0.0 database on a filesystem.

  1. Clone this repository:
    git clone --recursive https://github.com/oravirt/ansible-oracle
  2. Add the following file to /tmp on the controlmachine
    • LINUX.X64_180000_db_home.zip
  3. Create an Ansible inventory file 
    [myhostgroup]
 dbhost
  4. Run the playbook:

    ansible-playbook single-instance-db-on-fs.yml -e hostgroup=myhostgroup -i /path/to/inventory

    where the -i part is optional

Roles

A lot of these roles uses Ansible modules that comes from ansible-oracle-modules

common

This will configure stuff common to all machines

  • Install some generic packages
  • Configure ntp

orahost

This will configure the host specific Oracle stuff:

  • Add a user & group
  • Create directory structures
  • Handle filesystem storage (partition devices, creates vg/lv and a filesystem (ext4, xfs, btrfs) etc). If you want to create your database on a filesystem (instead of ASM) this is where you define the layout.
  • Install required packages
  • Change kernel paramemeters
  • Set up pam.d/limits config
  • Configures Hugepages (as a percentage of total RAM)
  • Disables transparent hugepages
  • Disables NUMA (if needed)
  • Configures the interconnect network (if needed)
  • Configures Oracle ASMLib

orahost-ssh

Configures passwordless ssh between clusternodes if setting up RAC (configure_cluster=True)

  • Uses existing ssh-keys

orahost-storage

This role configures storage that shoud be used by ASM.

  • Partitions devices (using parted)
  • Create ASMlib labels or sets up udev-rules for device name persistence

oraswgi-install

This role will install and configure Oracle Grid Infrastructure (RAC/SI)

  • Adds a .profile_grid to the oracle user
  • Sets up directory structures
  • Copies the install-files to the servers, or installs from a remote location (e.g nfs share)
  • Install Oracle Grid Infrastructure

oraasm-manage-diskgroups

This role will statefully manage the lifecycle of an ASM diskgroup

  • Uses the oracle_asmdg module
  • Create/delete diskgroup.
  • Add/remove disks
  • Manage attributes for the DG

oraswdb-install

This role will install the oracle database server(s). It is possible to run more than 1 database from each home. It performs both Single Instance/RAC installations.

  • Creates a .profile with the correct environment
  • Creates directory structures
  • Installs the database-server(s)

oradb-manage-db

This role statefully manages the lifecycle of a database

  • Uses the oracle_db module
  • Creates/deletes: state: present/absent
  • Maintains archivelog/force_logging True/False

oraswgi-manage-patches

Manage patches in a GI environment

  • Uses the oracle_opatch module
  • Manages opatchauto type of patches as well as ’normal‘ one-offs

oraswdb-manage-patches

Statefully manage patches in a DB environment

  • Uses the oracle_opatch module
  • Manages opatchauto type of patches as well as ’normal‘ one-offs

cxoracle

Installs cx_Oracle in preparation for using ansible-oracle-modules

orahost-cron

Configures cron schedules if needed

orahost-logrotate

oradb-manage-<*>

Statefully manages various aspects of the DB. They all use modules from ansible-oracle-modules

  • oradb-manage-pdb
  • oradb-manage-tablespace
  • oradb-manage-parameters
  • oradb-manage-roles
  • oradb-manage-users
  • oradb-manage-grants
  • oradb-manage-redo
  • oradb-manage-services

Deprecated roles

oraasm-createdg (use oraasm-manage-diskgroups instead)

oradb-create (use oradb-manage-db instead)

oradb-delete (use oradb-manage-db instead)

oraswgi-opatch (use oraswgi-manage-patches instead)

Note

These are the Oracle binaries that are pre-configured to be used. They have to be manually downloaded and made available (either locally, from a web endpoint or through a nfs-share)

For 18.3.0.0:

    LINUX.X64_180000_db_home.zip
    LINUX.X64_180000_grid_home.zip

For 12.2.0.1:

    linuxx64_12201_database.zip
    linuxx64_12201_grid_home.zip

For 12.1.0.2

    linuxamd64_12102_database_1of2.zip
    linuxamd64_12102_database_2of2.zip
    linuxamd64_12102_grid_1of2.zip
    linuxamd64_12102_grid_2of2.zip

For 12.1.0.1:

    linuxamd64_12c_database_1of2.zip
    linuxamd64_12c_database_2of2.zip
    linuxamd64_12c_grid_1of2.zip
    linuxamd64_12c_grid_2of2.zip

For 11.2.0.4:

    p13390677_112040_Linux-x86-64_1of7.zip
    p13390677_112040_Linux-x86-64_2of7.zip
    p13390677_112040_Linux-x86-64_3of7.zip

For 11.2.0.3:

    p10404530_112030_Linux-x86-64_1of7.zip
    p10404530_112030_Linux-x86-64_2of7.zip
    p10404530_112030_Linux-x86-64_3of7.zip

Manuel

, ,