Oracle Autonomous DB

Oracle Autonomous DB

October 07, 2020

OCI is a true Enterprise cloud.

OCI Services

Compute
Storage
Autonomous DB
Security
Containers
Networking
Database
Edge
Ravello
Cloud at customer
Data movement
Governance

OCI Infrastructre

Cloud native architectures
IoT
Autonomous DB
AI/ML
Analytics
Mobile Apps

Key Features of Autonomous DB

Eliminates full-stack administration costs
Innovate faster- with lowercost
Data safety

eliminate cyber attacks
99.95% availability

Journey of Autonomous DB

9i

automatic query rewrite, automatic undo management

10g

automatic memory management, segment space, stats gathering, storage mgmt

11g

automatic sql tuning, data optimization

12c

automatic health framework, diagnostic framework

18c

automatic columnar flash

19c

automatic indexes, partitions, materialized views

Autonomous DB

Integration of Oracle DB running on Hexadata machine + Complete infrastructure automation + Automated data center & machine learning

Automated data center includes Provisioning, Patching, upgrading, online backups, monitoring, scalaing, diagnosing, perf turning, optimizing, testing & change mgmt of complex work management
Eliminates mundane tasks

OCI Infrastructure

Regions

Data center also called as Availability Domain
Avaiability domains within region are connected with each other with low latency & high bandwidth network.

Every Availability domain will have 3 fault domains

Oracle Autonomous Database

Automomous data warehouse (ADW)

Best for analytics(data warehouse, data mart, data lake, ML)

Automomous Transaction processing(ATP)

Transaction processing, batch reporting, IOT
Appln development, ML

Benefits

Lower cost, reduce risk, accelerate innovate
simple, fast, elastic- allows to add both computing and storage as needed.

Attributes

self-driving

Rapid driving, self scaling, automatic tuning, automatic indexing

self-securing
self-reparing

Autonomus DB is placed in Exadata system

Migration and Deployment of ADB workflow

Steps for getting ADB

Decide level of automation & features required
Determine workload charecteristics and select either ATP or ADW services
Load data into the new database

thru object store for static objects
thru transaction/data replication for real time and coexistence
Migrate appln

Oracle Free Cloud Subscription

https://docs.oracle.com/en/cloud/get-started/subscriptions-cloud/index.html
Get an account -> signup
https://console.ap-hyderabad-1.oraclecloud.com/

Working with REST API

tenancyId

OCID - Oracle Cloud infrastructure ID
ocid1.tenancy.oc1..aaaaaaaa4levkirgufqps3un5txule4bwuq2hbgxgnfqu3wuznpaogfwnx5a

authUserId

User from tenancy who is going to work with api
ocid1.user.oc1..aaaaaaaau3xsyzglkfr4ttwdy44c265aytmfuqu7t5qudjcwubacglvq4ivq

keyFinterprint

Generate private key with no passphrase

openssl genrsa -out oci_api_key.pem 2048

change ownership of key so that only you can see

chmod 700 oci_api_key.pem

generate public key from private key

openssl rsa -pubout -in oci_api_key.pem 2048 -out oci_api_key_public.pem

Upload public key to Identity -> users-> <user> -> public api keys
ID that gets created is finger print

privatekeypath

SSH

ssh user@ip

ssh opc@152.67.176.71

Modify ssh config

yum -y install nano;
nano /etc/ssh/sshd_config;
exit the file
systemctl restart sshd;

Start long lived processes

nohup <command>
nohup will separate process from terminal

creating server alias

provide host, user details in /Users/vdesu/.ssh/config file

Uploading files with scp

scp <file> user@server :serverpath
scp -r <dirname> user@server: serverpath

Downloading files with scp

scp user@server :serverpath <file>
scp -r user@server: serverpath <localdirname>

SSH Keys

This is for authentication
Generate Public & Private keys
Upload public key on server
tell ssh client to use ssh authentication
Public & Private keys

Random data but carefully crafted

Assymetry

Data encrypted with public key can only be decrypted with private key
Private key cannot be figured out from public key
Public key can be figured out from Private key

Generate key pair

ssh-keygen -t rsa -b 4096 -C "comments"

Copy public key on server

edit file ~/.ssh/authorized_keys & paste public key

connect using keys

ssh -i privatekey opc@152.67.176.71
ssh -i privatekey orclserver

Linux Basics

edit text files

nano, vi

view text files

cat

Run single command as admin

sudo <command>

Become administrator

sudo su

Install new package

yum install <package>

Bash vs shell

Bash is shell but not vice versa

shell

processor for what ever typed in terminal
eg: bash, ksh, fish...
Bash is one of the shell

Bash

Default processor for what ever typed in terminal

Start HTTP process

mkdir & cd to dir www
create html file
python command to start http server

sudo python -m SimpleHTTPServer 8181

Environment labels

List of all env variables

env

$ENV_NAME - reference to env variable

Working with strings

Double quotes

interpolating variables

single quote

preserving string as is

apostrophe

interpolating command output
apostrophe between double quotes to g
eg: echo "today is `date`"

Env variables in script

export

export myenv1=Good morning

env
which <command> to show the command file
$PATH - list of directories which bash should scan to execute command

echo "$PATH"

Comments