Code Monkey home page Code Monkey logo

oracledbawithansible's Introduction

OracleDBAwithAnsible SI (Single Instances)

Note: Please modify all necessary configuration files based on your own environment.

This article describes the installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit.

Oracle Installation Prerequisites: Database Installation Guide for Linux (https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/index.html)

Setup:

  • OS: OEL 7.5
  • Ansible: ansible 2.7.6
  • Database Version: Oracle 19.3 Linux64

Oracle RDBMS Software:

Download the Oracle software from OTN or MOS depending on your support status. Oracle binaries are staged from the "edelivery: Oracle Database 19c Software (64-bit)". They have to be manually downloaded and made available for this article to apply.

  • Install Oracle Database Software Oracle DBA - Automation with Ansible (Install Oracle 19c Database Software)

Summary Steps:

  • 1 :Stage Oracle 19c RDBMS software from edelivery.oracle.com.
  • 2 :Unpack Oracle 19c RDBMS Software
  • 3 :Install Oracle 19c RDBMS Software
  • 4 :Execute oraInstroot.sh script
  • 5 :Execute root.sh script
  • 6 :Validation - Connect to SQLPLUS binary.

Summary commands:

  1. Clone this repository: git clone https://github.com/asiandevs/OracleDBAwithAnsible

  2. Stage the following Oracle Software on the control machine

Oracle Database 19c (19.3) for Linux x86-64 [ LINUX.X64_193000_db_home.zip ] https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle19c-linux-5462157.html

  1. Configure an Ansible inventory file (example as below)
[root@oel75 ansible]# cat ansible.cfg | grep inventory
inventory = ./inventory
[root@oel75 ansible]# cat inventory
[ora-x1]
192.168.56.102
[ora-x2]
192.168.56.103
[dbservers]
192.168.56.102
192.168.56.103
  1. Run the playbook role dbsoftware19c_install
ansible-playbook dbsoftware19c_install  [ with options for testing, use --check / --diff / --step / -vvv ]

You can use:

Mode Option for
--check Check mode is just a simulation
--diff reports the changes made
--step ansible to stop on each task, and ask if it should execute that task.
-v verbose mode (-vvv for more, -vvvv to enable connection debugging)

Ansible

oracledbawithansible's People

Contributors

aelhani avatar asiandevs avatar dschulz avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar

oracledbawithansible's Issues

Do you have any Ansible role to update/upgrade 19c

Hello @asiandevs ,

Do you have any role to apply patch(es) (update / upgrade) Oracle Database 19c 19.3.0.0.0 that explains the best practices to follow ?
I'm asking this for a single instance of Oracle Database 19c.

Thank you very much for your help :)
Best regards,

Connect to SQLPLUS binary is missing

Hi,

I write this issue because I'm enable to find the part : 6 :Validation - Connect to SQLPLUS binary

Is it a mistake ?

How can we check if Oracle Database installation is correct ?

Thank you very much.

Best regards,

UI not opening after the installation

My playbook worked as expected but the oracleDB UI didn't open. I have all the ports open. What I mean to say is for oracleDB 12.1.0.2 if we go to the browser and do https://x.x.x.x:5500/em the UI would open. But in this case what should be done.

I checked the code but couldn't see thi is defined anywhere.

image

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.