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: insufficient privileges

Re: insufficient privileges

From: <orcldba2001_at_gmail.com>
Date: 27 Nov 2006 13:45:20 -0800
Message-ID: <1164663920.408148.227750@45g2000cws.googlegroups.com>

Oracle_HOME=d:\oracle\ora92
oracle_sid=abc

when I login to the instance and run the following command select name from v$database
the name shows up as abc

On Nov 27, 1:32 pm, "hpuxrac" <johnbhur..._at_sbcglobal.net> wrote:
> orcldba2..._at_gmail.com wrote:
> > Oracle version 9.2.0.4.0
> > OS = Windows 2000 server
>
> > I have a domain account on a server and I am a member of
> > ORA_DBA and Adminstrator group
>
> > I open a command window and set
> > oracle_home and
> > oracle_sid
>
> > However when I try to login without a password
>
> > sqlplus
>
> > SQL*Plus: Release 9.2.0.4.0 - Production on Mon Nov 27 13:08:28 2006
>
> > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> > Enter user-name: /as sysdba
> > ERROR:
> > ORA-01031: insufficient privilegesORACLE_HOME and ORACLE_SID ?- Hide quoted text -- Show quoted text -
Received on Mon Nov 27 2006 - 15:45:20 CST

Original text of this message

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