This discussion is archived
0 Replies Latest reply: Dec 21, 2010 7:33 AM by user11980548 RSS

Logon to ILMa never succeeds

user11980548 Newbie
Currently Being Moderated
I have installed the toolkit 1.4 with Apex 4.0 on a 10.2.0.4 database, but when I logon to page 737677 as ILM_TOOLKIT_USER the http page dies after 1 hour but there is a session in the database consuming 100% of 1 cpu and still running after _4 days_, with the current statement:
BEGIN
wwv_flow_custom_auth_std.login (p_uname => v ('P101_USERNAME'),
p_password => :p101_password,
p_session_id => v ('APP_SESSION'),
p_flow_page => :app_id || ':1'
);

BEGIN
ilm_toolkit.init_ctx (v ('APP_USER'), v ('APP_SESSION'));
END;

In the database we have:
•     job_queue_processes=2
•     ILM_TOOLKIT tablespace 10m
•     ILM_TOOLKIT_USER
•     APEX_040000 with DBA privilege

I ran this as sys with no errors:
@ilma_install apex_password ILM_TOOLKIT none
@ilma_post_install
@grant_privs ILM_TOOLKIT_USER
I also created ILM_TOOLKIT_USER in the workspace, default schema=ILM_TOOLKIT, password matches database password.
Sadly the ilm_toolkit package is wrapped so I cannot see what it is doing

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points