[lugm.org] Oracle db on debian 6 ia64

Wed Jun 1 05:44:41 UTC 2011

Hah I managed to get back in track, I rebooted and enabled "physical drive
write cache" though it warned me about the "disaster" that might occur if
blade is not ups protected.

It seems that the box is functioning normally.

A quick answer: the motivation here is that I'm tired with hp support,
according to hp patches are released and tested, but when you apply, it
always breaks something & the crazy unlimited user licenses.

Oracle: we are running oracle ee which indeed is damn expensive, moved from
oracle se that was on the old rx2620. 

I even tried freebsd, unfortunately the fiber daughtercard was incompatible,
else I would have carried on with it.

Oracle works fine on oracle though its unsupported, anyway I don't need any
"oracle level" support from oracle. Suse ent & red hat is a waste of money.

kn

From: ashvin.saminathen at gmail.com [mailto:ashvin.saminathen at gmail.com] On
Behalf Of ashvin saminathen
Sent: Wednesday, June 01, 2011 3:25 AM
To: kn at debian.mu; LUGM Discuss Mailing List
Subject: Re: [lugm.org] Oracle db on debian 6 ia64

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#Config
uring%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 BlackBerryR 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 BlackBerryR 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/6cd7ce68/attachment.html>