This discussion is archived
6 Replies Latest reply: Nov 20, 2012 7:44 PM by MES RSS

ORA-01017: invalid username/password - on RAC

Yoav Newbie
Currently Being Moderated
Hi,

I have a RAC with two nodes.
From time to time i am getting the follwoing error message:
ORA-01017: invalid username/password; logon denied

 
$ echo $ORACLE_BASE 
/u01/app/oracle 

$ echo $ORACLE_HOME          
/u01/app/oracle/product/11.2.0.3/dbhome_1 
Then i am SUCCESSFULLY connecting as sysdba :
 
$ sqlplus sys/xxxx@psdwh as sysdba 

SQL*Plus: Release 11.2.0.3.0 Production on Sun Jul 29 20:25:11 2012 
Copyright (c) 1982, 2011, Oracle.  All rights reserved. 
Connected to: 
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production 
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, 
Data Mining and Real Application Testing options 

SQL> exit 
IMMEDIATLY after that , connection is FAILED , due to : ORA-01017: invalid username/password .
Any suggestion ?
 
$ sqlplus sys/xxxx@psdwh as sysdba 
SQL*Plus: Release 11.2.0.3.0 Production on Sun Jul 29 20:25:15 2012 
Copyright (c) 1982, 2011, Oracle.  All rights reserved. 
ERROR: 
ORA-01017: invalid username/password; logon denied 
Edited by: Yoav on 10:45 29/07/2012

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points