Sunday 14 July 2013

After database bounce apps password is not working in cloned instance 11g database "ERROR: ORA-01017: invalid username/password; logon denied"

After database bounce apps password is not working in cloned instance.

Issue:

On database node not able to connect to sqlplus as apps schema
=============================================

oratest#ctsst $ sqlplus apps/apps#man

SQL*Plus: Release 11.2.0.3.0 Production on Sun Jul 7 23:06:33 2013 ==>: database side

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

^CERROR:
ORA-01017: invalid username/password; logon denied


Tried From other host still not able to connect to sqlplus as apps schema
===================================================
apptest#ctssat $ sqlplus apps/apps#man

SQL*Plus: Release 8.0.6.0.0 - Production on Sun Jul 7 23:06:22 2013  ==> forms

(c) Copyright 1999 Oracle Corporation. All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:


Work around/solution
==
SQL> show parameter sec

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_securefile string PERMITTED
optimizer_secure_view_merging boolean FALSE
sec_case_sensitive_logon boolean TRUE
sec_max_failed_login_attempts integer 10
sec_protocol_error_further_action string CONTINUE
sec_protocol_error_trace_action string TRACE
sec_return_server_release_banner boolean FALSE
sql92_security boolean FALSE
SQL> alter system set sec_case_sensitive_logon=FALSE;

System altered.

SQL>


after doing above steps apps password is working fine!!!!!!!!!!!!!


2 comments:

  1. Thank you very much abdul foe this post. I was facing the same issue and did the db restoration 3 times, finally after reading your blog issue has got resolved. case sensitive was true. after making false i was able to login by apps user.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete