Technology Stack - EBS (MOSC)

MOSC Banner

Database account fail to login with an ORA-01017 when sec_case_sensitive_logon is set to TRUE

edited Feb 27, 2014 2:48PM in Technology Stack - EBS (MOSC) 3 commentsAnswered ✓

Greetings to all.

Tech Stack was the best place that I can think of to post this. If you have any ideas, please let me know as this works perfectly fine on several of my internal instances:

My customer recently applied patch 12964564: "1OFF:12.1.3:11GCS AND FNDCPASS USER EXIT MERGE CONSOLIDATION PATCH" to an E-Business suite 12.1.3 instance. Database is 11.2.0.2. The patch applied successfully.


The customer is trying to utilize the sec_case_sensitive_logon feature within the product. Looking at the init<SID>.ora, we see the following:


+++++++
#########
#
# Database Password Case Sensitivity
#
# The default for Oracle E-Business Suite databases is FALSE i.e. passwords are case-insensitive

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center