My Oracle Support Banner

ORA-01017 when connecting to the Snapshot Standby Database as non-sys user (Doc ID 2596965.1)

Last updated on JUNE 01, 2020

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.2]
Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.


After converting the physical standby database into a snapshot standby database non-sys users were not able to connect to the database, only sys user was able to connect to the database.

The error returned was ORA-01017: invalid username/password


The same connections using non sys users could be made when the database was opened in read only mode before the snapshot standby conversion.


 Converted physical standby into snapshot standby for application tests. 


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.