This repository contains an official Oracle Database images with additional scripts
- Oracle Database Container Registry
- Creating an Oracle Database Docker image
- Oracle Database Software Downloads
- Docker Images from Oracle* Creating an Oracle Database Docker image
docker pull scalified/oracle-database:<version>
| Version | Description |
|---|---|
| 19.3.0.0-ee | 19.3.0.0 Enterprise Edition |
| 12.2.0.1-ee | 12.2.0.1 Enterprise Edition |
| 12.1.0.2-se2 | 12.1.0.2 Standard Edition |
| 12.1.0.2-ee | 12.1.0.2 Enterprise Edition |
| 11g-r2 | 11g Release 2 Express Edition |
docker run -it --name oracle -p 1521:1521 scalified/oracle-database:<tag>
Once the container has been started and the database created you can connect to it just like to any other database:
sqlplus sys/<your password>@//localhost:1521/<your SID> as sysdba
sqlplus system/<your password>@//localhost:1521/<your SID>
sqlplus sys/<your password>@//localhost:1521/<Your PDB name> as sysdba
sqlplus pdbadmin/<your password>@//localhost:1521/<Your PDB name>
docker exec <oracle_container_name> create-pdb.sh <db_name> <username> <password>where:
<db_name>- PDB name<username>- PDB username<password>- PDB password
Check the listener status:
lsnrctl status
This will output endpoints:
...
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=67e0ca534f7b)(PORT=5500))(Presentation=HTTP)(Session=RAW))
...
Login to sql as sysdba and execute procedure:
exec dbms_xdb_config.setListenerEndPoint(dbms_xdb_config.xdb_endpoint_http2, '67e0ca534f7b', 5500, dbms_xdb_config.xdb_protocol_tcp);More info:
https://www.morganslibrary.org/reference/pkgs/dbms_xdb_config.html
Setting EM ports:
exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);
exec DBMS_XDB_CONFIG.SETHTTPPORT(5510);echo "INBOUND_CONNECT_TIMEOUT_LISTENER=0" >> $ORACLE_HOME/network/admin/listener.ora
echo "SQLNET.INBOUND_CONNECT_TIMEOUT=0" >> $ORACLE_HOME/network/admin/sqlnet.ora