Re: perl connection "/ as sysdba" doesn't work for me on solaris

Tasm wrote:
> I'm trying to connect "/ as sysdba" (without using a username or
> password) as the documentation says
> http://search.cpan.org/dist/DBD-Oracle/Oracle.pm
>
> I can connect as follows:
>
> sqlplus '/ as sysdba'
>
> but not using the following perl example from the same oracle account
>
> $dsn = "dbi:Oracle:"; # no dbname here
> $ENV{ORACLE_SID} = "orcl"; # set ORACLE_SID as needed
> delete $ENV{TWO_TASK}; # make sure TWO_TASK isn't set
> $dbh = DBI->connect($dsn, "", "", { ora_session_mode => ORA_SYSDBA });
>
>
> The above perl results in the following error message:
>
> DBI->connect failed: ORA-01017: invalid username/password; logon denied
> (DBD ERROR: OCISessionBegin)
>
> The DBA_AUDIT_TRAIL lists the failed logon username as OPS$ORACLE.
>
> I'm trying this on Solaris 8 on a 8.1.7.4 database with the following
> version of perl -v
>
> This is perl, v5.6.0 built for sun4-solaris
>
> Whenever I use a username and password with my perl scripts I don't have
> a problem
> ; however, I would like to be able to connect without usernames and
> password in the same way as I can connect from sqlplus.

What is the business case for using perl to log in as SYS? This seems like a violation of common-sense security procedures. What is it you are doing?

Oracle is making the assumption that you are trying to log in using an externally authenticated account. Since the Solaris user is oracle it is prepending the OPS$.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org