Re: insufficient privileges

orcldba2001_at_gmail.com wrote:
> 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 -

Try:
select * from v$instance;

the select * from v$database has nothing to do with logging in as slash, or am I missing something? I might be, it's late... Received on Tue Nov 28 2006 - 00:52:51 CST