Sunday, 17 April 2016

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 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/

No comments:

Post a Comment

Note: only a member of this blog may post a comment.