-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathinstallSLDBE11_createDB.yaml
executable file
·76 lines (72 loc) · 2.38 KB
/
installSLDBE11_createDB.yaml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
---
- hosts: oraclelinux
vars:
# GLOBAL
major_version: 11
patch_dir: /u01/install
proxy: http://proxy.svc.sigma.host:8080
opatch_patch: p6880880_112000_Linux-x86-64.zip
u01_size_gb: 20
tmp_size_gb: 1.5
# GRID
grid_base: /u01/app/grid
grid_home: /u01/app/grid/product/11.2.0.4/dbhome_1
grid_zip_part1: grid_112040_Linux-x86-64_3of7.zip
grid_zip_part2: grid_112040_Linux-x86-64_3of7.zip
grid_dgname: 'DG_DATA'
grid_asmdisk: [ { dev: '/dev/sdb1', asm: 'ASM_DATA_01' }, { dev: '/dev/sdc1', asm: 'ASM_DATA_02' } ]
grid_disklist: "" # LAISSER VIDE
grid_asmlib: oracleasmlib-2.0.12-1.el7.x86_64.rpm
grid_asmsupport: oracleasm-support-2.1.8-3.el7.x86_64.rpm
# SI OL7
grid_ol7_psu: p18370031_112040_Linux-x86-64.zip
grid_ol7_psu_number: 18370031
# ASM DG (2nd)
asmdg_disklist: "" # LAISSER VIDE
asmdg_dgname: 'DG_FRA'
asmdg_asmdisk: [ { dev: '/dev/sdd1', asm: 'ASM_FRA_01' }, { dev: '/dev/sde1', asm: 'ASM_FRA_02' } ]
# GRID PSU
grid_psu: grid_112040.170418_Linux-x86-64.zip
grid_psu_number: 25476126
# RDBMS
oracle_root: /u01/app
oracle_base: /u01/app/oracle
oracle_home: /u01/app/oracle/product/11.2.0.4/dbhome_1
rdbms_zip_part1: rdbms_112040_Linux-x86-64_1of7.zip
rdbms_zip_part2: rdbms_112040_Linux-x86-64_2of7.zip
# RDBMS PSU
rdbms_psu: rdbms_11204.170418_Linux-x86-64.zip
rdbms_psu_number: 24732075
# LISTENER
netca_lsnr_name: LISTENER
netca_lsnr_port: 1521
# DATABASE
dbca_gdbname: SIGDMET
dbca_dbname: SIGDMET
dbca_pwdsys: Password1
dbca_pwdsystem: Password1
dbca_charset: WE8ISO8859P15
dbca_ncharset: UTF8
dbca_initparam_sgamax_mb: 512
dbca_initparam_sga_mb: 512
dbca_initparam_pga_mb: 100
dbca_initparam_dbrecoverydest: /u01/app/oracle/fra/
dbca_initparam_dbrecoverydestsize: 1024
#dbca_initparam_oradata: /u01/app/oracle/oradata/
#dbca_initparam_oradata: '+DG_DATA'
dbca_initparam_oradata: 'DG_DATA'
#dbca_initparam_redologdest1: /u01/app/oracle/fra/
#dbca_initparam_redologdest2: /u01/app/oracle/oradata/
dbca_initparam_redologdest1: '+DG_FRA'
dbca_initparam_redologdest2: '+DG_DATA'
roles:
# - updateLinux
# - prereqOracle
# - installGrid
# - installGridPsu
# - createAsmDg
# - installRdbms
# - installRdbmsPsu
# - createListener
- createDatabase
# - cleanInstallDir