Sybrand Bakker wrote:
> On 1 Aug 2006 09:33:48 -0700, "afshin" <riazati_at_gmail.com> wrote:
>
>> Hi,
>>
>> - I just installed oracle10g on solaris enviroment where there was
>> oracle 9i running.
>>
>> - OS user oracle is the owner of oracle 9i
>>
>> - I created new user oracle10 and installed oracle 10g with the new
>> user as part of groups : oinstall, dba, oper
>
> Why on earth? Were you instructed by the installation manual to do so?
> A separate Oracle home suffices
>> - After setting up my enviroment variables accordingly, now I want to
>> connect as sysdba with this oracle10 user:
>>
>> $ sqlplus /nolog
>>
>> SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 1 12:31:46 2006
>>
>> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>>
>> SQL> conn sys as sysdba
>> Enter password:
>> ERROR:
>> ORA-01031: insufficient privileges
>>
>>
>> SQL>
>>
>>
>> Any idea where I need to touch for getting this privileges?
>
> Just search Google (which you didn't do) or the documentation (which
> you didn't do) or Metalink (which you didn't and which has a doc
> specifically about this issue).
>
> --
> Sybrand Bakker, Senior Oracle DBA
And after you do that set ORACLE_HOME and ORACLE_SID.
--
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
Received on Tue Aug 01 2006 - 13:09:36 CDT
