Hi,
I have a two-node Oracle 12.1.0.2 RAC using ASM, and I've found that sometimes my user's credentials fail to login to the database instance. For example, I'm using a JDBC connection to open and close a connection 10 times using my user and sometimes it'll connect 7 times successfully, other times it may succeed only 2 times, or 5 times, or it'll fail to connect right away. The error is always "ORA-01017: invalid username/password; logon denied".
Another behaviour I've observed is that when using sqlplus from Node 1, it'll always succeed, whereas it may fail to authenticate once in a while on Node 2 using sqlplus.
I've read that the password file needs to exist on the ASM disk, but it does. I don't know what else I could investigate at this point. Does anyone have any idea on what I could check or try?
Here's my database config as reported by srvctl:
[oracle@mdmorarac01 ~]$ srvctl config database -db mdmracdb
Database unique name: MDMRACDB
Database name: MDMRACDB
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/MDMRACDB/PARAMETERFILE/spfile.293.911660541
Password file: +DATA/MDMRACDB/orapwmdmracdb
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group:
Database instances: MDMRACDB1,MDMRACDB2
Configured nodes: mdmorarac01,mdmorarac02
Database is administrator managed