Re: Privileges

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 6 Feb 2003 19:58:48 -0000
Message-ID: <3e42bfda_3@mk-nntp-1.news.uk.worldonline.com>

"virgilio" <i_mac_at_libero.it> wrote in message news:1fpxik2.jw712h71d1s0N%i_mac_at_libero.it...
> Hi ,
> I have a problem with privileges in Oracle 9.2.0.1 installed on SunOS 9.
> I can't connect to oracle because running sqlplus I receive :
> connect / as sysdba
> error: ora-01031 insufficient privileges
> Same message with connect internal
> Any ideas
> Thanks Virgilio

This is just in case....
Assuming you installed as oracle, and are now connected as oracle, try

sqlplus '/ as sysdba'

sqlplus /nolog
connect / as sysdba

Note the quotes and the spaces.

Regards,
Paul

P.S. For Windows users, substitute double quotes for the single. Received on Thu Feb 06 2003 - 13:58:48 CST