Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center