Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: upgrade 9i to 10g --> issues with connecting as sysdba
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 DBAReceived on Tue Aug 01 2006 - 13:06:59 CDT