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

When attempting to login to EBS R12, the following error occurs: oracle.apps.fnd.framework.OAException: Illegal method call because there is no database connection Error while invoking Main Menu. java.io.FileNotFoundException: /app/oracle/EBSTEST/apps/inst/apps/EBSTEST_bkptapsrv2/appl/fnd/12.0.0/secure/EBSTEST.dbc (Too many open files) Stop application services $ adstpall.sh apps/apps Delete 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 try

After R12 Installation, $ORACLE_HOME/.patch_storage consumes more space.

After R12 installation we find the RDBMS patching backup area ($ORACLE_HOME/.patch_storage) takes more than 5 GB space.This will increase backup time and requires more backup space. Please Note: From OPatch Version 10.2 Opatch does not backup only the affected modules, it also takes a backup of the complete affected libraries to $ORACLE_HOME/.patch_storage/backup/ for faster rollback. This causes the .patch_storage directory to grow accordingly to the size of the libraries and modules being patched. Therefore, after every R12 installation, we should clean up this area. For this we need to follow the below steps: 1. Login as Database OS User 2. Set the Path $ PATH=$ORACLE_HOME/OPatch:$PATH $ export PATH $ which opatch $ opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc 3. Check the size of .patch_storage $ du -sh $ORACLE_HOME/.patch_storage 4. Run opatch cleaning $ opatch util cleanup -help $ opatch util cleanup -invPtrLoc $ORACLE_HOME/oraInst.loc 5. Now check the .patch_storage size $ du -sh $ORACLE_HOME/.patch_storage

APP-FND-01564: ORACLE error 6502 in afscpcon

After upgrading my Internet Explorer to IE9, faced the below Error.

APP-FND-01564: ORACLE error 6502 in afscpcon

Cause: afscpcon failed due to ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 325
ORA-06512: at "SYS.HTP", line 1322
ORA-06512: at "SYS.HTP", line 1397
ORA-06512: at "SYS.HTP", line 1689
ORA-06512: at "APPS.ICX_SEC", line 3457
ORA-06502: PL.

The SQL statement being executed at the time of the error was: SELECT SES.USER_ID, SES.RESPONSIBILITY_ID, SES.RESPONSIBILITY_APPLICATION_ID, SES.SECURITY_GROUP_ID, FSG.SECURITY_GROUP_KEY, U.USER_NAME, U.ENCRYPTED_USER_PASSWORD, SES.SESSION_ID, NVL(SES.LOGIN_ID, -1) FROM ICX_SESSIONS SES, FND_SECURITY_GROUPS FSG, FND_USER U WHERE SES.SESSION_ID = ICX_SEC.GetSessionCookie(:tik) AND NVL(SES.SECURITY_GROUP_ID, 0) = FSG.SECURITY_GROUP_ID AND SES.USER_ID = U.USER_ID AND DISABLED_FLAG = 'N' AND COUNTER + 1 < LIMIT_CONNECTS AND FIRST_CONNECT + LIMIT_TIME/24 > SYSDATE and was executed from the file &ERRFILE."

Solution:

Added my server http://bkptapsrv2.com in trusted sites and kept the security level as low for trusted sites. It solved the problem