Skip to content

Instantly share code, notes, and snippets.

@luanvuhlu
Last active September 6, 2021 04:02
Show Gist options
  • Save luanvuhlu/d33778771c2e206e5f2fb884936a485a to your computer and use it in GitHub Desktop.
Save luanvuhlu/d33778771c2e206e5f2fb884936a485a to your computer and use it in GitHub Desktop.
docker pull store/oracle/database-enterprise:12.2.0.1-slim
docker volume create OracleData
docker run -d -v OracleData:/ORCL -p 1521:1521 --name oracle store/oracle/database-enterprise:12.2.0.1
# Wait a few minutes
docker exec -it oracle bash -c "source /home/oracle/.bashrc; sqlplus /nolog"
connect sys as sysdba;
# Password ORCLCDB
alter session set "_ORACLE_SCRIPT"=true;
create user luan identified by "80dl20h";
GRANT ALL PRIVILEGES TO luan;
--GRANT connect, create session, create table, create sequence to luan;
alter user luan DEFAULT TABLESPACE DATA quota unlimited on DATA;
Connection information:
Username: luan
Password: 80dl20h
Hostname: localhost
Port: 1521
Service name: ORCLCDB.localdomain
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment