Tag: oracle

Posted on

Creating new Oracle user, new instance

Running Oracle 19c in Docker, I connected with sqlplus and attempted to create a new user:

create user example identified by password;

and got this cryptic error:

ORA-65096: invalid common user or role name

Per answers on this post, this is usually because you connected to the root container database (CDB) instead of a pluggable container database (PDB).

You can cofirm what you are connected to with:

show con_name

and sure enough, I’m connected to CDB$ROOT:

CON_NAME 
------------------------------
CDB$ROOT

List available PDBs with:

show pdbs

shows:

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO        
         3 ORCLPDB1                       READ WRITE NO

Updating my connection properties to connect to SERVICE=ORCLPDB1 and now I’m good.

To grant all privs to a new user:

grant all privileges to username

Posted on

Oracle Container Registry logon failing with correct Oracle account credentials

docker login container-registry.oracle.com with your Oracle SSO logon no longer works after 30/6/2025, you need to create an Auth Token and use that as your password. See this banner across the top of the Container Registry site:

  • Go to container-registry.oracle.com and logon
  • Click your user account top right
  • From the dropdown menu, select Auth Token

Use this auth token value in place of your SSO password when logging on with docker login and this should work as expected.

This is described in the Oracle docs here.

Posted on

Reprogramming and flashing the Oracle Code Card from Oracle World/Code One

I don’t know why I didn’t realize this sooner or even bother to check, but the ‘Code Card’ with the e-ink screen that was given away at Oracle World a couple of years ago for an interactive lab has a ESP8266 chip on it that can be flashed with new code using a USB cable and the Arduino IDE.

The original repo for the Arduino source for the card has unfortunately had the source for the card removed, but luckily there’s a fork that still has the code, here.

There’s notes in the Arduino folder about flashing the card. These mostly worked for me apart from I found this sequence worked best:

  • connect the card to your pc with a USB cable
  • power on the card with the switch on the side
  • hold the A button, don’t let go (this is important)
  • if you have the serial tool window open in the Arduino IDE you’ll see the messages per the docs
  • Start the Upload of your new code
  • When the upload is connected and starts uploading, then you can let go of the A button

There’s a post with some more details here.

Proudly powered by WordPress