On Tue, 26 Nov 2002 20:17:47 -0800 (PST) Lin Feng <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I tried to connect to a Oracle 9i db (system as sysdba) with the
> following:
>
> my $dbh = DBI->connect('dbi:Oracle:AM922X', 'system', 'pass1', {
> ora_ession_mode => 2 });
>
> and I got the following:
>
> DBI->connect(AM922X) failed: ORA-01031: insufficient privileges (DBD
> ERROR: OCISessionBegin) at test3.pl line 9 (i.e. the above line).
>
> The same result when I login to the unix box as oracle or a regular
> user. Am I missing something? Any workaround?
The UNIX user you are logged in as may need to belong to the OSDBA UNIX
group. That group is 'dba' by default, but is likely to be different at
many sites, so check with your DBA.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
