E-Business Suite R12 : Error ” DB Connection Could Not Be Established. Either The Db Is Down Or The APPS Credentials Supplied Are Wrong ” While Starting Concurrent Managers Using adcmctl.sh Script

Platform:
======
Oracle Applications DBA – Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Application Object Library – Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.




Symptoms:
=======
On EBS 12.1.3 version, AD UTILITIES


We are unable to start adcmctl.sh in R12 DEV application.We are getting below error while starting adcmctl and apps account is getting locked.

We tried to reset applsys password using FNDCPASS but we unable to reset it.


ERROR
———————–
Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong

STEPS
———————–
The issue can be reproduced at will with the following steps:
1. From putty, run the command $adcmctl.sh start apps/****
2. And the issue is observed.


BUSINESS IMPACT
———————–
The issue has the following business impact:
Due to this issue, users cannot carry out their normal operations as per their business needs.




Cause:
====

APPS account has been defined to use CUSTOM PROFILE => OFS_PROFILE.
This issue is described in “Secure Configuration Guide for Oracle E-Business Suite Release 12” ,page 10 .
The FAILED_LOGIN_ATTEMPTS property has to be set to UNLIMITED whereas in your case it is set to 10 in your CUSTOM PROFILE => OFS_PROFILE and hence issue is observed.
Solution:
======
To implement the solution , perform the below steps =>

1. Log into SQLPLUS

2. Run below command

  SQL> ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

3. Verify for the issue.

  • July 10, 2018 | 20 views
  • Comments