Environment:
Windows Server 2003 R2, Oracle 11.2.0.4
windows service OracleServiceSID is up
windows account is added in local group ORA_DBA
Oracle password file is created
for ORA-1031: Insufficient Privileges, check the following Oracle support document:
Windows Server 2003 R2, Oracle 11.2.0.4
windows service OracleServiceSID is up
windows account is added in local group ORA_DBA
Oracle password file is created
SQLNET.AUTHENTICATION_SERVICES
in sqlnet.ora on server
|
none
|
nts
|
all
|
/ as
sysdba
|
ORA-01017:
invalid username/password; logon denied
|
ok
|
ORA-12641:
Authentication service failed to initialize
|
local:
sqlplus sys as sysdba
|
ok
|
ok
|
ORA-12641:
Authentication service failed to initialize
|
local:
sqlplus sys@tnsname as sysdba
|
ok
|
ok
|
ORA-12641:
Authentication service failed to initialize
|
remote:
sqlplus sys@tnsname as sysdba
|
ok
|
ORA-12638:
Credential retrieval failed
|
ORA-12638:
Credential retrieval failed
|
local:
sqlplus system
|
ok
|
ok
|
ORA-12641:
Authentication service failed to initialize
|
local:
sqlplus system@tnsname
|
ok
|
ok
|
ORA-12641:
Authentication service failed to initialize
|
remote:
sqlplus system@tnsname
|
ok
|
ORA-12638:
Credential retrieval failed
|
ORA-12638:
Credential retrieval failed
|
for ORA-1031: Insufficient Privileges, check the following Oracle support document:
Troubleshooting ORA-1031: Insufficient Privileges While Connecting As SYSDBA (Doc ID 730067.1)