Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot install 12.1.0.2 after installing 11.2.0.4 #15

Open
Ranzo3 opened this issue Aug 16, 2020 · 1 comment
Open

Cannot install 12.1.0.2 after installing 11.2.0.4 #15

Ranzo3 opened this issue Aug 16, 2020 · 1 comment

Comments

@Ranzo3
Copy link

Ranzo3 commented Aug 16, 2020

SUMMARY

11.2.0.4 was successful, but when attempting to install second home 12.1.0.2 it doesn't do anything.

ISSUE TYPE
  • Bug Report
COMPONENT NAME
ansible 2.9.6
  config file = /Users/ranzo.taylor/.ansible.cfg
  configured module search path = [u'/Users/ranzo.taylor/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules']
  ansible python module location = /Users/ranzo.taylor/Library/Python/2.7/lib/python/site-packages/ansible
  executable location = /Users/ranzo.taylor/Library/Python/2.7/bin/ansible
  python version = 2.7.16 (default, Jul  5 2020, 02:24:03) [GCC 4.2.1 Compatible Apple LLVM 11.0.3 (clang-1103.0.29.21) (-macos10.15-objc-
CONFIGURATION

DEFAULT_HOST_LIST(/Users/ranzo.taylor/.ansible.cfg) = [u'/Users/ranzo.taylor/ansible/hosts']
DEFAULT_REMOTE_USER(/Users/ranzo.taylor/.ansible.cfg) = centos

OS / ENVIRONMENT

Using MAC OS 10.15.6 (Catalina)
Managing CentOS 7

STEPS TO REPRODUCE
Install 11.2.0.4 successfully, then try 12.1.0.2

RanzoTaylorsMBP:ansible ranzo.taylor$ cat oracle-s3-11204.yaml 
---
- name: Install oracle db
  hosts: all
  roles:
    - role: lean_delivery.oracle_db
      oracle_version: 11
      patch_version: 11.2.0.4
      transport: web
      # transport_local: /Users/ranzo.taylor/Downloads/11.2.0.4
      transport_web: http://swoosh-oracle-software-bucket.s3-us-west-2.amazonaws.com
      oracle_images:
        - p13390677_112040_Linux-x86-64_1of7.zip
        - p13390677_112040_Linux-x86-64_2of7.zip
        - p13390677_112040_Linux-x86-64_3of7.zip
        - p13390677_112040_Linux-x86-64_4of7.zip
        - p13390677_112040_Linux-x86-64_5of7.zip
        - p13390677_112040_Linux-x86-64_6of7.zip
        - p13390677_112040_Linux-x86-64_7of7.zip
      unqname: orcl112
      sid : orcl112
      syspass: delphix
      syspassword: delphix
      systempassword: delphix
      sysmanpassword: delphix
      dbsnmppassword: delphix
      db_user_password: delphix
      oracle_base: /opt/app/oracle/product
      oracle_db_swapfile: /opt/app/oracle/oracle-swapfile-11204
      oracle_db_swap_count: 2048

RanzoTaylorsMBP:ansible ranzo.taylor$ cat oracle-s3-12102.yaml 
---
- name: Install oracle db
  hosts: all
  roles:
    - role: lean_delivery.oracle_db
      oracle_version: 12
      patch_version: 12.1.0.2
      transport: web
      # transport_local: /Users/ranzo.taylor/Downloads/11.2.0.4
      transport_web: http://swoosh-oracle-software-bucket.s3-us-west-2.amazonaws.com
      oracle_images:
        - linuxamd64_12102_database_1of2.zip
        - linuxamd64_12102_database_2of2.zip
      unqname: orcl121
      sid: orcl121
      syspass: delphix
      syspassword: delphix
      systempassword: delphix
      sysmanpassword: delphix
      dbsnmppassword: delphix
      db_user_password: delphix
      oracle_base: /opt/app/oracle
      oracle_db_swapfile: /opt/app/oracle/oracle-swapfile-12102
      oracle_db_swap_count: 2048
EXPECTED RESULTS

Install 12.1.0.2

ACTUAL RESULTS

It detects /etc/oratab, and then skips remaining steps

RanzoTaylorsMBP:ansible ranzo.taylor$ ansible-playbook oracle-s3-12102.yaml --private-key ~/.ssh/NikeDelphixSharedKey.pem --user centos --verbose --flush-cache
Using /Users/ranzo.taylor/.ansible.cfg as config file

PLAY [Install oracle db] **********************************************************************************************************************************************************

TASK [Gathering Facts] ************************************************************************************************************************************************************
ok: [52.39.157.151]

TASK [lean_delivery.oracle_db : Check /etc/oratab exists] *************************************************************************************************************************
ok: [52.39.157.151] => {"changed": false, "stat": {"atime": 1597513189.9319746, "attr_flags": "", "attributes": [], "block_size": 4096, "blocks": 8, "charset": "us-ascii", "checksum": "d24c630d08eb0983e6d0fedf4fa5ca1c4a8312a1", "ctime": 1597513185.6300023, "dev": 66306, "device_type": 0, "executable": false, "exists": true, "gid": 1001, "gr_name": "dba", "inode": 4227272, "isblk": false, "ischr": false, "isdir": false, "isfifo": false, "isgid": false, "islnk": false, "isreg": true, "issock": false, "isuid": false, "mimetype": "text/plain", "mode": "0664", "mtime": 1597365537.887345, "nlink": 1, "path": "/etc/oratab", "pw_name": "oracle", "readable": true, "rgrp": true, "roth": true, "rusr": true, "size": 794, "uid": 1001, "version": "18446744073601020820", "wgrp": true, "woth": false, "writeable": false, "wusr": true, "xgrp": false, "xoth": false, "xusr": false}}

TASK [lean_delivery.oracle_db : Choose vars based on oracle version] **************************************************************************************************************
skipping: [52.39.157.151] => (item=/Users/ranzo.taylor/.ansible/roles/lean_delivery.oracle_db/vars/oracle12.yml)  => {"ansible_loop_var": "version", "changed": false, "skip_reason": "Conditional result was False", "version": "/Users/ranzo.taylor/.ansible/roles/lean_delivery.oracle_db/vars/oracle12.yml"}

TASK [lean_delivery.oracle_db : Make preparations and install requirements] *******************************************************************************************************
skipping: [52.39.157.151] => {"changed": false, "skip_reason": "Conditional result was False"}

TASK [lean_delivery.oracle_db : Create swap file] *********************************************************************************************************************************
skipping: [52.39.157.151] => {"changed": false, "skip_reason": "Conditional result was False"}

TASK [lean_delivery.oracle_db : Adjust kernel parameters and shared memory] *******************************************************************************************************
skipping: [52.39.157.151] => {"changed": false, "skip_reason": "Conditional result was False"}

TASK [lean_delivery.oracle_db : Oracle DB XE install] *****************************************************************************************************************************
skipping: [52.39.157.151] => {"changed": false, "skip_reason": "Conditional result was False"}

TASK [lean_delivery.oracle_db : Oracle DB 11 or 12 install] ***********************************************************************************************************************
skipping: [52.39.157.151] => {"changed": false, "skip_reason": "Conditional result was False"}

TASK [lean_delivery.oracle_db : Postinstall actions] ******************************************************************************************************************************
skipping: [52.39.157.151] => {"changed": false, "skip_reason": "Conditional result was False"}

PLAY RECAP ************************************************************************************************************************************************************************
52.39.157.151              : ok=2    changed=0    unreachable=0    failed=0    skipped=7    rescued=0    ignored=0   


@Ranzo3
Copy link
Author

Ranzo3 commented Aug 16, 2020

Removing /etc/oratab just creates problems later in the play, so I wonder if this code is tested/supposed to work with multiple installations?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant