| ORA-01017 after restore to a test server [message #669656] |
Sun, 06 May 2018 09:16  |
 |
qafaro
Messages: 5
Registered: May 2018
|
Junior Member |
|
|
Hello.
Os is Red Hat Enterprise Linux Server release 7.4
DB is 12.2.0.1
Please take time to read the entire post.
I installed Oracle 12.2.0.1 binaries on the test server, applied patches 27105253 and 27001739.
I have taken an rman cold backup 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.
sec_case_sensitive_logon is FALSE.
I changed the password of a user but still.
Even created 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.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-01017 after restore to a test server [message #669668 is a reply to message #669656] |
Mon, 07 May 2018 00:37  |
John Watson
Messages: 8965
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Your setting for SEC_CASE_SENSITIVE_LOGON is incorrect:orclx>
orclx> create user mytest identified by mytest;
User created.
orclx> grant connect,resource to mytest;
Grant succeeded.
orclx> conn mytest/mytest
Connected.
orclx> conn / as sysdba
Connected.
orclx> sho parameter case_sens
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
orclx> alter system set sec_case_sensitive_logon=false;
System altered.
orclx> conn mytest/mytest
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
> |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
trying to know what could be the problem.