Add password & user credentials

[kanuku]

Hi there,

Thank you for putting so much effort into this project.

As a regular software developer, with none experience working with Oracle DB's, I would have loved to just run a container coming from dockerhub directly....

• What is the reason I can't find an official docker image for a oracle-xe database on dockerhub?

• It would be great if you could add instructions on how we can create a container with our own user, password and database like the MYSQL and POSTGRES databases. See postgres example here.

• It would also be great if you would have made this image accessible on dockerhub with some documentation how to use the image as well.

Again thank you for publishing this project.

[JanMeckelholt]

Hi kanuku,

you can enter the container via:

docker exec -it oracle-xe bash -c "source /home/oracle/.bashrc; bash"

Then to get to the SQL-Shell
$ORACLE_HOME/bin/sqlplus sys/Oracle18@localhost/XE as sysdba
This is assuming you did not change the password in the Dockerfile.

Here you can create a user and grant him all privileges with:

create user c##testuser identified by testpassword;
grant all privileges to c##testuser;

If you change your mind:
drop user c##testuser;
;-)

exit to leave the SQL-Shell
and exit to leave the container.

Hope that helps.
Jan

PS: Thank you also from my side for the awesome work! 👍