Some Users Are Not Able To Connect After Cloning The Database ORA-1017
Last updated on OCTOBER 25, 2017
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms