Re: Connecting as sysdba

It's generally a good idea to use google before asking questions. Few people go where others have not gone before. http://www.google.com/search?q=sysdba+dbd%3A%3Aoracle Tim. On Tue, Sep 24, 2002 at 11:21:37AM -0400, Jeff Hunter wrote: > > I use perl to automate various Database Administration

RE: Connecting as sysdba

That surely is a fine manual. -Original Message- From: Michael A Chase [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 5:38 PM To: Jeff Hunter; [EMAIL PROTECTED] Subject: Re: Connecting as sysdba On Tue, 24 Sep 2002 11:21:37 -0400 Jeff Hunter <[EMAIL PROTECTED]>

Re: Connecting as sysdba

On Tue, 24 Sep 2002 11:21:37 -0400 Jeff Hunter <[EMAIL PROTECTED]> wrote: > I use perl to automate various Database Administration tasks for several > Oracle databases. With Oracle 9.x, to perform certain administrative > tasks, > you must connect as sysdba. From sqlplus, the syntax is: > sqlpl

Connecting as sysdba

I use perl to automate various Database Administration tasks for several Oracle databases. With Oracle 9.x, to perform certain administrative tasks, you must connect as sysdba. From sqlplus, the syntax is: sqlplus "/@dbname as sysdba" Does anybody know of a way to simulate this type of connect

Connecting as sysdba using DBI

Hi, First timer on this list so please excuse me if this is rather basic... Can anyone point me to some information on how to connect to a database as sysdba using dbi? I want to be able to connect as sys but without hardcoding passwords. Thanks Jo

Re: connecting "/ as sysdba" when using DBI/DBD-Oracle

At 11:36 -0500 27/4/01, Jay Strauss wrote: >You mean you can't startup and shutdown oracle from DBI? > >That was the whole plan I have never managed. There is certainly no 'startup' or 'shutdown' command that can be passed straight through as a statement. I suspect, for no rational reason that

Re: connecting "/ as sysdba" when using DBI/DBD-Oracle

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

Re: connecting "/ as sysdba" when using DBI/DBD-Oracle

Oh, I forgot: To do what you originally asked: $dbh = DBI->connect("DBI:Oracle:", "internal","",{ ora_session_mode => 2 }); Regards Paul Miller -- - Carib Data Limited

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

connecting "/ as sysdba" when using DBI/DBD-Oracle

Hi, Preface: I'm not part of this mailing list, so if you respond, please cc me on the message. I've tried to search the archives, but could not find a searchable archive (current archives only go back 3 pages), searched google, read the FAQ... anyway, I apologize if this question gets asked on