The ords_create_rest_users.sql has a bug. It runs 'create user ORDS_PUBLIC_USER...' terminated by semicolon (it actually succeeds) but just after this statement goes a slash-line meaning effectively "run again" in this context.
Just remove the slash after the 'create user ORDS_PUBLIC_USER...' line.
Oracle is obviously half-way changing "direct" create/drop user statements to the "execute immediate" style ;-/.
alter session set container=PDB$SEED;
select tablespace_name from sys.dba_tablespaces;
By default, there is no USERS tablespace created in the PDB$SEED in db installation.
When I tried to run the manual install script @ords_manual_install.sql, it failed with the following error. As you can see, the USERS tablespace doesn't exist in the PDB$SEED, so the error is correct. But how to resolve this problem? Use the SYSAUX in place of the USERS tablespace? How to create the USERS tablespace in the PDB$SEED?
Verifying tablespaces for PDB$SEED
Completed verifying the tablespaces SYSAUX and TEMP for SYS
ERROR at line 1:
ORA-20005: ERROR: The default tablespace USERS does not exist. An existing
tablespace is required for ORDS installation.
ORA-06512: at line 10
ORA-06512: at line 28