OCI account OCI user which has read/write access to the Bucket On that User create an API key Download the private key and click on “Add“ Keep OCI window open Open APEX screen Go to Workspace Utility find web credentials create new web credentialsgive it a name like OCI_AUTH Authentication Type: Oracle Cloud InfrastructureOCI UserID :…
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…
Tortoise Git Icon overlay not working…. (how to fix)
https://medium.com/automationmaster/how-to-enable-the-overlay-icons-for-tortoisegit-cbb054617ad6
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…
How to import Data d(p)ump into Oracle OCI Autonomous Database
https://docs.oracle.com/en/database/oracle/oracle-database/21/sutil/oracle-datapump-import-utility.html#GUID-BBB3CB15-B136-423F-B1EA-BF93A935793F documentation more information on oracle-base PreRequisite ———————————————————————————- Step !: Create an Auth TOKEN from OCI user save the token somewhere safe (you can copy it during creation, once created it can NOT be displayed anymore) ———————————————————————————- Step 2: use sqlplus login to your autonomous database using !!!<ADMIN> account and run ———————————————————————————- Step 3: create…