Install Oracle BY Ansible
源码分享在了Gitee.com，地址：
https://gitee.com/leviathan-litan/ansible-oracle-database
过程如下：
|
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 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 |
Connecting to 192.168.0.111:2011... Connection established. To escape to local shell, press 'Ctrl+Alt+]'. WARNING! The remote SSH server rejected X11 forwarding request. Last login: Mon Sep 6 23:35:28 2021 from 192.168.0.104 [root@oracle1 ~]# [root@oracle1 ~]# yum install -y centos-release-ansible-29 Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered with an entitlement server. You can use subscription-manager to register. base | 3.6 kB 00:00:00 extras | 2.9 kB 00:00:00 updates | 2.9 kB 00:00:00 base/x86_64/primary_db | 6.1 MB 00:00:01 Resolving Dependencies --> Running transaction check ---> Package centos-release-ansible-29.noarch 0:1-1.el7 will be installed --> Processing Dependency: centos-release-configmanagement for package: centos-release-ansible-29-1-1.el7.noarch --> Running transaction check ---> Package centos-release-configmanagement.noarch 0:1-1.el7.centos will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================= Package Arch Version Repository Size ============================================================================================================================================================================= Installing: centos-release-ansible-29 noarch 1-1.el7 extras 3.9 k Installing for dependencies: centos-release-configmanagement noarch 1-1.el7.centos extras 4.3 k Transaction Summary ============================================================================================================================================================================= Install 1 Package (+1 Dependent package) Total download size: 8.2 k Installed size: 2.2 k Downloading packages: warning: /var/cache/yum/x86_64/7Server/extras/packages/centos-release-ansible-29-1-1.el7.noarch.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY Public key for centos-release-ansible-29-1-1.el7.noarch.rpm is not installed (1/2): centos-release-ansible-29-1-1.el7.noarch.rpm | 3.9 kB 00:00:00 (2/2): centos-release-configmanagement-1-1.el7.centos.noarch.rpm | 4.3 kB 00:00:00 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 30 kB/s | 8.2 kB 00:00:00 Retrieving key from http://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-7 Importing GPG key 0xF4A80EB5: Userid : "CentOS-7 Key (CentOS 7 Official Signing Key) <security@centos.org>" Fingerprint: 6341 ab27 53d7 8a78 a7c2 7bb1 24c6 a8a7 f4a8 0eb5 From : http://mirrors.aliyun.com/centos/RPM-GPG-KEY-CentOS-7 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : centos-release-configmanagement-1-1.el7.centos.noarch 1/2 Installing : centos-release-ansible-29-1-1.el7.noarch 2/2 Verifying : centos-release-ansible-29-1-1.el7.noarch 1/2 Verifying : centos-release-configmanagement-1-1.el7.centos.noarch 2/2 Installed: centos-release-ansible-29.noarch 0:1-1.el7 Dependency Installed: centos-release-configmanagement.noarch 0:1-1.el7.centos Complete! [root@oracle1 ~]# [root@oracle1 ~]# sed -i 's/\$releasever/7/g' /etc/yum.repos.d/* [root@oracle1 ~]# [root@oracle1 ~]# yum makecache Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered with an entitlement server. You can use subscription-manager to register. base | 3.6 kB 00:00:00 centos-ansible-29 | 3.0 kB 00:00:00 extras | 2.9 kB 00:00:00 updates | 2.9 kB 00:00:00 (1/9): centos-ansible-29/x86_64/other_db | 7.0 kB 00:00:00 (2/9): centos-ansible-29/x86_64/filelists_db | 1.2 MB 00:00:01 (3/9): extras/x86_64/other_db | 145 kB 00:00:00 (4/9): base/x86_64/filelists_db | 7.2 MB 00:00:01 (5/9): updates/x86_64/other_db | 765 kB 00:00:00 (6/9): centos-ansible-29/x86_64/primary_db | 29 kB 00:00:02 (7/9): extras/x86_64/filelists_db | 259 kB 00:00:02 (8/9): base/x86_64/other_db | 2.6 MB 00:00:02 (9/9): updates/x86_64/filelists_db | 6.2 MB 00:00:02 Metadata Cache Created [root@oracle1 ~]# [root@oracle1 ~]# yum install -y ansible Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered with an entitlement server. You can use subscription-manager to register. Resolving Dependencies --> Running transaction check ---> Package ansible.noarch 0:2.9.23-1.el7 will be installed --> Processing Dependency: python-jinja2 for package: ansible-2.9.23-1.el7.noarch --> Processing Dependency: python-paramiko for package: ansible-2.9.23-1.el7.noarch --> Processing Dependency: python2-cryptography for package: ansible-2.9.23-1.el7.noarch --> Processing Dependency: sshpass for package: ansible-2.9.23-1.el7.noarch --> Running transaction check ---> Package python-jinja2.noarch 0:2.7.2-4.el7 will be installed --> Processing Dependency: python-babel >= 0.8 for package: python-jinja2-2.7.2-4.el7.noarch --> Processing Dependency: python-markupsafe for package: python-jinja2-2.7.2-4.el7.noarch ---> Package python-paramiko.noarch 0:2.1.1-9.el7 will be installed --> Processing Dependency: python2-pyasn1 for package: python-paramiko-2.1.1-9.el7.noarch ---> Package python2-cryptography.x86_64 0:1.7.2-2.el7 will be installed --> Processing Dependency: python-idna >= 2.0 for package: python2-cryptography-1.7.2-2.el7.x86_64 --> Processing Dependency: python-cffi >= 1.4.1 for package: python2-cryptography-1.7.2-2.el7.x86_64 --> Processing Dependency: python-enum34 for package: python2-cryptography-1.7.2-2.el7.x86_64 ---> Package sshpass.x86_64 0:1.06-2.el7 will be installed --> Running transaction check ---> Package python-babel.noarch 0:0.9.6-8.el7 will be installed ---> Package python-cffi.x86_64 0:1.6.0-5.el7 will be installed --> Processing Dependency: python-pycparser for package: python-cffi-1.6.0-5.el7.x86_64 ---> Package python-enum34.noarch 0:1.0.4-1.el7 will be installed ---> Package python-idna.noarch 0:2.4-1.el7 will be installed ---> Package python-markupsafe.x86_64 0:0.11-10.el7 will be installed ---> Package python2-pyasn1.noarch 0:0.1.9-7.el7 will be installed --> Running transaction check ---> Package python-pycparser.noarch 0:2.14-1.el7 will be installed --> Processing Dependency: python-ply for package: python-pycparser-2.14-1.el7.noarch --> Running transaction check ---> Package python-ply.noarch 0:3.4-11.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================= Package Arch Version Repository Size ============================================================================================================================================================================= Installing: ansible noarch 2.9.23-1.el7 centos-ansible-29 17 M Installing for dependencies: python-babel noarch 0.9.6-8.el7 base 1.4 M python-cffi x86_64 1.6.0-5.el7 base 218 k python-enum34 noarch 1.0.4-1.el7 base 52 k python-idna noarch 2.4-1.el7 base 94 k python-jinja2 noarch 2.7.2-4.el7 base 519 k python-markupsafe x86_64 0.11-10.el7 base 25 k python-paramiko noarch 2.1.1-9.el7 base 269 k python-ply noarch 3.4-11.el7 base 123 k python-pycparser noarch 2.14-1.el7 base 104 k python2-cryptography x86_64 1.7.2-2.el7 base 502 k python2-pyasn1 noarch 0.1.9-7.el7 base 100 k sshpass x86_64 1.06-2.el7 extras 21 k Transaction Summary ============================================================================================================================================================================= Install 1 Package (+12 Dependent packages) Total download size: 20 M Installed size: 119 M Downloading packages: warning: /var/cache/yum/x86_64/7Server/centos-ansible-29/packages/ansible-2.9.23-1.el7.noarch.rpm: Header V4 RSA/SHA256 Signature, key ID 6e8b7e8a: NOKEY15 MB 00:00:00 ETA Public key for ansible-2.9.23-1.el7.noarch.rpm is not installed (1/13): ansible-2.9.23-1.el7.noarch.rpm | 17 MB 00:00:02 (2/13): python-babel-0.9.6-8.el7.noarch.rpm | 1.4 MB 00:00:03 (3/13): python-enum34-1.0.4-1.el7.noarch.rpm | 52 kB 00:00:00 (4/13): python-idna-2.4-1.el7.noarch.rpm | 94 kB 00:00:00 (5/13): python-jinja2-2.7.2-4.el7.noarch.rpm | 519 kB 00:00:00 (6/13): python-markupsafe-0.11-10.el7.x86_64.rpm | 25 kB 00:00:00 (7/13): python-paramiko-2.1.1-9.el7.noarch.rpm | 269 kB 00:00:00 (8/13): python-ply-3.4-11.el7.noarch.rpm | 123 kB 00:00:00 (9/13): python-pycparser-2.14-1.el7.noarch.rpm | 104 kB 00:00:00 (10/13): python2-cryptography-1.7.2-2.el7.x86_64.rpm | 502 kB 00:00:00 (11/13): python2-pyasn1-0.1.9-7.el7.noarch.rpm | 100 kB 00:00:00 (12/13): sshpass-1.06-2.el7.x86_64.rpm | 21 kB 00:00:00 (13/13): python-cffi-1.6.0-5.el7.x86_64.rpm | 218 kB 00:00:05 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 3.4 MB/s | 20 MB 00:00:05 Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-ConfigManagement Importing GPG key 0x6E8B7E8A: Userid : "CentOS Config Management SIG (https://wiki.centos.org/SpecialInterestGroup/ConfigManagementSIG) <security@centos.org>" Fingerprint: c75a fb57 d5c0 f238 cb15 bec8 1ae1 10fa 6e8b 7e8a Package : centos-release-configmanagement-1-1.el7.centos.noarch (@extras) From : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-SIG-ConfigManagement Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : python2-pyasn1-0.1.9-7.el7.noarch 1/13 Installing : python-enum34-1.0.4-1.el7.noarch 2/13 Installing : sshpass-1.06-2.el7.x86_64 3/13 Installing : python-babel-0.9.6-8.el7.noarch 4/13 Installing : python-ply-3.4-11.el7.noarch 5/13 Installing : python-pycparser-2.14-1.el7.noarch 6/13 Installing : python-cffi-1.6.0-5.el7.x86_64 7/13 Installing : python-markupsafe-0.11-10.el7.x86_64 8/13 Installing : python-jinja2-2.7.2-4.el7.noarch 9/13 Installing : python-idna-2.4-1.el7.noarch 10/13 Installing : python2-cryptography-1.7.2-2.el7.x86_64 11/13 Installing : python-paramiko-2.1.1-9.el7.noarch 12/13 Installing : ansible-2.9.23-1.el7.noarch 13/13 Verifying : python-idna-2.4-1.el7.noarch 1/13 Verifying : python-markupsafe-0.11-10.el7.x86_64 2/13 Verifying : python-ply-3.4-11.el7.noarch 3/13 Verifying : python-paramiko-2.1.1-9.el7.noarch 4/13 Verifying : python-babel-0.9.6-8.el7.noarch 5/13 Verifying : python-cffi-1.6.0-5.el7.x86_64 6/13 Verifying : ansible-2.9.23-1.el7.noarch 7/13 Verifying : sshpass-1.06-2.el7.x86_64 8/13 Verifying : python-jinja2-2.7.2-4.el7.noarch 9/13 Verifying : python2-pyasn1-0.1.9-7.el7.noarch 10/13 Verifying : python-enum34-1.0.4-1.el7.noarch 11/13 Verifying : python-pycparser-2.14-1.el7.noarch 12/13 Verifying : python2-cryptography-1.7.2-2.el7.x86_64 13/13 Installed: ansible.noarch 0:2.9.23-1.el7 Dependency Installed: python-babel.noarch 0:0.9.6-8.el7 python-cffi.x86_64 0:1.6.0-5.el7 python-enum34.noarch 0:1.0.4-1.el7 python-idna.noarch 0:2.4-1.el7 python-jinja2.noarch 0:2.7.2-4.el7 python-markupsafe.x86_64 0:0.11-10.el7 python-paramiko.noarch 0:2.1.1-9.el7 python-ply.noarch 0:3.4-11.el7 python-pycparser.noarch 0:2.14-1.el7 python2-cryptography.x86_64 0:1.7.2-2.el7 python2-pyasn1.noarch 0:0.1.9-7.el7 sshpass.x86_64 0:1.06-2.el7 Complete! [root@oracle1 ~]# [root@oracle1 ~]# ansible --version ansible 2.9.23 config file = /etc/ansible/ansible.cfg configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules'] ansible python module location = /usr/lib/python2.7/site-packages/ansible executable location = /usr/bin/ansible python version = 2.7.5 (default, Sep 12 2018, 05:31:16) [GCC 4.8.5 20150623 (Red Hat 4.8.5-36)] [root@oracle1 ~]# [root@oracle1 ~]# cat /etc/ansible/ansible.cfg | grep host_key_checking #host_key_checking = False [root@oracle1 ~]# [root@oracle1 ~]# sed -i '/host_key_checking/s/^#host_key_checking/host_key_checking/g' /etc/ansible/ansible.cfg [root@oracle1 ~]# [root@oracle1 ~]# cat /etc/ansible/ansible.cfg | grep host_key_checking host_key_checking = False [root@oracle1 ~]# [root@oracle1 ~]# mkdir /code/ansible [root@oracle1 ~]# cd /code/ansible/ [root@oracle1 ansible]# ls -ltr total 0 [root@oracle1 ansible]# [root@oracle1 ansible]# ls -ltr total 2487224 -rw-r--r-- 1 root root 2546916302 Sep 6 23:48 ansible-oracle-database.zip [root@oracle1 ansible]# [root@oracle1 ansible]# du -sh * 2.4G ansible-oracle-database.zip [root@oracle1 ansible]# [root@oracle1 ansible]# unzip ansible-oracle-database.zip Archive: ansible-oracle-database.zip creating: ansible-oracle-database/inventory/ creating: ansible-oracle-database/inventory/group_vars/ inflating: ansible-oracle-database/inventory/group_vars/all extracting: ansible-oracle-database/inventory/hosts creating: ansible-oracle-database/playbooks/ inflating: ansible-oracle-database/playbooks/deploy_oracle_database.yml creating: ansible-oracle-database/playbooks/roles/ creating: ansible-oracle-database/playbooks/roles/linux/ creating: ansible-oracle-database/playbooks/roles/linux/defaults/ inflating: ansible-oracle-database/playbooks/roles/linux/defaults/main.yml creating: ansible-oracle-database/playbooks/roles/linux/files/ creating: ansible-oracle-database/playbooks/roles/linux/files/shell_script/ inflating: ansible-oracle-database/playbooks/roles/linux/files/shell_script/file_modify_etc_hosts.sh creating: ansible-oracle-database/playbooks/roles/linux/files/yum/ inflating: ansible-oracle-database/playbooks/roles/linux/files/yum/CentOS-Base.repo inflating: ansible-oracle-database/playbooks/roles/linux/files/yum/CentOS-SIG-ansible-29.repo creating: ansible-oracle-database/playbooks/roles/linux/handlers/ creating: ansible-oracle-database/playbooks/roles/linux/meta/ creating: ansible-oracle-database/playbooks/roles/linux/tasks/ inflating: ansible-oracle-database/playbooks/roles/linux/tasks/linux_directory.yml inflating: ansible-oracle-database/playbooks/roles/linux/tasks/linux_hosts.yml inflating: ansible-oracle-database/playbooks/roles/linux/tasks/linux_secure.yml inflating: ansible-oracle-database/playbooks/roles/linux/tasks/linux_turning.yml inflating: ansible-oracle-database/playbooks/roles/linux/tasks/linux_user_group.yml inflating: ansible-oracle-database/playbooks/roles/linux/tasks/linux_yum.yml inflating: ansible-oracle-database/playbooks/roles/linux/tasks/main.yml creating: ansible-oracle-database/playbooks/roles/linux/templates/ creating: ansible-oracle-database/playbooks/roles/linux/vars/ inflating: ansible-oracle-database/playbooks/roles/linux/vars/main.yml creating: ansible-oracle-database/playbooks/roles/oracle/ creating: ansible-oracle-database/playbooks/roles/oracle/defaults/ inflating: ansible-oracle-database/playbooks/roles/oracle/defaults/main.yml creating: ansible-oracle-database/playbooks/roles/oracle/files/ creating: ansible-oracle-database/playbooks/roles/oracle/files/install_media/ extracting: ansible-oracle-database/playbooks/roles/oracle/files/install_media/p13390677_112040_Linux-x86-64_1of7.zip extracting: ansible-oracle-database/playbooks/roles/oracle/files/install_media/p13390677_112040_Linux-x86-64_2of7.zip creating: ansible-oracle-database/playbooks/roles/oracle/tasks/ inflating: ansible-oracle-database/playbooks/roles/oracle/tasks/main.yml inflating: ansible-oracle-database/playbooks/roles/oracle/tasks/oracle_database_install.yml inflating: ansible-oracle-database/playbooks/roles/oracle/tasks/oracle_os_user_group.yml creating: ansible-oracle-database/playbooks/roles/oracle/templates/ inflating: ansible-oracle-database/playbooks/roles/oracle/templates/db_install.rsp.j2 inflating: ansible-oracle-database/playbooks/roles/oracle/templates/dbca.rsp.j2 inflating: ansible-oracle-database/playbooks/roles/oracle/templates/netca.rsp inflating: ansible-oracle-database/playbooks/roles/oracle/templates/os_user_oracle.bash_profile.j2 creating: ansible-oracle-database/playbooks/roles/oracle/vars/ inflating: ansible-oracle-database/playbooks/roles/oracle/vars/main.yml [root@oracle1 ansible]# [root@oracle1 ansible]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda3 18G 6.7G 12G 38% / devtmpfs 1.9G 0 1.9G 0% /dev tmpfs 1.9G 0 1.9G 0% /dev/shm tmpfs 1.9G 12M 1.9G 1% /run tmpfs 1.9G 0 1.9G 0% /sys/fs/cgroup /dev/sda1 297M 127M 171M 43% /boot tmpfs 378M 0 378M 0% /run/user/0 [root@oracle1 ansible]# [root@oracle1 ansible]# ansible -i ansible-oracle-database/inventory/hosts all -m ping localhost | SUCCESS => { "ansible_facts": { "discovered_interpreter_python": "/usr/bin/python" }, "changed": false, "ping": "pong" } [root@oracle1 ansible]# [root@oracle1 ansible]# time ansible-playbook -i ansible-oracle-database/inventory/hosts ansible-oracle-database/playbooks/deploy_oracle_database.yml PLAY [Linux] **************************************************************************************************************************************************************** TASK [Gathering Facts] ****************************************************************************************************************************************************** ok: [localhost] TASK [linux : Linux Group - Create] ***************************************************************************************************************************************** changed: [localhost] => (item={u'group_id': 4000, u'group_name': u'oinstall'}) changed: [localhost] => (item={u'group_id': 4001, u'group_name': u'dba'}) changed: [localhost] => (item={u'group_id': 4002, u'group_name': u'grid'}) changed: [localhost] => (item={u'group_id': 4003, u'group_name': u'asmdba'}) changed: [localhost] => (item={u'group_id': 4004, u'group_name': u'asmadmin'}) TASK [linux : Linux User - Create] ****************************************************************************************************************************************** changed: [localhost] => (item={u'username': u'oracle', u'comment': u'Oracle Database', u'shell': u'/bin/bash', u'group': u'oinstall', u'uid': 3000, u'groups': [u'dba', u'grid', u'asmdba', u'asmadmin'], u'password': u'oracle', u'dir_home': u'/home/oracle'}) TASK [linux : Linux User - Change Password] ********************************************************************************************************************************* changed: [localhost] => (item={u'username': u'oracle', u'comment': u'Oracle Database', u'shell': u'/bin/bash', u'group': u'oinstall', u'uid': 3000, u'groups': [u'dba', u'grid', u'asmdba', u'asmadmin'], u'password': u'oracle', u'dir_home': u'/home/oracle'}) TASK [linux : Directory - Create] ******************************************************************************************************************************************* changed: [localhost] => (item={u'owner': u'root', u'path': u'/upload', u'group': u'root', u'mode': u'0755'}) changed: [localhost] => (item={u'owner': u'root', u'path': u'/software', u'group': u'root', u'mode': u'0755'}) changed: [localhost] => (item={u'owner': u'root', u'path': u'/backup', u'group': u'root', u'mode': u'0755'}) changed: [localhost] => (item={u'owner': u'root', u'path': u'/script', u'group': u'root', u'mode': u'0755'}) changed: [localhost] => (item={u'owner': u'root', u'path': u'/iso', u'group': u'root', u'mode': u'0755'}) changed: [localhost] => (item={u'owner': u'root', u'path': u'/data', u'group': u'root', u'mode': u'0755'}) changed: [localhost] => (item={u'owner': u'oracle', u'path': u'/u01/app/oracle', u'group': u'oinstall', u'mode': u'0755'}) changed: [localhost] => (item={u'owner': u'oracle', u'path': u'/u01/app/oracle/product/11.2.0/dbhome_1', u'group': u'oinstall', u'mode': u'0755'}) changed: [localhost] => (item={u'owner': u'oracle', u'path': u'/u01/app/oracle/common/oracle/sql', u'group': u'oinstall', u'mode': u'0755'}) changed: [localhost] => (item={u'owner': u'oracle', u'path': u'/data/oracle/oradata', u'group': u'oinstall', u'mode': u'0755'}) changed: [localhost] => (item={u'owner': u'oracle', u'path': u'/data/oracle/oraInventory', u'group': u'oinstall', u'mode': u'0755'}) changed: [localhost] => (item={u'owner': u'oracle', u'path': u'/data/oracle/fast_recovery_area', u'group': u'oinstall', u'mode': u'0755'}) TASK [linux : 脚本【file_modify_etc_hosts.sh】:上传] ****************************************************************************************************************************** changed: [localhost] TASK [linux : 脚本【file_modify_etc_hosts.sh】:执行] ****************************************************************************************************************************** changed: [localhost] => (item={u'hostname': u'localhost', u'ipaddr': u'127.0.0.1'}) changed: [localhost] => (item={u'hostname': u'oracle1', u'ipaddr': u'192.168.11.11'}) TASK [linux : Linux - 系统调整：/etc/security/limits.conf] *********************************************************************************************************************** changed: [localhost] => (item={u'dest': u'/etc/security/limits.conf', u'domain': u'oracle', u'limit_item': u'stack', u'value': u'10240', u'limit_type': u'soft'}) changed: [localhost] => (item={u'dest': u'/etc/security/limits.conf', u'domain': u'oracle', u'limit_item': u'stack', u'value': u'10240', u'limit_type': u'hard'}) changed: [localhost] => (item={u'dest': u'/etc/security/limits.conf', u'domain': u'oracle', u'limit_item': u'nofile', u'value': u'1024', u'limit_type': u'soft'}) changed: [localhost] => (item={u'dest': u'/etc/security/limits.conf', u'domain': u'oracle', u'limit_item': u'nofile', u'value': u'65536', u'limit_type': u'hard'}) changed: [localhost] => (item={u'dest': u'/etc/security/limits.conf', u'domain': u'oracle', u'limit_item': u'nproc', u'value': u'2047', u'limit_type': u'soft'}) changed: [localhost] => (item={u'dest': u'/etc/security/limits.conf', u'domain': u'oracle', u'limit_item': u'nproc', u'value': u'16384', u'limit_type': u'hard'}) TASK [linux : Linux - 系统调整：/etc/sysctl.conf] ******************************************************************************************************************************** changed: [localhost] => (item={u'key': u'net.core.rmem_max', u'value': 4194304}) changed: [localhost] => (item={u'key': u'net.core.rmem_default', u'value': 262144}) changed: [localhost] => (item={u'key': u'fs.file-max', u'value': 6815744}) changed: [localhost] => (item={u'key': u'fs.aio-max-nr', u'value': 1048576}) changed: [localhost] => (item={u'key': u'kernel.sem', u'value': u'250 32000 100 128'}) changed: [localhost] => (item={u'key': u'net.core.wmem_default', u'value': 262144}) changed: [localhost] => (item={u'key': u'kernel.shmall', u'value': 2097152}) changed: [localhost] => (item={u'key': u'net.core.wmem_max', u'value': 1048576}) changed: [localhost] => (item={u'key': u'kernel.shmmax', u'value': 4294967295}) changed: [localhost] => (item={u'key': u'kernel.shmmni', u'value': 4096}) changed: [localhost] => (item={u'key': u'vm.overcommit_memory', u'value': 1}) changed: [localhost] => (item={u'key': u'net.ipv4.ip_local_port_range', u'value': u'9000 65500'}) TASK [linux : Linux - 系统调整：透明大页 - 禁用] *************************************************************************************************************************************** changed: [localhost] => (item=echo never > /sys/kernel/mm/transparent_hugepage/enabled) changed: [localhost] => (item=echo -e '\n# Disable Transparent Hugepage\necho never > /sys/kernel/mm/transparent_hugepage/enabled' >> /etc/rc.local) TASK [linux : Linux - pam.d] ************************************************************************************************************************************************ changed: [localhost] TASK [linux : 防火墙] ********************************************************************************************************************************************************** ok: [localhost] TASK [linux : SELinux - Disabled] ******************************************************************************************************************************************* ok: [localhost] TASK [linux : SELinux - Dynamic Setting] ************************************************************************************************************************************ fatal: [localhost]: FAILED! => {"changed": true, "cmd": "setenforce 0", "delta": "0:00:00.015624", "end": "2021-09-07 00:02:41.604455", "msg": "non-zero return code", "rc": 1, "start": "2021-09-07 00:02:41.588831", "stderr": "setenforce: SELinux is disabled", "stderr_lines": ["setenforce: SELinux is disabled"], "stdout": "", "stdout_lines": []} ...ignoring TASK [linux : SELinux - Check Status] *************************************************************************************************************************************** changed: [localhost] TASK [linux : SELinux - Show Status] **************************************************************************************************************************************** ok: [localhost] => { "msg": { "changed": true, "cmd": "sestatus", "delta": "0:00:00.048773", "end": "2021-09-07 00:02:42.110459", "failed": false, "rc": 0, "start": "2021-09-07 00:02:42.061686", "stderr": "", "stderr_lines": [], "stdout": "SELinux status: disabled", "stdout_lines": [ "SELinux status: disabled" ] } } TASK [linux : 文件 - /etc/yum.conf] ******************************************************************************************************************************************* ok: [localhost] TASK [linux : REPO文件：在线] **************************************************************************************************************************************************** changed: [localhost] => (item={u'name': u'CentOS-Base.repo', u'file': u'yum/CentOS-Base.repo'}) changed: [localhost] => (item={u'name': u'CentOS-SIG-ansible-29.repo', u'file': u'yum/CentOS-SIG-ansible-29.repo'}) TASK [linux : YUM - makecache] ********************************************************************************************************************************************** [WARNING]: Consider using the yum module rather than running 'yum'. If you need to use command because yum is insufficient you can add 'warn: false' to this command task or set 'command_warnings=False' in ansible.cfg to get rid of this message. changed: [localhost] TASK [linux : YUM - install] ************************************************************************************************************************************************ [DEPRECATION WARNING]: Invoking "yum" only once while using a loop via squash_actions is deprecated. Instead of using a loop to supply multiple items and specifying `name: "{{ item }}"`, please use `name: ['{{ linux_list_yum }}']` and remove the loop. This feature will be removed in version 2.11. Deprecation warnings can be disabled by setting deprecation_warnings=False in ansible.cfg. changed: [localhost] => (item=[u'java', u'binutils*', u'compat-libcap1*', u'compat-libstdc++-33*', u'gcc*', u'gcc-c++*', u'glibc', u'glibc-devel*', u'ksh*', u'libgcc*', u'libstdc++*', u'libstdc++-devel*', u'libaio*', u'libaio-devel*', u'libXext*', u'libXtst*', u'libX11*', u'libXau*', u'libxcb*', u'libXi*', u'make*', u'sysstat*', u'elfutils-libelf-devel*', u'xorg-x11-server-utils']) PLAY [Oracle Database] ****************************************************************************************************************************************************** TASK [Gathering Facts] ****************************************************************************************************************************************************** ok: [localhost] TASK [oracle : 操作系统的【Oracle】用户：环境变量] **************************************************************************************************************************************** changed: [localhost] TASK [oracle : 【安装介质】 - 分发目标服务器] ******************************************************************************************************************************************** changed: [localhost] => (item=install_media/p13390677_112040_Linux-x86-64_1of7.zip) changed: [localhost] => (item=install_media/p13390677_112040_Linux-x86-64_2of7.zip) TASK [oracle : 【Oracle】响应文件: db_install / dbca_create_db] ******************************************************************************************************************* changed: [localhost] => (item={u'path_file': u'/home/oracle/db_install.rsp', u'response_file': u'db_install.rsp.j2'}) changed: [localhost] => (item={u'path_file': u'/home/oracle/dbca.rsp', u'response_file': u'dbca.rsp.j2'}) TASK [oracle : 【Oracle / 软件】静默安装] ******************************************************************************************************************************************* [WARNING]: Consider using 'become', 'become_method', and 'become_user' rather than running su changed: [localhost] TASK [oracle : 【Oracle / 实例】静默安装] ******************************************************************************************************************************************* changed: [localhost PLAY RECAP ****************************************************************************************************************************************************************** localhost : ok=25 changed=19 unreachable=0 failed=0 skipped=0 rescued=0 ignored=1 real 8m22.393s user 1m7.920s sys 0m16.727s [root@oracle1 ansible]# |
装完了以后，看看结果：
|
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 74 75 76 77 78 79 80 81 82 |
[root@oracle1 ~]# ls -ltr /u01/app/oracle/ total 0 drwxr-xr-x 3 oracle oinstall 20 Sep 7 01:34 product drwxr-xr-x 3 oracle oinstall 20 Sep 7 01:34 common drwxr-x--- 3 oracle oinstall 18 Sep 7 01:40 admin drwxr-x--- 3 oracle oinstall 18 Sep 7 01:40 fast_recovery_area drwxrwxr-x 11 oracle oinstall 128 Sep 7 01:41 diag drwxr-xr-x 2 oracle oinstall 6 Sep 7 01:41 checkpoints drwxr-x--- 4 oracle oinstall 35 Sep 7 01:42 cfgtoollogs [root@oracle1 ~]# [root@oracle1 ~]# du -sh /u01/app/oracle/* 124K /u01/app/oracle/admin 148K /u01/app/oracle/cfgtoollogs 0 /u01/app/oracle/checkpoints 0 /u01/app/oracle/common 3.6M /u01/app/oracle/diag 9.3M /u01/app/oracle/fast_recovery_area 4.3G /u01/app/oracle/product [root@oracle1 ~]# [root@oracle1 ~]# tree /data/ /data/ └── oracle ├── fast_recovery_area ├── oradata │ └── ORCL │ ├── control01.ctl │ ├── example01.dbf │ ├── redo01.log │ ├── redo02.log │ ├── redo03.log │ ├── sysaux01.dbf │ ├── system01.dbf │ ├── temp01.dbf │ ├── undotbs01.dbf │ └── users01.dbf └── oraInventory ├── ContentsXML │ ├── comps.xml │ ├── inventory.xml │ └── libs.xml ├── logs │ ├── installActions2021-09-07_01-38-21AM.log │ ├── oraInstall2021-09-07_01-38-21AM.err │ ├── oraInstall2021-09-07_01-38-21AM.out │ └── silentInstall2021-09-07_01-38-21AM.log ├── oraInst.loc ├── orainstRoot.sh └── oui └── srcs.lst 8 directories, 20 files [root@oracle1 ~]# [root@oracle1 ~]# ps -ef | grep smon oracle 4392 1 0 01:43 ? 00:00:00 ora_smon_ORCL1 root 4566 77099 0 02:22 pts/2 00:00:00 grep --color=auto smon [root@oracle1 ~]# [root@oracle1 ~]# su - oracle Last login: Tue Sep 7 01:40:42 PDT 2021 on pts/6 [oracle@oracle1 - ORCL1:~]$ [oracle@oracle1 - ORCL1:~]$ export ORACLE_SID=ORCL1 [oracle@oracle1 - ORCL1:~]$ [oracle@oracle1 - ORCL1:~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 7 02:23:12 2021 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select name,open_mode from v$database; NAME OPEN_MODE ------------------ ---------------------------------------- ORCL READ WRITE SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@oracle1 - ORCL1:~]$ |
