| ORA-01017 OS Authentication Fails [message #645484] |
Mon, 07 December 2015 08:38  |
 |
juniordbanewbie
Messages: 250
Registered: April 2014
|
Senior Member |
|
|
Dear all,
first I installed 32 bit 11.2.0.4 client. Next I installed Database binaries.
I've encounter these problems while installing the binaries and creating database from oracle universal installer,
ora-12638 credential retrieval failed
In the end binaries are installed but database is not created.
so I changed SQLNET.AUTHENTICATION_SERVICES = (NTS) to SQLNET.AUTHENTICATION_SERVICES = (NONE)
I reinvoke DBCA again, this time database is created.
but i cannot connect through OS authtication
C:\Users\olaf>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mo Dez 7 05:37:56 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-01017: Benutzername/Kennwort ung³ltig; Anmeldung abgelehnt
while I can connect using remote passwordfile
C:\Users\olaf>sqlplus sys/******@orcl as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mo Dez 7 07:59:05 201
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Verbunden mit:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
SYS@orcl>
I've check that I'm in the ORA_DBA group
C:\Users\olaf>NET LOCALGROUP ORA_DBA
Alias name ORA_DBA
Comment Oracle DBA Group
Members
----------------------------------------
camden\olaf
NT AUTHORITY\SYSTEM
The command completed successfully.
I've also checked that the %PATH% parameter place Oracle DB Home first before the client home
the closest post I came across is this https://community.oracle.com/thread/3540848
unfortunately my situation is even worse
any help rendered is really appreciated!
thanks and many thanks!
[Updated on: Mon, 07 December 2015 08:50] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-01017 OS Authentication Fails [message #645510 is a reply to message #645498] |
Mon, 07 December 2015 17:20  |
|
juniordbanewbie
Messages: 250
Registered: April 2014
|
Senior Member |
|
|
BLack swan, you are right.
sqlnet.authentication_services = (NTS) => is correct
from Step by Step Guide to Troubleshoot and Solve the ORA-01031 Error for SYSDBA OS Authentication. (Doc ID 761830.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=243153311175259&id=761830.1&_afrWindowMode=0&_adf.ctrl-st ate=ijjzilpu7_74
Quote:
sqlnet.authentication_services = (NTS)
or
sqlnet.authentication_services = (NTS,KERBEROS5)
Error will be
C:\Users\olaf>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mo Dez 7 16:02:06 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12638: Abrufen der Zugangsdaten nicht erfolgreich
C:\Users\olaf>sqlplus sys/********@orcl as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mo Dez 7 16:03:19 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12638: Abrufen der Zugangsdaten nicht erfolgreich
Benutzernamen eingeben:
Michel, you are also right, there's way to trace OS authentication failure just that I din search hard enough,
the way to trace is also from above MOS Document
John,
yes, I did run from the database home. becoz of this experience now I installed the client first then database knowing very well that the db oracle home will be appended first to the path.
anyway this problem have to be resolved by MOS. Hopefully they can resolve this as soon as possible.
thanks you guys for the fast response!
[Updated on: Mon, 07 December 2015 19:59] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
