Category: SQLcl
-
Tinkering: a SQL script for the ORDS_ADMIN.ENABLE_SCHEMA procedure
Post-ORDS installation Once you’ve installed ORDS, you need to REST-enable your schema before taking advantage of ORDS (I used to forget this step, but now it’s like second nature). RESOURCES: I’ve discussed ORDS installation here and here. I’d check both pages if you’re unfamiliar with it or want a refresher. ORDS.ENABLE_SCHEMA / ADMIN_ORDS.ENABLE_SCHEMA While logged into your…
Written by
-
ORDS install considerations: choosing the correct host, port, service name, and pluggable database when the database is in a podman container
The other day, I wrote about how I had to start from scratch on my podman containers 😢. I’m now at the step where I need to reinstall ORDS in these two new database containers (21c and 23c). And since I’m doing this install yet again, I figured I would point out some things I’ve…
Written by
-
ORDS, SQLcl, APEX via YUM and DNF
TL;DR BREAKING NEWS!! APEX packages with ORDS and SQLcl now available in Oracle Linux YUM servers and through ULN The deets Here is what you need to know. We are releasing three new APEX (a.k.a. “The Artist formerly known as Oracle Application Express”) packages for the following repositories: NoARCH RPMs One more update! These RPMs…
Written by
-
User Guide: Oracle database in a Podman container, install ORDS locally, and access a SQL Worksheet on localhost
Summary The title says it all. I’ve run through this about ten times now. But I’ll show you how to start a Podman container (with a volume attached) and install ORDS on your local machine. And then, once installed, we’ll create and REST-enable a user so that the user can take full advantage of Oracle…
Written by
-
Podman, Oracle Container Registry, and SQLcl
Containers are kind of like terrariums.
Written by
