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.

Sign up for GitHub

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

Jump to bottom

XE: Configuration Loops Indefinitely #8

Closed
dfhawthorne opened this issue Feb 3, 2021 · 3 comments
Closed

XE: Configuration Loops Indefinitely #8

dfhawthorne opened this issue Feb 3, 2021 · 3 comments
Assignees
@dfhawthorne
Labels
Ansible 2.9 Occurs when using Ansible 2.9 bug Something isn't working

Comments

@dfhawthorne
Copy link
Owner 

2021-02-03 10:02:12,217 p=4005 u=douglas n=ansible | TASK [Perform a silent configuration of XE database] ***********************************
2021-02-03 15:20:49,297 p=4005 u=douglas n=ansible |  [ERROR]: User interrupted execution
@dfhawthorne dfhawthorne added bug Something isn't working Ansible 2.9 Occurs when using Ansible 2.9 labels Feb 3, 2021
@dfhawthorne dfhawthorne self-assigned this Feb 3, 2021
@dfhawthorne
Copy link
Owner Author

Running command manually, sudo /etc/init.d/oracle-xe-18c configure, shows:

Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
The password you entered contains invalid characters. Enter password:
Confirm the password:

The password I used contained a special character. The script would have kept looping.

@dfhawthorne
Copy link
Owner Author

Hard-coded with "Manager0". Retry times out with command exceeded timeout. Messages were:

Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Manager0
Manager0
Manager0
Manager0
Listener configuration succeeded.
Configuring Oracle Database XE.
Enter SYS user password: 
******* 
Enter SYSTEM user password: 
********
Enter PDBADMIN User Password: 
***********
Manager0
Manager0
Manager0
Prepare for db operation
7% complete

@dfhawthorne
Copy link
Owner Author

Added to expect module:

   timeout: null

dfhawthorne added a commit that referenced this issue Feb 3, 2021
@dfhawthorne
Successful installation of Oracle 18C XE
295bd6d 
Issues resolved:
- #1 "XE: RPM Dependency - Cannot Use 19C Preinstall RPM"
- #3 "XE: YUM fails for OL7"
- #4 "XE: load passwords failed due to censored"
- #6 "XE: PIP fails to install PEXPECT"
- #7 "XE: Unable to find 18C XE RPM"
- #8 "XE: Configuration Loops Indefinitely"
- #9 "XE: Invalid Protocols for Firewall Rules"

Added .yamllint for my preferred yamllint settings.

Remove python_interpreter from Ansible configuration

Separated Oracle Linux 7 tasks into a separate file, ol7_tasks.yml.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@dfhawthorne dfhawthorne

Labels
Ansible 2.9 Occurs when using Ansible 2.9 bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@dfhawthorne