docker oracle - ghdrako/doc_snipets GitHub Wiki

docker login container-registry.oracle.com  # use user from oracle
docker pull container-registry.oracle.com/database/enterprise:19.3.0.0 # need 10GB of free disk space
docker run -d --name oracle-std3 -p 1521:1521 -e ORACLE_SID=ORCLCDB \
-e ORACLE_PWD=mySyspwd1 \
container-registry.oracle.com/database/enterprise:19.3.0.0 \
-p 1521:1521 --name oracle-std --shm-size="8g" \
container-registry.oracle.com/database/standard
docker logs oracle-std3
  • Configuring Your Oracle Database
docker exec -it <container_id> bash \
-c "source /home/oracle/.bashrc; sqlplus /nolog"
connect sys as sysdba;
alter session set "_ORACLE_SCRIPT"=true;
create user <user_name> identified by <password>;
GRANT ALL PRIVILEGES TO <user_name>
quit
  • Updating the User Password
alter session set "_ORACLE_SCRIPT"=true;
update user <user_name> identified by <password>;
GRANT ALL PRIVILEGES TO <user_name>;
⚠️ **GitHub.com Fallback** ⚠️