Sone like Shell'd, some like it Perl'd ... what can I say ... my SA is reluctant to put some required packages for perl. Soon we will get our own linux servers for the 10gOEM (RAC) install ... it will be _our_ playbox, so I am planning to load it up with some much needed goodies. Still, since we don't trust dbms_job and use cron, the syntax below works just fine for us ... Raj --- "Goulet, Dick" <DGoulet@xxxxxxxx> wrote: > You'd know Jared only likes it if it comes Perl'd!! > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > > -----Original Message----- > From: Jared.Still@xxxxxxxxxxx [mailto:Jared.Still@xxxxxxxxxxx] > Sent: Tuesday, July 20, 2004 11:56 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: Database connection from remote server > > > > we like to put passwords in the scritp env then execute something = > like=20 > >=20 > > . /etc/profile > > . ~/.profile > > # next line exports the passwords > > . $HOME/bin/orapw=20 > > echo $imspw | sqlplus -S ims@xxxxxxxxx @ims_script.sql > > exit > I personally prefer using the password server in the PDBA toolkit. > > www.oreilly.com/catalog/oracleperl :) > > Now with encrypted config files. > ( though that feature hasn't yet made its way to the O'Reilly site) > > Jared ===== Best Regards Raj --------------------------------------------------------- select mandatory_disclaimer from company_requirements; __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------