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. ...