Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01017 after restore to a test server

3678149May 4 2018 — edited May 7 2018

Hello.

Os is Red Hat Enterprise Linux Server release 7.4

DB is 12.2.0.1

I intsalled Oracle 12.2.0.1 binaries on the test server, appplied patches 27105253 and 27001739.

I have taken an rman cold buckup that I restored on the test server.

Connect as sys as sysdba on the local server works but any attempt with any other username locally or remotely fails with ORA-01017:Invalid Username/Password.

I changed the password of a user but still.

Even create a new user

sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri May 4 08:38:32 2018

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

Connected to:

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

SQL> create user mytest identified by mytest;

User created.

SQL> grant connect,resource to mytest;

Grant succeeded.

SQL> conn mytest/mytest

ERROR:

ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.

SQL>

Any contribution will be appreciated.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2018
Added on May 4 2018
8 comments
1,197 views