Branch Strategy Runners Create bitbucket-pipelines.yml here is an example of a feature branch and with explainations. Tagging in pipeline How flyway works? SQLcl to export / install APEX applications To be able to install an exported application, the apex parsing schema need to have such role “APEX_ADMINISTRATOR_ROLE”
Category: Docker
Oracle APEX Mail Relay Docker
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…
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…
Project Notes: Whisper + APEX + Python+React+ LEARN DUTCH APP
here is the semi finished outcome. https://learn.chaoyu.nl/ The Why: I am learning Dutch, I listen to a lot of BNR news on my 2.5 to 3 hours drive from home to office and back. I feel like that I understand a lot of the content but at same time miss a lot of the context….
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…