yargyropoulos/oracle repository overview

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;