Oracle Database role

Summary

This role installs and configures oracle database (Oracle RDBMS 11g2 & Oracle RDBMS 12c & Oracle 11g2 XE) and all associated software/configurations for this (packages, limits, swap size and etc).

Requirements

• Minimal Version of the ansible for installation: 2.5.

• Prepared ansible inventory file with listed VMs with python. These machines should be accessible via SSH.

• Supported Centos 7.* Oracle 12c

• Supported Centos 6.* Oracle 11g

• Official Oracle 12 database support distribution

• SELinux

  No problems in role with active SELinux were encountered. In a case of any issues you should disable SELinux Temporarily or Permanently.

About Oracle Database Express Edition (XE)

It is a free-to-use entry-level version of Oracle Database available for a number of platforms. It provides a subset of EE functionality (not including features such as managed backup and recovery, high availability and replication), is community-supported and comes with its own license terms. XE imposes the following restrictions : maximum of 1 CPU, 1 GB of RAM and 11 GB of user data for 11g.

About Enterprise Manager Express

According to Oracle, Enterprise Manager Database Control is no longer available in Oracle Database 12c. You can use Enterprise Manager Cloud Control 12c or the EM Express 12c to manage Oracle Database 12c databases.

EM Express is an built-in component and requires no seperate installation or license. Think of it as a light-weight or limited version of Enterprise Manager Cloud Control. It can be accessed via url:

https://hostname:portnumber/em/

Where hostname is the name or IP of the Oracle database server, portnumber is the port EM Express is running on. To get portnumber, run below query:

SQL> SELECT DBMS_XDB_CONFIG.GETHTTPSPORT() FROM DUAL;

Usually, portnumber is 5500.

See more about EM Express in below links:

Getting Started with Oracle Enterprise Manager Express

Introduction to Oracle Enterprise Manager Database Express

Important note!

Role use next mechanism for identify a swap file size:

• If RAM on your server > 10 GB swap file will be = 16 GB.
• If RAM < 10 GB but > 2 GB, so swap file will be = RAM x 1.5 GB.
• When RAM < 2GB your swap file will be 8 GB.

Default place for swap file is root directory / .

If you want change size you swap file, please use variable oracle_db_swap_count in your playbook.

Role Variables

• oracle_version - major number of Oracle Database version
  default: 12

• patch_version - number of Oracle Database version with patch
  default: 12.1.0.2

• transport - artifact source transport. Use web, local for more predictable result
  default: web Available:

  • web Fetching artifact from custom web uri
  • local Local artifact

• transport_web - URI for http/https artifact e.g
  default: http://my-storage.example.com

• transport_local - path for local artifact
  default: /tmp

• oracle_images - list of Oracle Database files
  default*:

  • - linuxamd64_12102_database_1of2.zip
  • - linuxamd64_12102_database_2of2.zip

• oracle_base - oracle base installation directory
  default: /opt/oracledb

• unqname - database unique name
  default: orcl

• sid - instance unique identifier
  default: orcl

• db_user - database user
  default: oracle

• db_tablespace - mandatory tablespace of the data dictionary
  default: oracle

• db_port - database port
  default: 1521

• oracle_db_swap_count - swap file size
  default: role identify a swap file size

• oracle_db_swapfile - path to swap file
  default /oracle-swapfile

• db_startup_timeout - startup timeout for systemd service
  default 300

• For Oracle Universal Installer

  • inventory_directory default /opt/oraInventory
  • ora_inst default/etc/oraInst.loc

• Password for administrative accounts

  All databases include the SYS, SYSTEM, SYSMAN and DBSNMP administrative accounts. To protect these accounts from unauthorized access, their passwords must be changed according Oracle password policy.

  • syspass - password for all database users
  • syspassword - SYS password
  • systempassword - SYSTEM password
  • sysmanpassword - SYSMAN password
  • dbsnmppassword - DBSNMP password
  • db_user_password - initial user password
  • pdbadminpassword - if a multitenant DB with one or more pluggable DBs is created

• Default password for administrative accounts Oracle 11, XE versions

  syspass: SysPassOracle2017SecretToken
  syspassword: SysPassword2017SecretToken
  systempassword: SystemPassword2017SecretToken
  sysmanpassword: SysmanPassword2017SecretToken
  dbsnmppassword: DbSnmpPassword2017SecretToken
  db_user_password: DbPassword2017SecretToken (for created DB schema)

• Default password for administrative accounts Oracle 12 version

  syspass: SysPassOracle2017SecretToken
  syspassword: SysPassword2017SecretToken
  systempassword: SystemPassword2017SecretToken
  dbsnmppassword: DbSnmpPassword2017SecretToken
  pdbadminpassword: PdbAdminPassword2017SecretToken
  db_user_password: DbPassword2017SecretToken (for created DB schema)

Example Playbook

• Installing Oracle 11.2.0.1

  - name: Install oracle db
    hosts: all
  
    roles:
      - role: lean_delivery.oracle_db
        oracle_version: 11
        patch_version: 11.2.0.1
        transport_web: http://my-storage.example.com
        oracle_images:
          - linux.x64_11gR2_database_1of2.zip
          - linux.x64_11gR2_database_2of2.zip

• Installing Oracle 11.2.0.3 from local files

  - name: Install oracle db
    hosts: all
  
    roles:
      - role: lean_delivery.oracle_db
        oracle_version: 11
        patch_version: 11.2.0.3
        transport: local
        transport_local: /tmp
        oracle_images:
          - p10404530_112030_Linux-x86-64_1of7.zip
          - p10404530_112030_Linux-x86-64_2of7.zip
          - p10404530_112030_Linux-x86-64_3of7.zip
          - p10404530_112030_Linux-x86-64_4of7.zip
          - p10404530_112030_Linux-x86-64_5of7.zip
          - p10404530_112030_Linux-x86-64_6of7.zip
          - p10404530_112030_Linux-x86-64_7of7.zip

• Installing Oracle 11.2.0.4 with custom swap file size

  - name: Install oracle db
    hosts: all
  
    roles:
      - role: lean_delivery.oracle_db
        oracle_version: 11
        patch_version: 11.2.0.4
        transport_web: http://my-storage.example.com
        oracle_images:
          - p10404530_112040_Linux-x86-64_1of7.zip
          - p10404530_112040_Linux-x86-64_2of7.zip
          - p10404530_112040_Linux-x86-64_3of7.zip
          - p10404530_112040_Linux-x86-64_4of7.zip
          - p10404530_112040_Linux-x86-64_5of7.zip
          - p10404530_112040_Linux-x86-64_6of7.zip
          - p10404530_112040_Linux-x86-64_7of7.zip
        oracle_db_swapfile: /oracle-swapfile-11
        oracle_db_swap_count: 2048

• Installing Oracle 12.1.0.2

  - name: Install oracle db
    hosts: all
  
    roles:
      - role: lean_delivery.oracle_db
        oracle_version: 12
        patch_version: 12.1.0.2
        transport_web: http://my-storage.example.com
        oracle_images:
          - linuxamd64_12102_database_1of2.zip
          - linuxamd64_12102_database_2of2.zip

• Installing Oracle XE

  - name: Install oracle db
    hosts: all
  
    roles:
      - role: lean_delivery.oracle_db
        oracle_version: xe
        transport_web: http://my-storage.example.com
        oracle_images:
          - linux.x64_11gR2_xe.zip

License

Apache

Author Information

authors:

• Lean Delivery Team [email protected]