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…
Category: OCI
Database link Between OCI Autonomous Database
Say you would like to create DB link between 2 Autonomous Database in OCI DB1 and DB2. Assume DB1 want to query data from DB2 Create New Database Directory on DB1 Next, we need to create 2 credentials. 1 is used to access Bucket, 1 is used for storing schema@pwd to DB2 Credentials to Access…
How List/Create/Delete files in OCI bucket within APEX (plsql) + Create Pre-Authenticated Request
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 :…
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…
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…
How to upload folder(files) into Oracle OCI buckets with CLI
This method is tested working flawlessly with 69.000 files,120 gb size in total. Install OCI CLI on your local machine where you planning to upload the folders and files ( following this guide Mac Version) After Installation, Setting up the Configuration File Here , it requires your After configuration, you can chose to upload your…
Migrate APEX to Autonomous Database with custom ORDS (notes)
Create And Manage Your Custom ORDs credits goes two these two links https://fuzziebrain.com/content/id/2004/ https://www.linkedin.com/pulse/run-your-oracle-apex-apps-autonomous-database-own-domain-kurt-liu/ How to enable web sql-developer https://host/ords/sql-developer two ways to enable it. Go to Apex and enable rest for the parsing schema. make your the alias is in smallcase. or logon to the schema and write this plsql block to enable it….
Use Bastion Service to Connect To Autonomous DB within a private subnet PLSQL Developer
Validate VCN security list ingression rule. Find your database subnet check security list settings if 1522 ingress rule not existing, add it Create A Bastion in the same VCN or existing bastion in the same VCN where your Autonomous DB reside Create Session Open SSH Tunnel “-i <privateKey>” is not needed since we use public…
Oracle Cloud Infrastructure: Terraform
Installation of Terraform on your local machine On Mac run Installation of OCI CLI on your local machine Official OCI CLI installation guide: https://docs.oracle.com/en-us/iaas/Content/API/SDKDocs/cliinstall.htm#InstallingCLI__macos_homebrew After installation of OCI CLI and Terraform on your local Machine A guide to get start use Terraform with OCI connection to your OCI tenancy. How to make connections to your…