Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"sqlplus / as sysdba" quits with 1017 at first try, but works at second try

Marco W.Mar 31 2014 — edited Apr 1 2014

Hi,

i have a RAC (11.2.0.4, SE, 2 Nodes) on WindowsServer 2008 R2.

When I try to login with OS authentification on cmd (sqlplus / as sysdba), i get a ora-01017.

If i do the same again, it works normally:

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

D:\Skripte\env_cmd>set o
ORACLE_HOME=D:\oracle\product\11.2.0.4\dbhome_1
ORACLE_SID=TCFM_1
ORACLE_UNQNAME=TCFM
OS=Windows_NT

D:\Skripte\env_cmd>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mo Mrz 31 08:16:58 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-01017: Benutzername/Kennwort ungültig; Anmeldung abgelehnt

Benutzernamen eingeben:
ERROR:
ORA-01017: Benutzername/Kennwort ungültig; Anmeldung abgelehnt

Benutzernamen eingeben:
ERROR:
ORA-01017: Benutzername/Kennwort ungültig; Anmeldung abgelehnt

SP2-0157: CONNECT-Versuch zu ORACLE nach 3 Versuchen aufgegeben, SQL*Plus wird verlassen

D:\Skripte\env_cmd>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mo Mrz 31 08:17:24 2014

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Verbunden mit:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

31.03.2014 08:17:24 SYS AS SYSDBA@TCFM_1>

Only Node 1 is so crazy. On Node 2 the login works fine.

SQLNet.ora is okay: SQLNET.AUTHENTICATION_SERVICES = (NTS)

Any Idea?

Best regards,

Marco

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2014
Added on Mar 31 2014
12 comments
11,203 views