Problem with ulimit on HP-UX 11.11

[Sajith Kumar_1]

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...

[Prashant Zanwar_4]

You can put
ulimit file unlimited in oracle .profile.

or in .profile of user who runs backup.

Hope this helps

Prashant

[Sundar_7]

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

[Sajith Kumar_1]

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?

[Sยภเl Kย๓คг]

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

[Dennis E. James]

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
$<