Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

Oracle Tools

red and black plastic crates
APEX DevOps JavaScript Liquibase Oracle Cloud Infrastructrure Oracle Tools 

Bulk Install APEX Applications with SQLcl Liquibase

December 15, 2022December 15, 2022 cruepprich

The following code uses a JavaScript that can install multiple exported APEX applications, by looping over the export directories and

Read more
DevOps Oracle Developement Oracle Linux Oracle Tools PL/SQL 

SQLcl Aliases With Variables

October 7, 2022 cruepprich

Some example for adding parameters and variables to SQLcl aliases.

Read more
selective focus photography of woman holding yellow petaled flowers
DevOps JavaScript Liquibase Oracle Developement Oracle Tools PL/SQL 

Three Ways To Pass Environment Variables into SQLcl

October 3, 2022September 30, 2022 cruepprich

Trying to reference an environment variable in SQLcl can be a bit tricky. Here are three ways you can do

Read more
shallow focus photography of computer codes
Oracle Application Express (Apex) Oracle Tools ORDS 

ORDS Standalone: Configure SSL Certificate Chain

August 30, 2021August 30, 2021 cruepprich

This post describes the process for installing an SSL certificate chain in ORDS running in Standalone mode. Prerequisites: One instance

Read more
grayscale photography of door lockers
Cloud DevOps Oracle Cloud Infrastructrure Oracle Tools 

OCI Vault: Manage a Secret via CLI

October 13, 2020November 14, 2022 cruepprich cli, oci, secrets, vault

The OCI Vault can help you store secrets such as encryption keys, passwords , and more. I won’t go into

Read more
Cloud DevOps Groovy Jenkins Oracle Cloud Infrastructrure Oracle Developement Oracle Tools PL/SQL 

Jenkins Pipeline: Loop Multiple Databases

June 30, 2020June 30, 2020 cruepprich devops, groovy, jenkins, oracle, pipeline, plssql, sql

Here is an example for using Jenkins to loop through multiple Oracle databases (pluggable databases in this case), and execute

Read more
Cloud Oracle Cloud Infrastructrure Oracle Tools 

OCI CLI: Query By Tags

March 18, 2020March 18, 2020 cruepprich bash, cli, cloud, oracle, query, search, shell, tags

Tagging your resources is a must. Not only for billing purposes, but also for staying organized and knowing who to

Read more
Cloud DevOps Oracle Cloud Infrastructrure Oracle Developement Oracle Tools Terraform 

Terraforming Power with CSV Files

February 24, 2020May 18, 2021 cruepprich cloud, infrastructure as code, oci, oracle, terraform

It is often easier to collect resource information for Terraform through spreadsheets. In this example, I’ll build a number of

Read more
Cloud DevOps Oracle Developement Oracle Tools 

OCI Command Line Interface (CLI) Basics

July 16, 2018 cruepprich

The OCI Command Line Interface (CLI), is a Python-based command line interpreter, that lets you interact with the Oracle Cloud

Read more
Oracle Application Express (Apex) Oracle Developement Oracle Tools PL/SQL 

SQL Developer SSH connection

April 21, 2016 cruepprich cloud, ssh

If you have to access databases that can only be reached through SSH connections, you can configure SQL Developer (4.1)

Read more
  • ← Previous
Oracle ACE
Copyright © 2023 Christoph's 2 Cents. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.