Dear Tom,

I'm trying to connect my pdb - pdb1, using tnsnames.ora. I have granted tom dba privs just for testing purpose.

My database name/CDB name - TEST
My pdb name - pdb1

sqlplus tom/tom@pdb1
ERROR:
ORA-01017: invalid username/password; logon denied

Here's output from v$services;

Select name,pdb from v$services;

NAME PDB
---- -----
pdb1 PDB1

Here's My tnsnames.ora

PDB1 =
(DESCRIPTION =
(ADDRESS LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = myhost) PORT = 1521))
)
(CONNECT DATA =
(SERVER = DEDICATED)
(SERVICE NAME = pdb1)
)
)

I'm manually writing this code from my phone here, but pls know that I can successfully tnsping to it.

Also, I can see service pdb1 has 1 instance. instance test .....in lsnrctl services output.

I have even tried capitalising the service name in tns entry, it didn't work.

Thanks for all the questions you have answered !!!

You and team are awesome.

Regards,
Peter

ORA-01017: invalid username/password; logon denied