oraswdb_install
Install Oracle Database Software
Table of contents
Requirements
- Minimum Ansible version:
2.16.0
Default Variables
autostartup_service
Force linking of all options from oracle_ee_options and
oracle_all_editions_options_state in ORACLE_HOME.
The current state of an option is read from the libraries in
ORACLE_HOME. Only options not in intended state are linked, all of them
in one make call with a single relink of oracle (ioracle).
true links all options, even when they are already in intended state.
configure_oracle_profile
Create .profile_-environment scripts for databases
in oracle_databases.
Mandatory when listener_installed is defined,
autostartup_service: true and autostartup_service_mode: legacy.
Otherwise the listener will not start!
Default value
configure_oracle_profile: true
glogin_default_cdb
content of glogin.sql for CDB/PDB databases
Default value
glogin_default_cdb:
- define gname=idle
- column global_name new_value gname
- set heading off
- set termout off
- col global_name noprint
- select upper(sys_context ('userenv', 'instance_name') || ':' || sys_context('userenv', 'con_name')) global_name from dual;
- set sqlprompt '_user @ &gname:>'
- set heading on
- set termout on
- set time on
glogin_default_nocdb
Default value
glogin_default_nocdb:
- set sqlprompt "_user @ _connect_identifier:>"
- set time on
hostgroup
Default value
hostgroup: '{{ group_names[0] }}'
hostgroup_hub
Default value
hostgroup_hub: '{{ hostgroup }}-hub'
hostgroup_leaf
Default value
hostgroup_leaf: '{{ hostgroup }}-leaf'
hostinitdaemon
The start daemon of the OS.
Usually no need to change this value!
Default value
hostinitdaemon: '{{ ansible_service_mgr }}'
oracle_ee_options
Default value
oracle_ee_options: "{{ _oracle_ee_opiton_dict[db_homes_config[dbh.home]['version']] }}"
oracle_sw_image_db
Mapping for installation media for Oracle
image files are expected to be found by their filename under oracle_sw_source_local, or oracle_sw_source_www respectively,
unless a filesource dict element provides a full path / complete URL to the patch file.
Formerly, this dict was defined directly as vars/_oraswdb_install_oracle_sw_image_db, where it still will be copied to for compatibility reasons
Default value
oracle_sw_image_db:
- {filename: LINUX.X64_2326100_db_home.zip, version: 26.1.0.0, creates: install/.img.bin}
- {filename: LINUX.X64_213000_db_home.zip, version: 21.3.0.0, creates: install/.img.bin}
- {filename: LINUX.X64_193000_db_home.zip, version: 19.3.0.0, creates: install/.img.bin}
- {filename: LINUX.X64_180000_db_home.zip, version: 18.3.0.0, creates: install/.img.bin}
- {filename: linuxx64_12201_database.zip, version: 12.2.0.1, creates: database/runInstaller}
- {filename: linuxamd64_12102_database_1of2.zip, version: 12.1.0.2, creates: database/stage/sizes/oracle.server.Custom.sizes.properties}
- {filename: linuxamd64_12102_database_2of2.zip, version: 12.1.0.2, creates: database/install/.oui}
- {filename: linuxamd64_12c_database_1of2.zip, version: 12.1.0.1, creates: database/runInstaller}
- {filename: linuxamd64_12c_database_2of2.zip, version: 12.1.0.1, creates: database/runInstaller}
- {filename: p13390677_112040_Linux-x86-64_1of7.zip, version: 11.2.0.4, creates: database/install/resource/cons_zh_TW.nls}
- {filename: p13390677_112040_Linux-x86-64_2of7.zip, version: 11.2.0.4, creates: database/stage/Components/oracle.db/11.2.0.4.0/1/DataFiles/filegroup18.jar}
- {filename: p10404530_112030_Linux-x86-64_1of7.zip, version: 11.2.0.3, creates: database/readme.html}
- filename: p10404530_112030_Linux-x86-64_2of7.zip
version: 11.2.0.3
creates: database/stage/Components/oracle.sysman.console.db/11.2.0.3.0/1/DataFiles/filegroup2.jar
Example usage
oracle_sw_image_db:
- {filename: LINUX.X64_2326100_db_home.zip, version: 26.1.0.0, creates: 'install/.img.bin'}
- {filename: LINUX.X64_213000_db_home.zip, version: 21.3.0.0, creates: 'install/.img.bin'}
- {filename: LINUX.X64_193000_db_home.zip, version: 19.3.0.0, creates: 'install/.img.bin', filesource: /mnt/software/LINUX.X64_193000_db_home.zip}
- {filename: LINUX.X64_180000_db_home.zip, version: 18.3.0.0, creates: 'install/.img.bin', filesource: "https://downloadserver/dbsw?version=18.3.0.0"}
- {filename: linuxx64_12201_database.zip, version: 12.2.0.1, creates: 'database/runInstaller'}
- {filename: linuxamd64_12102_database_1of2.zip, version: 12.1.0.2, creates: 'database/stage/sizes/oracle.server.Custom.sizes.properties'}
- {filename: linuxamd64_12102_database_2of2.zip, version: 12.1.0.2, creates: 'database/install/.oui'}
- {filename: linuxamd64_12c_database_1of2.zip, version: 12.1.0.1, creates: 'database/runInstaller'}
- {filename: linuxamd64_12c_database_2of2.zip, version: 12.1.0.1, creates: 'database/runInstaller'}
- {filename: p13390677_112040_Linux-x86-64_1of7.zip, version: 11.2.0.4, creates: 'database/install/resource/cons_zh_TW.nls'}
- {filename: p13390677_112040_Linux-x86-64_2of7.zip, version: 11.2.0.4, creates: 'database/stage/Components/oracle.db/11.2.0.4.0/1/DataFiles/filegroup18.jar'}
- {filename: p10404530_112030_Linux-x86-64_1of7.zip, version: 11.2.0.3, creates: 'database/readme.html'}
- filename: p10404530_112030_Linux-x86-64_2of7.zip
version: 11.2.0.3
creates: 'database/stage/Components/oracle.sysman.console.db/11.2.0.3.0/1/DataFiles/filegroup2.jar'
oraswdb_install_forcechopt
Default value
oraswdb_install_forcechopt: false
oraswdb_install_remove_install_images
Remove installation media from staging after installation when oracle_sw_copy: true.
Default value
oraswdb_install_remove_install_images: true
Discovered Tags
always
assert
autostartup_service
checkdbswinstall
create_db,dotprofile_db
dbchopt
directoriesdb
existing_dbhome
glogindb
install_home
nfsmountdb
nfsumountdb
opatchls
oradbinstall
oradbinstall,dbchopt
oradbsw
oradbswunpack
orainst
responsefileswdb
roohctl
runroot
seclimit
Open Tasks
- (information): hostgroup, hostgroup_hub, hostgroup_leaf needs some more tests
Dependencies
- orahost_meta
- orasw_meta
License
license (MIT)
Author
[Mikael Sandström]