Home » RDBMS Server » Server Administration » Proxy PDB Connection Fails with Password Error (Oracle 19c (19.3), Windows 10)
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
SQL> select name,proxy_pdb from v$pdbs where name='ORAPDB_PROXY';

NAME                           PRO
------------------------------ ---
ORAPDB_PROXY                 YES
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

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:
  


Current Time: Thu Mar 28 05:45:04 CDT 2024