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: Linux
Linux Nano Cheat Sheets
General Alt + N to show line number Alt + P to show whitespaces Copy Paste ALT + A To set cursor : Arrow key Move setted cursor ALT + 6 to copy Copy CTRL + U Paste CTRL + K to delete / cut entire line Copy Entire Line Ctrl + A to go…
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…
Nginx with cabundle.crt certificate.crt ( seperated domain and intermedia+root certs
Some SSL provider generates intermedia.crt root.crt and domain cert in 2 different files, when configure nginx 3 things need to happen first. link1 for cat link2 for setenforce 0 Funny thing is , if you provide only the domain crt in the nginx config file, browser would not complain. But if u do a curl…
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
OCI Operations Professional Learning Notes
OCI CLI Authentication OCI CLI and Configure on mac After installation, run configuration command. This will collect your ocids for your user, tenancy , region and more. when all done, it will create 3 file in .oci folder. 1 config file and two .pem files. The oci_chaoyuim001_api_key_public.pem file will be used to upload to OCI…
Nginx Configuration for Custom ORDs with APEX features Google Authentication [updates on Nginx Proxy Manager]
There are three things needed Google Settings, couple of things to watch out here APEX Social sign in Authentication method Make sure you have a user created in APEX with the same email as the username. Nginx Configuration Two settings here are important , they are needed for enable Google Oauth. error_page 497 https://$host:$server_port$request_uri; link…
Config Nginx as Static file server
Here is very rich video to learn Nginx Config Linux user / groups to allow filezillar connection with key files add user to group , append after its primary group ( which is not wat we want) we need to add sftpusergroup as the primary group, that way when a user create a folder all…