Forum Stats

  • 3,853,871 Users
  • 2,264,288 Discussions
  • 7,905,491 Comments

Discussions

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

Marco W.
Marco W. Member Posts: 15
edited Apr 1, 2014 3:23AM in General Database Discussions

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 [email protected]_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

Tagged:
«1

Answers

This discussion has been closed.