Re: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-25 Thread Jared Still
it. > > Anyway, thanks for the help. > George > > > -Original Message- > > From: Jared Still [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, January 13, 2003 5:10 AM > > To: Georg Botorog; Tim Bunce > > Cc: [EMAIL PROTECTED] > > Subje

Re: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-21 Thread Tim Bunce
On Thu, Jan 16, 2003 at 01:41:55PM -, Steve Haslam wrote: > > Hmmm, I haven't used apptrace on Solaris, but using ltrace on Linux: Ah, cool. Thanks for demonstrating that. > bash# ltrace -e `nm -D $ORACLE_HOME/lib/libclntsh.so.8.0 | awk '$3 ~ /^OCI/ > { print $3 }' | perl -le 'print join(","

RE: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-16 Thread Steve Haslam
>> Tim On Sun, Jan 12, 2003 at 08:10:26PM -0800, Jared Still wrote: > > Georg, > > I don't think DBD::Oracle knows about the 'shutdown' and > 'startup' commands. These are database control features > that were previously available only svrmgrl, and are now > standard in sqlplus. > > It seems

Re: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-15 Thread Tim Bunce
, I have downloaded this package recently (the day I > > wrote the first mail) with ppm. > > > > Any suggestion? Thanks. > > > > > -----Original Message- > > > From: Tim Bunce [SMTP:[EMAIL PROTECTED]] > > > Sent: Monday, December 30, 200

RE: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-13 Thread Georg Botorog
package belonging to DBD::Oracle or that I have an older version > > thereof. However, I have downloaded this package recently (the day I > > wrote the first mail) with ppm. > > > > Any suggestion? Thanks. > > > > > -Original Message- > > > From:

Re: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-12 Thread Jared Still
sage- > > From: Tim Bunce [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, December 30, 2002 1:11 PM > > To: Jared Still > > Cc: Georg Botorog; [EMAIL PROTECTED] > > Subject:Re: Problem with login as sysdba in DBI/DBD::Oracle > > > > On Tue, Dec

Re: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-07 Thread Michael A Chase
On Mon, 6 Jan 2003 12:45:47 +0100 Georg Botorog <[EMAIL PROTECTED]> wrote: > I'm afraid I have not succeeded in making myself understood. The problem > is neiher selecting from V$... nor determining my own SID, the problem > is that my login is not done "as sysdba". Therefore, in particular, I > c

RE: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-07 Thread Georg Botorog
rote the first mail) with ppm. Any suggestion? Thanks. > -Original Message- > From: Tim Bunce [SMTP:[EMAIL PROTECTED]] > Sent: Monday, December 30, 2002 1:11 PM > To: Jared Still > Cc: Georg Botorog; [EMAIL PROTECTED] > Subject: Re: Problem with login as sysdba

Re: Problem with login as sysdba in DBI/DBD::Oracle

2003-01-06 Thread Tim Bunce
Sent: Monday, December 30, 2002 1:11 PM > > To: Jared Still > > Cc: Georg Botorog; [EMAIL PROTECTED] > > Subject:Re: Problem with login as sysdba in DBI/DBD::Oracle > > > > On Tue, Dec 24, 2002 at 07:31:00AM -0800, Jared Still wrote: > > > > >

Re: Problem with login as sysdba in DBI/DBD::Oracle

2002-12-31 Thread Jared Still
Thanks Tim. Just need to read the DBI docs again I guess. Jared On Monday 30 December 2002 04:11, Tim Bunce wrote: > On Tue, Dec 24, 2002 at 07:31:00AM -0800, Jared Still wrote: > > The problem you are having is most likely due to your > > use of v$session_connect_info. Getting your own sessio

Re: Problem with login as sysdba in DBI/DBD::Oracle

2002-12-30 Thread Tim Bunce
On Tue, Dec 24, 2002 at 07:31:00AM -0800, Jared Still wrote: > > The problem you are having is most likely due to your > use of v$session_connect_info. Getting your own sessions > SID and using it to choose the correct row from v$session_connect_info > is notoriously tricky. > > Try doing this i

Re: Problem with login as sysdba in DBI/DBD::Oracle

2002-12-24 Thread Jared Still
The problem you are having is most likely due to your use of v$session_connect_info. Getting your own sessions SID and using it to choose the correct row from v$session_connect_info is notoriously tricky. Try doing this instead: my $sql=q{select sys_context('userenv', 'authentication_type') aut