Category : oracle

I have set an Oracle docker image (https://github.com/oracle/docker-images/tree/main/OracleDatabase/SingleInstance/dockerfiles) which by default is running on port 1521. I would like to change the port in the Image to 1531. I know that in the docker-compose I can set "1531:1521" BUT the other container still searching for port 1521 in the created network. I tried to modify ..

Read more

I’m using the "official" Oracle scripts to run an Oracle 19.3 se2 database in a Docker container on macOS. After successfully having created an image using the buildContainerImage.sh script I wanted to run the container using the following command: docker run –name= –publish=1521:1521 –publish=5500:5500 –env="ORACLE_SID=TEST" –env="ORACLE_PWD=manager" –env="ENABLE_ARCHIVELOG=False" oracle/database:19.3.0-se2. OS: macOS 11.5.2 Docker Desktop: 4.0.1 Unfortunately ..

Read more

I was recently trying to create a docker container and connect it with my SQLDeveloper but I started facing some strange issues. I downloaded the docker image using below pull request: docker pull store/oracle/database-enterprise:12.2.0.1-slim then I started the container from my docker-desktop using port 1521. The container started with a warning. enter image description here ..

Read more

I’ve installed Oracle Instance inside of docker container and I put sql script whitch runs when a container starts: Dockerfile: FROM… … CMD powershell echo @C:scriptsentrypoint.sql | sqlplus -S sys/password as sysdba entrypoint.sql: set serveroutput on format wrapped; declare userexist integer; db_schema_version varchar2(20); begin select count(*) into userexist from dba_users where username=’DEV’; if (userexist = ..

Read more

I have pulled my oracle image from the following command. docker pull store/oracle/database-enterprise:12.2.0.1 and run follwing command to run it. docker run -d -it –name <Oracle-DB> store/oracle/database-enterprise:12.2.0.1 that image is working fine I have tested, then I have tried it to connect with oracle from the out side that required Orcle client to connect with ..

Read more

So I’m trying to configure debezium on a Oracle database inside this docker image, according to the documentation described here. At the "Preparing the Database" the first config I have to do is: ORACLE_SID=ORACLCDB dbz_oracle sqlplus /nolog CONNECT sys/top_secret AS SYSDBA alter system set db_recovery_file_dest_size = 10G; alter system set db_recovery_file_dest = ‘/opt/oracle/oradata/recovery_area’ scope=spfile; shutdown ..

Read more