[lugm.org] Oracle db on debian 6 ia64

[ashvin saminathen]

just a quick question, not really relevant to your problem.but what
motivated the shift from hp-ux to debian, particularly on integrity?
I deployed some rx6600 a few years back, and i can't really see the logic in
moving from HP-UX to linux on integrity... even from a financial point of
view, since you are running on a 4 processor machine, you must be on oracle
EE DB, pretty sure 16 processor oracle licenses and support are much more of
a burden than the hp-ux licenses and support...

coming back to your original question, i only worked with prod oracle on
solaris or hp-ux, but i found the following article... maybe it can help you
:
http://www.idevelopment.info/data/Oracle/DBA_tips/Linux/LINUX_8.shtml#Configuring%20Oracle%20User%20Shell%20Limits
also how's your swap configurations?

p.s
if you get fed up of dealing with HP and paying those crazy prices, gimme a
call, I know of a great Japanese company who are very accommodating when it
comes to servers :)

On 31 May 2011 21:22, <kn at debian.mu> wrote:

> Yea the prompt appears immediately when oracle is not running! Increasing
> the wide limits helped a lot, to which value can I extend it? I've never
> dealt with these kind of issues before.
>
> Sent from my BlackBerry® wireless device
>
> -----Original Message-----
> From: Ajay R Ramjatan <ajay.ramjatan at gmail.com>
> Date: Tue, 31 May 2011 18:17:10
> To: <kn at debian.mu>; LUGM Discuss Mailing List<discuss at lugm.org>
> Subject: Re: [lugm.org] Oracle db on debian 6 ia64
>
> Silly question perhaps but you did narrow down the culprit being
> Oracle right? If Oracle is not running, then the prompt appears
> immediately?
>
> On Tue, May 31, 2011 at 18:03,  <kn at debian.mu> wrote:
> > Hello Systems Admins / Engineers,
> >
> > I need some advise;
> >
> > I've migrated from an old hp integrity rx2620 server running hp ux 11b)
> to an integrity bl870c i2 blade with the following specs:
> >
> > 4x itanium 9340
> > 704gb ram (44x 16gb ram sticks)
> > 4x300 gb @ 15k rpm sas (raid 1 with 2 online spares for os only)
> > OS: debian 6.0.2
> >
> > Oracle 11g r2 is being run on the server and databases stored on an hp
> eva 4400.
> >
> > The problem started when the blade celebrated its first day in
> production! The shell prompt appears 15mins after hitting the password!
> Tried to log in via ssh, it took approx one hour for the prompt to display!
> >
> > Oracle advised to dismount all databases and increase file descriptors, I
> adjusted the oracle user a soft & hard limit of 100000 / 9999999 in
> /etc/security/limits.conf. Appended fs.file-max = 9999999 in
> /etc/sysctl.conf , did a sysctl -p & rebooted.
> >
> > Prompts now appears after approx 8 mins on console, 35 mins via ssh..
> >
> > To which extent can I increase the wide limits?
> >
> > Any help would be greatly appreciated.
> >
> > kn
> > Sent from my BlackBerry® wireless device
> >__________________________________________________________
> > Linux User Group of Mauritius (LUGM) Discuss mailing list
> > Website: http://lugm.org
> > Mailing list archive: http://lugm.org/pipermail/discuss_lugm.org/
> > Forum: http://lugm.org/forum/
> > IRC: #linux.mu on Freenode
> >
> __________________________________________________________
> Linux User Group of Mauritius (LUGM) Discuss mailing list
> Website: http://lugm.org
> Mailing list archive: http://lugm.org/pipermail/discuss_lugm.org/
> Forum: http://lugm.org/forum/
> IRC: #linux.mu on Freenode
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://discuss.lugm.org/pipermail/discuss_discuss.lugm.org/attachments/20110601/ba40aec2/attachment.html>