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: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 27 Nov 2006 16:37:01 -0800
Message-ID: <1164674220.851340@bubbleator.drizzle.com>


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 -

Please don't top post. Scroll to the bottom to reply.

Is there a discrepancy between the SERVICE_NAME in SQLNET.ORA and TNSNAMES.ORA? Look for a domain name that may be appended.

-- 
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 Mon Nov 27 2006 - 18:37:01 CST

Original text of this message

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