Notes from Heroes of autonomous Oracle

Sandesh Rao
sql developer 18.3
Download anaconda and check zupitor notebook

Find next best window when maintenance can be performed with minimal service impact
from average active sessions: AI application
Re-start nodes one by one---May be killing and re-starting nodes


Can we create a data lake with all customers data and generate usefull reports from them that can benifits the customers?

Why we need divers to search sea level but not Drones?

Write a algoritm when a query changes explain plan and impact of the same?

Can we utilize oracle 12.2 algoritms by populating 12.1 and previous databases metadata to them like AWR data etc?

Remove clutter from database logs?


Can we enable all enterprize features on at least test machines and generate best data out of it and use for prod? For example, tunning advisor, segment advisor , index monitoring etc.?

Write sql against dbms_datamining packages to get ML data

Malay Kumar Khawas, Sr ETA
Autonomous transaction processing

https://myservices.us.oraclecloud.com/mycloud/signup?sourceType&sourceType=:eng:ip:ie::RC_PDMK190401P00011:IndiaRSBlloreATPHOLMeetupMay_04_19

Name:anandcloud1

LAB doc:
https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/?page=LabGuide200SecureConnectivityAndDataAccess.mds

https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/?page=README.md


https://console.eu-frankfurt-1.oraclecloud.com/a/db/adb/ocid1.autonomousdatabase.oc1.eu-frankfurt-1.abtheljtqhfph2igflv4paewxx6wsnwsrx5oy7ztmw7terl7mm66732ufb3a

anand.yadav@jda.com
password:Kuchbhi@12345

DBName:
DB201905041220
Kuchbhi@12345



https://console.eu-frankfurt-1.oraclecloud.com/object-storage/buckets/frcxommztxdd/ATPLab/customers.csv

https://swiftobjectstorage.eu-frankfurt-1.oraclecloud.com/v1/frcxommztxdd/ATPLab/customers.csv


#S0[hRpve6;QXRiBhQDc


set define off
begin
  DBMS_CLOUD.create_credential(
    credential_name => 'OBJ_STORE_CRED1',
    username => 'anand.yadav@jda.com',
    password => '#S0[hRpve6;QXRiBhQDc'
  );
end;
/
set define on


/* Specify the real base_URL for your OCI Object Storage in the define base_URL line below*/
/* change gse00014623 to your real tenancy name. The name is case-sensitive. */
/* change ATPDB to your real bucket name. The name is case-sensitive. */
/* change us-phoenix-1 to your real region name. The name is case-sensitive. */
/* you can find these values on the OCI Console .. Storage .. Object Storage screen */

define base_URL='https://swiftobjectstorage.us-phoenix-1.oraclecloud.com/v1/gse00014623/ATPDB'

define customer_dat_URL = '&base_URL/customers.csv';





begin
 dbms_cloud.copy_data(
    table_name =>'CUSTOMERS',
    credential_name =>'OBJ_STORE_CRED1',
    file_uri_list => 'https://swiftobjectstorage.eu-frankfurt-1.oraclecloud.com/v1/frcxommztxdd/ATPLab/customers.csv',
    format => json_object('ignoremissingcolumns' value 'true', 'removequotes' value 'true', 'dateformat' value 'YYYY-MM-DD HH24:MI:SS', 'blankasnull' value 'true')
 );
end;
/


DemoVCN
CIDR Block:

10.0.0.0/16
Compartment:

PD


ssh-rsa AAAAB3NzaC1yc2EAAAABJQAAAQB7tMDR0CDLUdoe3xYgGNKMDHxmQJNYd/jeyPJTwcaQmEjQFULoSmgkVqlIbUwgz1DmDl1y1HslJ1sFxzXJRMdwsTBhhAriIHKjDB8vVF5QMXiR4qw14zHFwmRMp5WFK53xULjFGmZ2N41CMMh0GN27PMYdZsmH1jL2Eeq4Vl4IC4E1meOGOdxtEVtJJzcZdAsz1yuAyMnA54nC6Ygt2LtMvADId+hXWyqAv9iTCqgGC1bzZ75FbXIysAebdwfgjAl2wqZWmqlBqvCyUyYn4FDuHlTh5AsGMUjJXC7nUVjQ2jOYQ4WN8/FgQGu/yrM2ufGx9qN0D8EGFJNab43RpT43 rsa-key-20190504

130.61.72.31
user:opc

sudo curl --silent --location https://rpm.nodesource.com/setup_10.x | sudo bash -

sudo yum install nodejs
python --version
sudo yum install libaio
node --version
npm --version
sudo yum install git

scp -i C:\Tools\ATP/perkey.pbk C:\Tools\ATP\instantclient-basic-linux.x64-12.2.0.1.0 opc@130.61.72.31:/opt/oracle/instantclient_12_2


 git clone https://github.com/ravi041282/ATPnodeapp
 git clone https://github.com/ravi041282/ATPnodeapp


 [opc@atpmv wallet_RESTONHUBDB]$ export TNS_ADMIN=/home/opc/ATPnodeapp/wallet_RESTONHUBDB/


 Lab6:

 sudo yum install -y java-1.8.0-openjdk-devel
 cd ~

mkdir ATPJava

cd ATPJava

 sudo yum install git

 git clone https://github.com/ravi041282/ATPJava.git


 cd /home/opc/ATPJava/

mkdir lib

cd lib

wget https://github.com/sblack4/ojdbc8-full/raw/master/ojdbc8-full.tar.gz

tar xzfv ojdbc8-full.tar.gz


cd /home/opc/ATPJava/

mkdir wallet_DB

unzip /home/opc/ATPJava/Wallet_DB201905041220.zip -d /home/opc/ATPJava/wallet_DB/

cd /home/opc/ATPJava/ATPJava/src