kevinpina/oracle-xe-11g repository overview

$ docker pull kevinpina/oracle-xe-11g:v1

$ docker run --name oracle -d -p 2222:22 -p 1521:1521 kevinpina/oracle-xe-11g:v1

hostname: localhost
port: 1521
sid: xe
username: system/sys
password: system/oracle

Ex: sqlplus system/system
Ex: sqlplus sys/oracle as sysdba

$ sqlplus <username>
$ sqlplus <username>/<password>
$ sqlplus <username>/<password>@<hostname>
$ sqlplus <username>/<password>@<hostname>:<port>
$ sqlplus <username>/<password>@<hostname>:<port>/<sid>
$ sqlplus <username>/<password>@//<hostname>:<port>/<sid>
$ sqlplus "<username>/<password>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<sid>)))" 

$ sshpass -p "admin" ssh -p 2222 root@localhost

alter user <username> identified by <password>;

username: autotest
password: owncloud

create user prueba identified by prueba;
grant connect, resource to prueba;

$ sudo docker commit <ID_CONTAINER> kevinpina/oracle-xe-11g:v1
$ sudo docker push kevinpina/oracle-xe-11g:v1
$ docker run --name oracle -d -p 2222:22 -p 1521:1521 kevinpina/oracle-xe-11g:v1