cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01031: insufficient privileges error

Former Member
0 Kudos

Microsoft Windows [Version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

E:\Documents and Settings\Administrator>sqlplus/nolog

SQLPlus: Release 10.2.0.2.0 - Production on Sun Jul 20 12:30:17 2008*

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

SQL> connect as sysdba

Enter user-name: system

Enter password:

ERROR:

ORA-01031: insufficient privileges

SQL>

iam using ecc6.0

any one give me solution

Edited by: Mugala Balu on Jul 20, 2010 9:05 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

My first question is why you are trying to connect your DB from Administrator user?

You don't have any DB admin (SIDADM or ORASID) in your landscape?

As told by above techies, just logoff from administrator and relogin with SIDADM then try....it should work.

Regards,

Nick Loy

Former Member
0 Kudos

hi,

try this :


set ORACLE_SID=<SID>
set ORACLE_HOME=<Home of your oracle installation>

sqlplus / as sysdba

regards,

Answers (4)

Answers (4)

Former Member
0 Kudos

This message was moderated.

Former Member
0 Kudos

Hi Mugala,

login with your <SID>adm user, then connect to your database as sqlplus /as sysd\ba.

hopefully it will resove your problem.

Regards,

Priya

Former Member
0 Kudos

Hi,

your logged on as "Admin"

Trying logging on as "sid<adm>" ora "ora<sid> and try again..

Mark

Former Member
0 Kudos

You can use the below command also to connect to database

sqlplus "/as sysdba"

if you again face the error, please logoff and login with SIDADM and try the above command.

thanks,

Mahendra