R12 APPS Front End Login issue after the Clone.

R12 APPS  Front End Login issue after the clone.

I was able to see the front end screen but, was not able to go beyond login page after submitting login credentials and got with below error:

Error Page 

You have encountered an unexpected error. Please contact the System Administrator for assistance. 

Implementation 1 ----- not worked

Updating WorkFlow tables:
 

begin apps.wf_local_synch.BULKSYNCHRONIZATION(P_ORIG_SYSTEM=>'ALL',

P_PARALLEL_PROCESSES=>2,

P_LOGGING=>'LOGGING', P_RAISEERRORS=>TRUE,

P_TEMPTABLESPACE=>'APPLSYSX');

END;

/

http://oracleajidba.blogspot.com/2010/05/unable-to-login-after-clone-you-have.html ----- not working

Implementation 2 ----- not worked

SQL> SELECT profile_option_name  FROM fnd_profile_options_tl  WHERE lower(user_profile_option_name) like lower('App%log%agent');

PROFILE_OPTION_NAME

--------------------------------------------------------------------------------

APPS_LOGICAL_AGENT

APPS_LOGICAL_AGENT

APPS_LOGICAL_AGENT

APPS_LOGICAL_AGENT

SQL> select PROFILE_OPTION_NAME, PROFILE_OPTION_ID from fnd_profile_options where lower(PROFILE_OPTION_NAME) like lower('App%log%agent');

PROFILE_OPTION_NAME       PROFILE_OPTION_ID

------------------------- -----------------

APPS_LOGICAL_AGENT                     8492

SQL> select PROFILE_OPTION_VALUE from fnd_profile_option_values where PROFILE_OPTION_ID='8492';

no rows selected

SQL>

https://community.oracle.com/thread/1125331

Implementation 3 ----- not worked

Cleared Cache.

JSP Pages Hanging in R12 After Removing Cached Class Files in _pages (Doc ID 433386.1)

http://onlineappsdba.com/index.php/2009/06/02/compiling-jsps-at-runtime-in-oracle-apps-r12/

Got with below error after submitting username/password from front end.

<PRE>SQL_PLSQL_ERROR &#40;ERRNO=1000&#41; &#40;REASON=java.sql.SQLException: ORA-01000: maximum open cursors exceeded &#41; &#40;ROUTINE=decryptSessionCookie&#40;String&#41;&#41; ICX_SESSION_FAILED </PRE>

Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response. Please consult the application log for details.

Implementation 4

Earlier both cursors were 50, now changed it to 500;

alter system set session_cached_cursors=500 scope=spfile;

alter system set open_cursors=600 scope=both;

Bounce DB

Implementation 5

adadmin ----------- failed with below error

Not Possible to spawn any processes on on the database. Database has reached it limit with respect to maximum processes

SQL> alter system set processes=500 scope=spfile;

Implementation 6

SQL> select SESSION_COOKIE_DOMAIN from ICX_PARAMETERS;

SESSION_COOKIE_DOMAIN

------------------------------

select fnd_web_sec.validate_login('SYSADMIN','welcome2014') from dual;

Again, this command should return 'Y' if it is working OK.

If not, you should reload the jar files to the database using adadmin.

(adadmin, upload jar, db) --------- This worked!!!!!! Now able to login

http://beginapps.blogspot.com/2008/09/troubleshooting-login-problems-in.html