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!!!!!!!!!!!!!
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!!!!!!!!!!!!!
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.
ReplyDeleteThis comment has been removed by the author.
ReplyDelete