Skip to content

Latest commit

 

History

History
104 lines (72 loc) · 4.15 KB

README.md

File metadata and controls

104 lines (72 loc) · 4.15 KB

Docker Oracle Database

Docker Pulls

Description

This repository contains an official Oracle Database images with additional scripts

Official Documentation

Dockerhub

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

Running Container

docker run -it --name oracle -p 1521:1521 scalified/oracle-database:<tag>

Connecting to the Database

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>

Creating PDB

docker exec <oracle_container_name> create-pdb.sh <db_name> <username> <password>

where:

  • <db_name> - PDB name
  • <username> - PDB username
  • <password> - PDB password

Changing Enterprise Manager Endpoint

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);

Changing Connection Timeouts

echo "INBOUND_CONNECT_TIMEOUT_LISTENER=0" >> $ORACLE_HOME/network/admin/listener.ora
echo "SQLNET.INBOUND_CONNECT_TIMEOUT=0" >> $ORACLE_HOME/network/admin/sqlnet.ora

Scalified Links