Code Monkey home page Code Monkey logo

rman_workshop's Introduction

Lab 50: Prerequistes

Works as of 2/6/2020

Creating an Oracle on-premise environment

This directory contains Vagrant build files to provision an Oracle Database automatically, using Vagrant, an Oracle Linux 7 box and a shell script.(space, space)

  1. Install Oracle VM VirtualBox
  2. Install Vagrant
  3. Clone the vagrant-boxes repository git clone https://github.com/oracle/vagrant-boxes
  4. Change into the desired version folder
  5. Download the installation zip files from OTN into this folder - first time only: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
    [IMAGE TO SHOW THE NECESSARY FILES AND SHOW THE PRE-DOWNLOADED VAGRANT FILE]
  6. Run vagrant up
  7. Connect to the database via vagrant ssh
  8. You can shut down the box via the usual vagrant halt and the start it up again via vagrant up.

Retrieving and loading the necessary packages to the Database instance

  1. Install JDK-8

    • note: any JDK version 7 or higher will work, but some packages are archived on higher JDK versions such as 11 or 13
    • make sure that you install the linux x64 rpm file
      [IMAGE TO SHOW THE JDK-8 FILE NEEDED]
  2. Install the Oracle Database Backup Module

  3. Install the vagrant-scp plugin vagrant plugin install vagrant-scp

  4. Move the opc_installer.zip and jdk-8u241-linux-x64.rpm file to your Oracle database directory

    mv ~/downloads/opc_installer.zip ~/downloads/jdk-8u241-linux-x64.rpm ~/vagrant-boxes/OracleDatabase/12.1.0.2
    [IMAGE TO SHOW THE MOVED FILES]

  5. then you want to scp the two files into the database instance:
    vagrant scp opc_installer.zip jdk-8u241-linux-x64.rpm :~

  6. Connect to the database with vagrant ssh

  7. Check to see if the two files are there

Lab 100: Configuring and using RMAN

Install the packages inside the Database instance

  1. run su to login to the root user
  2. install the JDK with $ rpm -ivh jdk-8u241-linux-x64.rpm
  3. Check to see if java was installed properly with $ java -v
  4. Unzip the opc_installer.zip file via $ unzip opc_installer.zip
  5. Get to the opc installer directory via $ cd opc_installer
  6. there are two folders inside
    [IMAGE TO SHOW THE CONTENTS OF opc_installer]
  7. We will use the oci_installer this time so run $ cd oci_installer
  8. There should be a jar file called oci_install.jar $ ls
  9. Move that to the root directory, for example $ mv oci_install.jar /opt
  10. Then get to that directory with $cd /opt
  11. Check whether the file is there $ ls
    [IMAGE TO SHOW THE JAR FILE]

Getting the prerequisites to run the JAR file

There are several prereqs to run this jar file

  1. hostname

  2. private key

  3. public key fingerprint

  4. tenancy OCID

  5. compartment OCID

  6. user OCID

  7. bucketname (optional)

  8. wallet directory location (optional)

  9. library directory location (optional)

  10. configfile directory location (optional)

  11. Also to make this work you need tenancy-level access to Object Storage, can easily be done with admin access or you can create a policy that limits access to just the required resources
    Allow group <group_name> to manage objects in compartment <compartment_name> where target.bucket.name = '<bucket_name>'

    Allow group <group_name> to read buckets in compartment <compartment_name>

rman_workshop's People

Contributors

nguy328 avatar

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.