This content has been marked as final. Show 6 replies
Can you post the contents of sqlnet.ora file?
[u01/app]$ cat ./220.127.116.11/grid/network/admin/sqlnet.ora
[/u01/app]$ find . -name sqlnet.ora ./oracle/product/18.104.22.168/dbhome_1/network/admin/samples/sqlnet.ora <<<== not relevant ./22.214.171.124/grid/network/admin/sqlnet.ora <<<== on grid home and not rdbms home
# sqlnet.ora.dm01db01 Network Configuration File: /u01/app/126.96.36.199/grid/network/admin/sqlnet.ora.dm01db01 # Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) ADR_BASE = /u01/app/oracle SQLNET.EXPIRE_TIME=10
Intermittent ORA-1017 With RAC and Remote Client [ID 778805.1] - Solve the problem.
How do you resolve this? I am also having same issue...
I had the same error last week. Invalid userid/pwd when I would log on as SYS as SYSDBA.
The problem for us started after the SYS password was changed
The problem had to do with orapwd file
So we have a two node RAC. The SYS password was changed via one of the nodes and not the other
To fix the problem we recreated the orapwd file on both the nodes. But thinking about it later, if REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE, then it should be just a matter of re-setting the password via both nodes.
so node1 had the correct pwd. but node2 had the old password. SCAN listener would direct the second login to node2
I have created new user with possward, Than I tried to login to this new user with the same possward, But I couldn't login to the schema. It throws the same error.
ORA-01017: invalid username/password
Please provide some solution.