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>
Enter user-name: test/test@ORAPDB
ERROR:
ORA-01017: invalid username/password; logon denied
Tony
[Updated on: Thu, 10 November 2022 01:26]
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
