Update PDB GLOBAL_NAME to Uppercase

To support Oracle Thesaurus Management 5.4, update the PDB GLOBAL_NAME in Oracle Database 19c to uppercase.

  1. Log in to Oracle Database 19c.
  2. Enter:
    alter session set container="<PDB NAME>"
    For example: alter session set container="lsw3qa5"
  3. Enter the customer-created pluggable database (PDB) name and domain in uppercase letters:
    update GLOBAL_NAME set GLOBAL_NAME='<PDBNAME.DOMAIN>'
    For example: update GLOBAL_NAME set GLOBAL_NAME='LSW3QA5.US.ABC.COM'

    Caution:

    Do not use spaces or special characters (for example, *, &, @, %) in the global name or you cannot connect to or recover the database.