147 Commits

Author SHA1 Message Date
Yacine31
4f767067a0 Add password configuration documentation to README
- Document user passwords in group_vars/all.yml section
- Add important warning about configuring passwords before preinstall
- Include clear instructions for password customization
- Explain automatic hashing behavior
2025-12-02 17:12:28 +01:00
Yacine31
e46d72e1c3 Implement clear text passwords with automatic hashing
- Change passwords in group_vars/all.yml to clear text (Oracle123, Grid123)
- Use password_hash('sha512') filter in users_configuration.yml for automatic hashing
- Maintain same security level but with more readable and maintainable passwords
- Passwords are hashed automatically during playbook execution
2025-12-02 17:05:57 +01:00
Yacine31
f32816ee0d Implement user password management in variables
- Add oracle_user_password and grid_user_password to group_vars/all.yml
- Update users_configuration.yml to use password variables instead of hardcoded hashes
- Enable centralized password management for system users
- Keep passwords as clear text variables (no encryption needed for this use case)
2025-12-02 17:03:31 +01:00
Yacine31
5dd6a01db9 Start working on user password management
- Create clean branch for user password implementation
- Will add oracle and grid user passwords to group_vars/all.yml
- Will update users_configuration.yml to use these variables
2025-12-02 17:00:47 +01:00
Yacine31
44e5265562 Final cleanup of role defaults
- Remove remaining duplicate variables from role defaults
- Ensure all common variables are in group_vars/all.yml
- Clean up service configurations
2025-12-02 16:32:09 +01:00
Yacine31
2452fe58ad Improve validations.yml to create scripts_dir if missing
- Replace directory existence check with directory creation
- Ensure proper ownership (oracle:oinstall) and permissions (0755)
- Remove failed_when that was causing unnecessary failures
- Make postinstall role more robust for different environments
2025-12-02 16:23:17 +01:00
Yacine31
f1dc3267e9 Fix run_db_install.sh template for first-time installations
- Check if inventory.xml exists before grep operation
- Handle first installation scenario properly
- Add informative messages for different installation states
- Use more robust comparison (-ge 1 instead of == 1)
2025-12-02 16:19:48 +01:00
Yacine31
c9671bbf60 Improve documentation and add initialization script
- Create init_oracle_install.sh script for easy setup
- Update README.md with variable centralization explanation
- Add project structure documentation
- Include variable customization examples
- Improve installation instructions with script reference
2025-12-02 16:05:13 +01:00
Yacine31
51ca83ad04 Clean up Oracle variables - complete centralization
- Add dbhome variable to group_vars/all.yml for consistency
- Remove duplicate Oracle variables from oracle-db-install defaults
- Standardize oracle_home definition across all roles
- Keep only role-specific variables in individual role defaults
- All common variables now centralized in group_vars/all.yml
2025-12-02 15:29:15 +01:00
Yacine31
cd96954bf1 Create shared Oracle variables in group_vars/all.yml
- Extract common Oracle variables from role defaults to group_vars/all.yml
- Variables are now shared across all roles without duplication
- Maintains backward compatibility with existing role defaults
- Follows Ansible best practices for variable organization
2025-12-02 13:50:45 +01:00
Yacine31
2a2fccc1df Add handlers for service management
- Create handlers/main.yml for systemd and cron service management
- Use notify to trigger daemon reload after systemd service changes
- Improve service lifecycle management
2025-12-02 13:40:11 +01:00
Yacine31
d68dda1808 Improve oracle-db-postinstall role robustness
- Enhance systemd service template with proper User/Group/Environment settings
- Use variables in cron cleaner script instead of hardcoded paths
- Add comprehensive path validations before operations
- Create validations.yml for prerequisite checks
- Improve service dependencies and startup order
2025-12-02 13:39:57 +01:00
Yacine31
f02204e026 Modularize oracle-db-postinstall role tasks
- Split main.yml into modular files: scripts.yml, backup.yml, services.yml
- Use include_tasks for better organization and maintainability
- Group related tasks by functionality
- Improve code readability and reusability
2025-12-02 13:39:23 +01:00
Yacine31
5a7a40c3a3 Consolidate redundant git tasks in oracle-db-postinstall role
- Replace 4 separate git tasks with a single consolidated task
- Add proper error handling with failed_when condition
- Remove ignore_errors usage that was masking real errors
2025-12-02 13:38:32 +01:00
Yacine31
e9b96ad99b Update .gitignore 2025-12-02 13:32:36 +01:00
Yacine31
4524e850fa Merge branch 'main' of https://github.com/Yacine31/oracle_19_install 2025-12-02 13:20:04 +01:00
Yacine31
78dbdd35f1 update README.md 2025-12-02 13:19:57 +01:00
Yacine31
71adec9223 update README.md 2025-12-02 13:17:48 +01:00
Yacine31
d7d3bc1d9e Add OL10 fix: symlink libnsl.so.1 for Oracle compatibility on OL10 2025-12-02 12:55:25 +01:00
Yacine31
40a7921d6f Add RedHat_10.yml with OL 10 packages, including missing ones: ipmiutil, libnsl2, libnsl2-devel, nfs-utils 2025-12-02 12:53:16 +01:00
Yacine31
b0ad77c471 Update stubs conditions in install_database.yml for OL 10 support 2025-12-02 12:48:11 +01:00
Yacine31
23295e115f Add support for Oracle Linux 10: update conditions, template, and README 2025-12-02 12:45:48 +01:00
Yacine31
4cad16c2a5 Improve idempotency for user/group creation in preinstall: add existence checks before creating 2025-12-02 12:32:51 +01:00
Yacine31
49abe2e012 Improve oracle-db-postinstall: standardize playbook indentation, add Oracle install check, split git tasks for better idempotency 2025-12-02 12:27:36 +01:00
Yacine31
f022b062b7 Remove redundant opatch_apply.yml since patching is in install_database.yml 2025-12-02 12:20:45 +01:00
Yacine31
fff8e22588 Clean up oracle-db-install: remove redundant download_software.yml, clean main.yml 2025-12-02 12:17:07 +01:00
Yacine31
29a59efde3 Fix typo in run_db_install.sh.j2: linux_verion -> linux_version, and CRLF to LF 2025-12-02 12:02:10 +01:00
Yacine31
8772fef05a Add checksum verification for OPatch and PSU downloads 2025-12-02 11:59:36 +01:00
Yacine31
01f1f908c4 Correct checksum URL: remove .txt extension 2025-12-02 11:56:20 +01:00
Yacine31
9ad3ee70ee Add checksum verification for Oracle zip download: download checksum.txt, extract SHA256, verify before/after download 2025-12-02 11:48:18 +01:00
Yacine31
1037b12ab4 Add .gitignore for Ansible and Oracle project 2025-12-02 11:25:52 +01:00
Yacine31
fd0976e1c3 Apply same improvements to oracle-db-postinstall: organize vars (defaults/main.yml), replace yum with package, add assertions, tags, and meta/main.yml 2025-12-02 11:24:43 +01:00
Yacine31
a3a12591d9 Apply same improvements to oracle-db-install: organize vars (defaults/main.yml), add tags, assertions, and meta/main.yml 2025-12-02 11:23:16 +01:00
Yacine31
75485f2f7c Modernize Ansible playbooks: replace deprecated syntax (include: -> include_tasks:, with_items -> loop), use ansible.builtin modules, organize variables (defaults/main.yml), standardize tags, add prerequisites assertions and meta/main.yml 2025-12-02 11:05:50 +01:00
Yacine31
fed4a87173 Update cron_oracle_cleaner.j2 2025-07-07 17:56:22 +02:00
Yacine31
c29d5cce3e Update cron_oracle_cleaner.j2
fichier log au lieu de logger
2025-07-07 17:46:49 +02:00
Yacine31
316eb16381 Create .gitignore 2025-02-07 13:25:42 +01:00
Yacine31
88c13ef0e4 Update install_database.yml 2025-02-06 11:55:35 +01:00
Yacine31
264530bfd0 Create hosts.oracle 2025-02-06 11:35:39 +01:00
Yacine31
ee860f03a8 Update main.yml 2024-06-11 02:38:03 +02:00
Yacine31
a96e608b44 Update main.yml
update patch 36233263 DB RU 19.23
2024-05-24 05:49:10 +02:00
Yacine31
70c00ac4dd Update os_configuration.yml 2024-05-24 02:41:10 +02:00
Yacine31
36c2f6f562 Update secure_configuration.yml 2024-05-24 02:27:56 +02:00
Yacine31
207f6cce85 update secure linux 2024-05-17 01:56:44 +02:00
Yacine31
21fc0bc34b Update dbora.service.j2 2024-05-15 17:22:40 +02:00
Yacine31
baed443c91 Update os_configuration.yml
ajout de la config journactl
2024-05-02 02:39:17 +02:00
Yacine31
6a3d808649 Update main.yml 2024-04-17 13:33:53 +02:00
Yacine31
722fd3deb7 Update main.yml 2024-04-17 13:29:50 +02:00
Yacine31
278d6e78b6 Update main.yml
oracle_cleaner.sh supprimé du cron root pour le mettre dans le cron oracle
2024-04-17 13:27:48 +02:00
Yacine31
c6f0db797b Update z_oracle.sh
on ne fait plus export ORACLE_SID
2024-04-17 11:21:00 +02:00