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.1.0.7.0 Production on Sun Apr 7 23:06:33 2016 ==>: database side
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
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 Apr 7 23:06:22 2016 ==> 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!!!!!!!!!!!!!
http://allappsdba.blogspot.in/
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.1.0.7.0 Production on Sun Apr 7 23:06:33 2016 ==>: database side
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
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 Apr 7 23:06:22 2016 ==> 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!!!!!!!!!!!!!
http://allappsdba.blogspot.in/
No comments:
Post a Comment
Note: only a member of this blog may post a comment.