Solved

Oracle E Business suite  11i Loging page takes 15 minutes to come up

Posted on 2010-11-23
4
1,330 Views
Last Modified: 2012-05-10
It takes a while for the login page to come up after restarting apache .A couple of parameters  have been changed but did not resolve the problem. Anyone run into something similar ?

Thanks
MNT
0
Comment
Question by:mngong_rc
  • 3
4 Comments
 

Author Comment

by:mngong_rc
ID: 34197120
The jserv.log mod_jserv.log  does not contain any errors .
error_log has the following for the duration of the time the logins
where not coming up

Client IP addresses have been replaced by x.x.x.x
[Mon Nov 22 20:36:25 2010] OPM:Can not find one alive process
[Mon Nov 22 20:36:25 2010] [client x.x.x.x] File does not exist:
[Mon Nov 22 20:36:25 2010] OPM:Can not find one alive process
[Mon Nov 22 20:36:25 2010] [client x.x.x.x] File does not exist:
[Mon Nov 22 20:36:25 2010] OPM:Can not find one alive process
[Mon Nov 22 20:36:25 2010] [client IP x.x.x.x] File does not exist:
[Mon Nov 22 20:36:25 2010] OPM:Can not find one alive process
[Mon Nov 22 20:36:25 2010] [client x.x.x.x] File does not exist

0
 
LVL 5

Accepted Solution

by:
anand_20703 earned 500 total points
ID: 34273454
Was it working before ?
If yes, what changes were made from working status to problem status?
What is the operating system?
Apache service startup comes faster ? or Does it also take 15 min ? means once apache startup script is executed, how much time it takes to see http processes to be visible as spawned ?
This is to isolate the problem between apache services startup and login page..
.
However few quick wins you can try.
1) Delete the log files under $ORACLE_HOME/Apache/Apache/logs directory. files here must have been piled up since long time. then restart Apache Service
2) if it is unix operating system, increasing the ulimit parameters would definetely help.i.e,
open files , stack size. To see all ulimit parameters, check the output of ulimit -as command.
3) reboot the server and then start the services and see if it makes any difference in your problem
4) Another importnat point: Dont start the Concurrent Manager.i.e.,
start the database,listener
start the application tier including the apache
check the page if it comes faster ... (assuming that if the concurrent tier is up& running, then that may cause to spawn concurrent requests and running concurrent requests will put load on the instance and could also cause apache slowness/login page slowness)



0
 

Author Comment

by:mngong_rc
ID: 34393072
Have not been able to  test because it is production and have been working with oracle support .
Sorry no fix yet since issue is intermittent

Thanks
MNT
0
 

Author Comment

by:mngong_rc
ID: 34499622
The number of JVMs was increased from one to three and that seemed to have
"resolved" the issue

Please grant point to user whe responded

MNT
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Usually shares are where we want them for our users and we tend to take them for granted. There are times, however, when those shares may disappear causing difficulty for your users. One of the first things to try is searching for files that shou…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now