It seems that APEX 23.1.0 made some changes to its smtp mail settings. I was no longer able to use straight smtp setting from my mail server. This behavior is also on APEX on ATP. For mail services on ATP, I use oracle oci mail service. It requires some setting on my dns settings. It…
Category: Docker
Docker Cheat Sheet
# docker ps -a To list containers To list all containers To list images To delete a image To commit a running container to an image To list volumes To inspect volumns To inspect containers To build a new image To run container To mount volume To back volume To sping a new docker with…
ORDS 23.1 For Autonomous Database in Docker
First create custom ords and plsql gateway user with ADMIN user in OCI ATP. Dockerfile install_ords.sh jdk… Wallet_*.zip Docker File $1 $2 $3 $4 $5 $6 $7 $8 are placeholders for USER_NAME_ADMIN=$1 USER_NAME_ORDS=$2 USER_NAME_GATEWAY=$3 WALLET_LOCATION=$4 #full path SERVICE_NAME=$5 PWD_ADMIN=$6 PWD_ORDS=$7 PWD_PLSQL=$8 install_ords.sh Read more about this syntax Download Target ATP wallet and place it in…
NodeJs Server To Read IMAP Mailbox and send body and attachment over via REST API, and sure let’s create docker image from it
Imagine that you have an APEX application where it requires you to read and download attachments if there is any, also these data needs to be stored in database. These attachments can then further be processed by oracle database, thinking of a XML file or json file. With the requirements in mind, I started to…
Dockerize Oracle ORDs server for both XE database And ATP in OCI
I have create a github repo to create image and container from Dockerfile. see here read about using customurl instead of wallet for dbconnections here https://github.com/gotsysdba/oci-arch-apex-ords/blob/main/templates/cloud-config.tftpl
Docker learning notes: By Dockerise Oracle Database + APEX instance
How to fix docker: Got permission denied while trying to connect to the Docker daemon socket. Read more here. Images Volumes Container Tab into a running container’s cli Leave container Bash session without killing the container Ctrl + P then Ctrl + Q Start a status ‘exited’ container and tab into the bash start a…