Oracle Automation / Cloud

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Oracle 19c : Manually Install Oracle Database Software, setup listener and Create an empty Container Database for Single Instance +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Assumption: You already created all the required OS users (example: oracle), group (oinstall) directories (example: $ORACLE_BASE, $ORACLE_HOME) Step 1: Download Oracle Software from edelivery Step 2: Unzip Software to the Oracle_HOME directory unzip V981623-01.zip -d /u01/app/oracle/product/19.2.0/db100 Step 3: Create a response file by copying  the response file from the response file directory oracle@racdb01.localdomain:/u01/app/oracle/product/19.2.0/db100/install/response $ cp db_install.rsp /home/oracle/19cEE_SoftOnly.rsp Step4:  modify response file in a text editor with necessary changes  Step5:  start the installer in silent with response file  $ cd /u01/app/oracle/pro...

Oracle 18.5 Patch Release Update Rollback [ RAC ] using ANSIBLE TOWER This article is for applying RU on 18c RAC database with one PDB. ======================== SET UP - ANSIBLE TOWER ======================== i. Create Credential Go to settings select CREDENTIALS - to create click on +ADD and pass necessary values.  - Here I created three users oracleuser,griduser and rootuser of Machine kind  - I created githubpass of Source Control type ii. Create INVENTORIES Go to INVENTORIES tab and click on +ADD to create a inventory. Here I created   - one inventory dbservers iii. Create group and assigned HOSTS  Go to INVENTORIES -->dbservers  - click on +ADD HOST to add a new host entry  - Assign them to a group if needed iv. Create PROJECTS  - click on PROJECTS tab  - Pass the values for     NAME,     ORGANIZATION,     SCM TYPE,     PLAYBOOK DIRECTORY  - click SAVE button. ...

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ RAC RU 18.5 Oracle Grid Infrastructure and Database Home from Oracle 18.3  +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Ansible tools - easier to setup automation task instead of manually . In this article we will go through applying  RU into a Oracle GI and Database using Ansible script. Normally we need to manually run over 20 commands for patching Oracle GI and Oracle_HOME and time consuming ----but with ansible setup here I am going to execute a single command,   ansible-playbook racdatabase.yml to complete GI, RDBMS and Data Patch tasks. Tasks: main.yml - pre_tasks_before_apply [prepatch_apply.yml] + Backup opatch file from grid home / oracle home + Update required opatch utility in grid home / Oracle home + Update opatch ownership in grid home / Oracle home + OPatch Conflict Check in grid home / Oracle home + OPatch SystemSpace Check in gr...