Database Administration (MOSC)

MOSC Banner

Intermittent ORA-1017 error

edited Aug 22, 2013 6:33AM in Database Administration (MOSC) 5 commentsAnswered
We are on two node RAC (10.2.0.5)  and I'm getting ORA-1017 error intermittently whenever I try to connect using listener. Whenver I get connection I get on instance 1 only as shown below.

SQL> conn sys/syspassword@pplprod as sysdba
Connected.
SQL> conn sys/syspassword@pplprod as sysdba
Connected.
SQL> conn sys/syspassword@pplprod as sysdba
Connected.
SQL> conn sys/syspassword@pplprod as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn sys/syspassword@pplprod as sysdba
Connected.
SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_WAIT

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center