ORA-01017: invalid username/password; logon denied" for system user only from RAC node2 only
Hi All,
We have just converted our EBS 19c CDB single instance database to 19c RAC database using rconfig.After the conversion, we have the local listeners on both nodes up and running, the 3 scan listeners on both nodes up and running. When we try to connect as system on node 1, it works fine. But when we connect as system on node2, it gives me invalid username/password error .
we are absolutley sure that the password being entered is correct :-)
node1
-------
[oracle@idcr12dbs01u ~]$ sqlplus system/####
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 28 02:00:29 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2020, Oracle. All rights reserved.