oracle.apps.fnd.framework.OAException: Illegal method call because there is no database connection

Problem Statement >>>>>> 

Issues while login to EBS R12

oracle.apps.fnd.framework.OAException: Illegal method call because there is no database connection

Error while invoking Main Menu. java.io.FileNotFoundException: /opt/oracle/EBSDEV/apps/inst/apps/EBSDEV_mkkappsserver1/appl/fnd/12.0.0/secure/EBSDEV.dbc (Too many open files)

# Shutdown eBiz AS10g services (adstpall.sh)
# Run the following command to clear out the states and persistence files
rm $ORA_CONFIG_HOME/10.1.3/opmn/logs/states/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*
rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

Restart services and monitor the instance


Cheers !!!!!!!!!!!!

Fatal NI connect error 12170 | Many times this error is getting reported in Alert Log

Version in which Fix Applied: DB 11gR2

To revert to Oracle Net Server tracing/logging, set following parameter in the server's sqlnet.ora :

DIAG_ADR_ENABLED = OFF

Oracle Apps Folder | How to Migrate Folders | fndfold.lct

The folder configuration file fndfold.lct downloads and uploads folder definitions.
Entity Used in FNDLOAD Command: FND_FOLDERS

●●  A system administrator can change an owner of a folder using the Administer Folders form under the System Administrator responsibility.
●●  A default folder can be assigned to users and responsibilities. The default folder assignments are also handled by the folder loader.

This would download all Folders:
FNDLOAD apps/${xx_appspassword} 0 Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct DOWNLOAD_ALL_FOLDER.ldt FND_FOLDERS

To download folders using FND_FOLDER Name:
FNDLOAD apps/${xx_appspassword} 0 Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct <name of file>.ldt FND_FOLDERS NAME="<name of folder>"

To download folders by internal object names
FNDLOAD apps/${xx_appspassword} 0 Y DOWNLOAD $FND_TOP/patch/115/import/fndfold.lct \
<name of file>.ldt FND_FOLDERS OBJECT="<internal object name>"

To upload folders:
FNDLOAD apps/${xx_appspassword} 0 Y UPLOAD $FND_TOP/patch/115/import/fndfold.lct <name of file>.ldt

Using FNDLOAD with fndfold.lct to transfer folders from one database to another, and only the US language folders are downloaded.

In  fndfold.lct file comment out the following line, then it would download all the languages:
f.LANGUAGE = userenv('LANG')

If you open a SQLPLUS session and do the following select, US will be returned:
SQL> select userenv('LANG') from dual;
Therefore only the US Lang will be selected in the download.