My Oracle Support Banner

SYSDBA Connections fail with ORA-1017 When Centrify Active Directory is Enabled (Doc ID 2708461.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


This Applies when:

1) When connection of sysdba is failing as  : Error is ORA-01017--As below
> sqlplus "/as sysdba"

SQL*Plus: Release Production on Mon Aug 31 06:25:29 2020

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

ORA-01017: invalid username/password; logon denied

2) Customer using Password file Based Authentication.

3) Making sure ORA-1017 trouble.shooting steps were referred from below DOC of Password file Based Authentication,still error remains.

Troubleshooting ORA-1031 or ORA-1017 Errors When Connecting As SYSDBA (Doc ID 730067.1)


Then Action as Below:



1) Need to get  OS level Trace(strace,truss) depending on platform.As per below syntax passing sqlplus login via sysdba in command line.

truss -aeEdfo /tmp/1017.txt sqlplus / “as sysdba”

strace -frvttT -o /tmp/1017.txt sqlplus / “as sysdba”


2) Then in OS trace  if we observe the lines as below, connect and open function call: Calling centrify

connect(8, {sa_family=AF_UNIX, sun_path="/var/centrifydc/daemon2"}, 25) = 0>>>>>>>>>>>>>>> centrifydc

open("/<ORACLE_HOME>/lib/", O_RDONLY|O_CLOEXEC)>>>>>>>>centrifydc






To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.