6 Replies Latest reply: Nov 20, 2012 9:44 PM by MES RSS

    ORA-01017: invalid username/password - on RAC

    Yoav
      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