minicurso 10 conceitos essenciais SQL - parte 1 de 7 - instalação Oracle no Linux

minicurso 10 conceitos essenciais SQL

#1 - instalação Oracle no Linux

00:00 Sobre os próximos vídeos 00:54 Baixando Oracle XE 03:01 Criando imagem Oracle com docker 12:07 Subindo o banco de dados 17:53 Criando conexão com DBeaver 23:00 O que são tablespaces e datafiles 24:33 Criando um usuário no Oracle

Oracle XE - Linux - devmultitask

https://boaglio.com/index.php/2018/09/23/o-ultimo-guia-de-instalacao-do-oracle-para-linux/

Download - https://www.oracle.com/database/technologies/xe-prior-release-downloads.html

Oracle Database 11gR2 Express Edition for Linux x64

https://www.oracle.com/technical-resources/articles/database/sql-11g-xe-quicktour.html

git clone https://github.com/oracle/docker-images/ cd docker-images/OracleDatabase/SingleInstance/dockerfiles cp ~/Downloads/oracle-xe-11.2.0-1.0.x86_64.rpm.zip 11.2.0.2/ docker run hello-world ./buildContainerImage.sh -v 11.2.0.2 -x docker images

mkdir /root/oracle11 chmod -R 777 /root/oracle11 chown -R 1000:1000 /root/oracle11

docker run --shm-size=1g -p 1521:1521 -p 9090:8080 -e ORACLE_PWD=devmultitask -v /root/oracle11:/u01/app/oracle/oradata oracle/database:11.2.0.2-xe

DBeaver - criar conexão com SYSTEM SELECT * FROM v$version SELECT tablespace_name FROM DBA_TABLESPACES create user devmultitask identified by devmultitask default tablespace users temporary tablespace temp; grant connect,resource to devmultitask; SELECT * FROM session_privs

... https://www.youtube.com/watch?v=UREn4do_l4U