Some Users Are Not Able To Connect After Cloning The Database ORA-1017
(Doc ID 578029.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 22.214.171.124 to 126.96.36.199
This problem can occur on any platform.
After cloning a database some users cannot connect to the database anymore from within SQLPLUS:
SQL> conn user1/test$bb
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
When connecting directly from the OS session everything is working as expected:
[oracle@ro-rac3 kit]$ sqlplus user1/test$bb
SQL*Plus: Release 10.2.0.3.0 - Production on Tue May 20 12:04:27 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining options
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