You mean you can't startup and shutdown oracle from DBI? That was the whole plan Jay ----- Original Message ----- From: "PD Miller" <[EMAIL PROTECTED]> To: "Jay Strauss" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, April 27, 2001 10:56 AM Subject: Re: connecting "/ as sysdba" when using DBI/DBD-Oracle > At 10:23 -0500 27/4/01, Jay Strauss wrote: > >$ sqlplus "/ as sysdba" > > > >The benefit to this method, as opposed to: > > > >$ sqlplus system/manager > > > >being, I don't have to include my database password in any script. Does > >anyone know how to do this in DBI/DBD-Oracle? I see in the doc you can do > >it like: > > If you don't need to be sysdba (and really you don't since you won't > be able to do the only two distinguishing actions: startup and > shutdown), I suggest that you look at external authentication. > > Very short course: > > # useradd -g dba scripter > > SQL> alter user ops$scripter identified externally; > > % sqlplus / > > $user = $passwd = ''; > $dbh = DBI->connect( $dsn, $user, $passwd ) > > Note that the external identification prefix (here shown as the > default 'OPS$' may have to be defined in your init.ora file > (os_authent_prefix = ops$. > > Regards > > Paul Miller > -- > - > Carib Data Limited > > <mailto:[EMAIL PROTECTED]> > <http://www.caribdata.co.uk> _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
