Oracle App Servers can't both be up at once

[Lala]

I need an Oracle guru - I have a CI and two app servers. I can bring the CI and one app server (either APP1 or APP2) up at the same time but not both app servers.

If I try to bring the second app server up also, weird database related stuff happens. Like you know how fast doing a "lsnrctl status" usually runs? Well, it takes several minutes to run with the 2nd app server up. And the connection to TMS takes forever if it connects at all. All there connection errors vary in time, One TMS connection may take 1 minute and then the exact same connection can take 10 minutes the next time.

Once the 2nd app server is taken down, the CI and first app server run fine and all the connecting go back to normal. So it sounds like same kind of resource limit being hit to me but I don't know Oracle well enough to pin-point it. Can someone help? The DB is on clustered MSCS and the CI and app servers on non-MSCS. All are Windows x64 with at least 16gig of physical RAM and 38gig swap files.

Many thanks!!!

[Mirna]

Sounds to me like you possibly don't have enough 'processes' and 'sessions' set in your init<SID>.ora? (/oracle/<SID>/102_64/dbs/)

Either that or the CI and APP you are runniing are already taking all your resources?

[Lala]

That's the first thing I thought of so I upped initBIQ.ora to processes = 500 and sessions = 600. And neither DB or CI is close to maxing their resources.

[Portal]

Have you restarted Oracle after changing these parameters?

Read SAP note 830576 to get formula to use to sessions and processes.

[Lala]

Yes, that is one of the OSS Notes that SAP had us run through.