OraFAQ Forum: Server Administration » Proxy PDB Connection Fails with Password Error

Home » RDBMS Server » Server Administration » Proxy PDB Connection Fails with Password Error (Oracle 19c (19.3), Windows 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Proxy PDB Connection Fails with Password Error [message #686646]

Thu, 10 November 2022 01:24

jesuisantony
Messages: 166
Registered: July 2006
Location: Chennai

Senior Member

Hello Team,

I am trying to test the functionality of Proxy PDB. The Proxy PDB was created. And an user account was created on the same. However, when I try to connect to the Proxy PDB or the referenced PDB, it fails.

Can you help me understand what could be going wrong?

Quote:

C:\Users\Dell>sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 10
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Enter user-name: test/test@ORAPDB_proxy
ERROR:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from PROXYPDB$DBLINK

Code: [Select all] [Show/ hide]

SQL> select name,proxy_pdb from v$pdbs where name='ORAPDB_PROXY';

NAME                           PRO
------------------------------ ---
ORAPDB_PROXY                 YES

Code: [Select all] [Show/ hide]

SQL> show con_name

CON_NAME
------------------------------
ORAPDB_PROXY
SQL> select username from dba_users where username='TEST';

USERNAME
------------------------------
TEST

SQL>

When connecting to reference PDB it just says

Code: [Select all] [Show/ hide]

Enter user-name: test/test@ORAPDB
ERROR:
ORA-01017: invalid username/password; logon denied

Regards,
Tony

[Updated on: Thu, 10 November 2022 01:26]

Report message to a moderator

Previous Topic:	gather statistics on partition table who runs it
Next Topic:	duplicate entries in dba_free_space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 04:48:38 CDT 2025