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
(ERRNO=1000) (REASON=java.sql.SQLException: ORA-01000:
maximum open cursors exceeded )
(ROUTINE=decryptSessionCookie(String))
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
