yargyropoulos/oracle

By yargyropoulos

Updated 3 months ago

An instantiated Oracle19c EE database, empty and ready to add your user and schema

Image
0

30

An instantiated Oracle19c EE database, empty and ready to add your user and schema

  • Password: ora123123
  • Ports 1521, 5500
  • ORACLE_SID=ORCLCDB
  • ORACLE_PDB=ORCLPDB1
  • ORACLE_PWD=pass1234
  • ORACLE_CHARACTERSET=AL32UTF8

Create a new container like this :

docker run -d -p 1521:1521 --name <Container Name> \
  yargyropoulos/oracle:19c_empty

Change the passwrod running docker exec <Container Name> ./setPassword.sh <Your new password>

To add a new user, connect with sqlplus system/ora123123@//localhost:1521/ORCLPDB1 And execute this SQL :


CREATE USER <db_user> IDENTIFIED BY <pass> DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
GRANT CONNECT, RESOURCE to <db_user>;
commit;
exit;

Docker Pull Command

docker pull yargyropoulos/oracle