Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: osh/oraenv for users w/ low file size limit - not for scripts?

Re: osh/oraenv for users w/ low file size limit - not for scripts?

From: Mark Brinsmead <pythianbrinsmead_at_gmail.com>
Date: Mon, 31 Jul 2006 08:05:47 -0600
Message-ID: <cf3341710607310705x669b846eia61e80d2a1f6c53b@mail.gmail.com>


Perhaps I have missed something here -- I don't think I've seen the entire thread -- but perhaps you could achieve your objective by placing the following line at the beginning (i.e., *first* line) of your shell script:

#!/usr/local/bin/osh

Then your entire shell script will (should) be executed by osh.

I wouldn't really know, though, as I have never seen a system where "osh" was actually used. Usually I set the "ulimits" appropriately high for *all* necessary users, and pretty much every database server I have seen in years does the same...

(Actually, I usually set the ulimits for *all* users on the database server, but in my universe, only DBAs and sysadmins ever login to the database server. Usually, at least. With modern UNIXEN where kernel resources are allocated dynamically, there is much less reason *not* to do this than there was 10 years ago...)

Anyway, this might work for you. Good luck.

--

Cheers,
-- Mark Brinsmead

   Staff DBA,
   The Pythian Group
   http://www.pythian.com/blogs

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 31 2006 - 09:05:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US