I like the idea of SDW and have migrated from 19.4 to 20.3 but have some challenges to get all the new features to work: rest, json, dba monitoring and db api stuff in pdb only setup.
So small cookbook for issuing commands would be neat.
The required grants and ords settings are in the documentation, so it should be straightforward to set a demo pdb with fullblown sdw up.
Some constraints:
pre-requisities : have e.g. 19c + ords 20.3 working setup for pdb only. Just to be sure it works as it is and the scope of the commands etc. is for setting up the sdw for specific pdb only installation. Why I point out this pdb only is that there are different versions of apex-ords-pdb in the same db.
the ords needs to be installed with its own user like : ordsi with the privileges given with the sql in install package.
the pdb has its own administrator user instead of database wide sysdba for managing the pdb, that should be used to execute the commands
pdb could be clone of existing local pdb or just fresh
Perhaps the db api pdb operations could be left out, if they require more grants over the database and all pdbs.
Also installation of apex after the sdw works would be option.
example users and their schemas for sdw
pdb dba: all features visible
pdb api developer: rest, json, sql
pdb sql developer: sql
pdb rest api consumer : no password
pdb rest api consumer : credentials
pdb rest api consumer : oauth2 token
Then the failuremodes and troubleshooting steps to fix those:
dba: performance hub etc.: "Unable to retrieve data" (log: rest call failed e.g. to 403)
dba: instance viewer: Insufficient Privileges (seems to look CDB so needs CDB dba?)
dba: sessions: (is there e.g. linkage to connection pools monitoring?)
api developer:
what to do if REST is not visible
what to do if the REST methods wont work
curls to test e.g. the rest apis with error codes and troubleshooting doc section hints what is missing to fix in case 500, 401 etc. hits.
403 - .../metadata-catalog/
500 - .../somerestapigetmethod
..
what to do if JSON is not visible
rgrs Paavo