Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: upgrade 9i to 10g --> issues with connecting as sysdba

Re: upgrade 9i to 10g --> issues with connecting as sysdba

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 01 Aug 2006 11:09:36 -0700
Message-ID: <1154455776.925850@bubbleator.drizzle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US