Non-Oracle maintained users receiving ORA-12154 when using SQL*Plus
I am running a 19.14 multi-tenant 2-node RAC database with DataVault and TDE enabled. OLS is not in use. I have created a PDB which is not using DataVault but it is using TDE. Our profiles and roles are common (C##). A service has been created for the PDB. The tnsnames.ora entry for the PDB is :
ORCLPDB= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=hostrac000-scan)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=orclpdb))
The remote_listener is set to
(ADDRESS=(PROTOCOL=tcp)(HOST=hostrac000-scan)(PORT=1521))
The error ORA-12514 was generated when the remote listener was set to hostrac000-scan:1521
I am able to successfully tnsping to orclpdb.