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 184.108.40.206 to 220.127.116.11 [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