topic Problem with ulimit on HP-UX 11.11 in Operating System - HP-UX

Problem with ulimit on HP-UX 11.11

Sajith Kumar_1 — Wed, 29 Sep 2004 15:26:57 GMT

Hello,

I have a problem with process ulimit. There is a backup job scheduled through cron to take backup of Oracle database and observed that the backup process keep failing with an error "Error opening database file". The corresponding Oracle error indicate (in metalink site) this is due to the ulimit value of the client process being lower than the required value.

This problem is not happening every time and noticed that the backup job failed whenever somebody run a "at now" command.

Can anyone help me in finding a solution for this...

Re: Problem with ulimit on HP-UX 11.11

Prashant Zanwar_4 — Wed, 29 Sep 2004 15:31:30 GMT

You can put
ulimit file unlimited in oracle .profile.

or in .profile of user who runs backup.

Hope this helps

Prashant

Re: Problem with ulimit on HP-UX 11.11

Sundar_7 — Wed, 29 Sep 2004 15:43:40 GMT

Sajith,

When jobs are created using at, in order to create the same shell environment when the job is run, AT automatically appends all of the current environment settings to the job.

This also includes the ulimit value of the shell from which the "at" command is executed.

It is a good practise to set the ulimit value to unlimited in the scripts that does the database export.

Or else set the ulimit value of the shell to unlimited before scheduling the job using at

- Sundar

Re: Problem with ulimit on HP-UX 11.11

Sajith Kumar_1 — Wed, 29 Sep 2004 19:44:55 GMT

Hi Sundar & Prashant,

Thanks for the immediate respond and the solution.

I was just going through one of the site giving some problem on Oracle tips. They says to load a patch (PHCO_27019 (11.11)
which should make the ulimit values for ksh to unlimited). Could you please give your suggetion on this?

Re: Problem with ulimit on HP-UX 11.11

Sยภเl Kย๓คг — Thu, 30 Sep 2004 07:17:56 GMT

Have a look at these
http://robelle.com/tips/oracle.html
http://www.uwo.ca/cgi-bin/rmanx.pl?topic=ulimit/section=1
http://www.unixguide.net/hp/faq/5.10.3.shtml
regards
SK

Re: Problem with ulimit on HP-UX 11.11

Dennis E. James — Thu, 30 Sep 2004 08:45:10 GMT

We have experience the same problems in the past with at jobs and oracle. We made the following correction to our .proto file located in /var/adm/cron then stopped and restarted the cron daemon.
# @(#)B.11.11_LR
cd $d
#WTEC workaround for
if [ $l -eq 4194303 ]
then
ulimit unlimited
else
ulimit $l
fi
umask $m
$<