1 person found this helpful
Can you please post the result of this query as sysdba.
SELECT * FROM MDSYS.RDF_PARAMETER;
Also, with a multi-tenant CDB/PDB setup, you need to run component installation scrips using catcon.pl, not through SQL*Plus:
In sys schema, there is results coming when running that sql, but in test schema, there is errors says table/view not exist.
Also you are right, it is something related to multi-tenant env. After I reinstalled the oracle without container db, it works fine now.
Glad it's working for you now. The semantics code was most likely only installed in the CDB and not in the associated PDBs.