Home » RDBMS Server » Server Administration » ORA-01017 after restore to a test server (DB 12.2.0.1)
ORA-01017 after restore to a test server [message #669656] Sun, 06 May 2018 09:16 Go to next message
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 #669657 is a reply to message #669656] Sun, 06 May 2018 11:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Please post full results from SQL below

SELECT * FROM V$VERSION;
Re: ORA-01017 after restore to a test server [message #669660 is a reply to message #669657] Sun, 06 May 2018 16:45 Go to previous messageGo to next message
qafaro
Messages: 5
Registered: May 2018
Junior Member
Hello.
Here is the output:

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

PL/SQL Release 12.2.0.1.0 - Production
0

CORE 12.2.0.1.0 Production
0

TNS for Linux: Version 12.2.0.1.0 - Production
0

NLSRTL Version 12.2.0.1.0 - Production
0
Re: ORA-01017 after restore to a test server [message #669661 is a reply to message #669660] Sun, 06 May 2018 17:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It works OK for me.
Problem seems localized to your environment
[oracle@vbgeneric ~]$ sqlplus sys/oracle as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun May 6 18:08:16 2018

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


Connected to:
Oracle Database 12c Enterprise 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> connect mytest/mytest
Connected.

Re: ORA-01017 after restore to a test server [message #669662 is a reply to message #669661] Sun, 06 May 2018 17:17 Go to previous messageGo to next message
qafaro
Messages: 5
Registered: May 2018
Junior Member
Smile trying to know what could be the problem.
Re: ORA-01017 after restore to a test server [message #669663 is a reply to message #669662] Sun, 06 May 2018 17:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
is database in multi-tenant environment?
Re: ORA-01017 after restore to a test server [message #669664 is a reply to message #669663] Sun, 06 May 2018 18:21 Go to previous messageGo to next message
qafaro
Messages: 5
Registered: May 2018
Junior Member
No it isn't.
Re: ORA-01017 after restore to a test server [message #669665 is a reply to message #669664] Sun, 06 May 2018 18:23 Go to previous messageGo to next message
qafaro
Messages: 5
Registered: May 2018
Junior Member
Here is sqlnet.ora.

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

#SQLNET.ALLOWED_LOGON_VERSION=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10
Re: ORA-01017 after restore to a test server [message #669668 is a reply to message #669656] Mon, 07 May 2018 00:37 Go to previous message
John Watson
Messages: 8640
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.
>
Previous Topic: Meta data for Table Partition (merged 2 CM)
Next Topic: Not able to connect using SID
Goto Forum:
  


Current Time: Wed Dec 01 08:16:11 CST 2021