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).
SELinux
No problems in role with active SELinux were encountered. In a case of any issues you should disable SELinux Temporarily or Permanently.
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.
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
Role use next mechanism for identify a swap file size:
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.
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 urilocal
Local artifacttransport_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 userssyspassword
- SYS passwordsystempassword
- SYSTEM passwordsysmanpassword
- SYSMAN passworddbsnmppassword
- DBSNMP passworddb_user_password
- initial user passwordpdbadminpassword
- if a multitenant DB with one or more pluggable DBs is createdDefault 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)
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
Apache
authors: