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: ORA-01301 errors with 9.2

Re: ORA-01301 errors with 9.2

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 05 Dec 2005 14:09:16 -0800
Message-ID: <1133820538.667431@jetspin.drizzle.com>


ttyp32000_at_yahoo.com wrote:
> hey all,
>
> I'm trying to connect to an oracle 9.2 version as sysdba, using the
> string
>
> sqlplus 'sys/....._at_INSTANCE as sysdba'
>
> but am running into a
>
> ORA-01301: Insufficient privileges
>
> error. I get this error even when running as the oracle user in unix. I
> do have the correct password; there's something about the oracle
> instance that just isn't right.
>
> So.. how do I set this up? I know about the sysdba privilege, as in
> 'grant sysdba to ....' but since I can't login *as* sysdba, I'm having
> issues. Help would be greatly appreciated.
>
> Thanks much,
>
> Ed

log onto the operating system as the owner of the Oracle binaries. log on using SQL*Plus with: / as sysdba

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Dec 05 2005 - 16:09:16 CST

Original text of this message

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